How it works?
Looker Studio is data visualization tool by Google. It turns your data into informative dashboards and reports that are easy to read, easy to share, and fully customizable.
For Looker Studio to work, there needs to be a connector that brings data from the required application (e.g. Google Sheets, Database, CRM, Accounting, Marketing etc apps).
How it works?
Choose a connector from Google Google Looker Studio Gallery e.g "Insightly CRM"
Authorise Connector - Give permission for the Connector to work in your Google account
Authenticate the Application - Establish connectivity with the source application (e.g. Insightly) through
Key or
OAuth authentication
Choose the Object/ Entity you want to use -
The available fields from the Object/ Entity is listed .
Use this as a data source and continue normally with designing your report in Looker Studio.
You can customize the dashboard as you want.
Data from these fields will now be available for you to present in the Looker Studio Report