For example, the following dashboard built using Looker Studio shows charts and reports for facility inspections.
To visualize your app data using Looker Studio:
- Create an AppSheet data source in Looker Studio
- Use Looker Studio to visualize data in your AppSheet app
See also: Quick start: Visualize your app data using Looker Studio
Create an AppSheet data source in Looker Studio
Create an AppSheet data source in Looker Studio that is associated with your AppSheet account. You can create an embedded or reusable data source. See Embedded versus reusable data sources.
The following steps describe how to create a reusable data source:
- Sign in to Looker Studio.
- Select Create > Data source.
- Edit the data source name and click AppSheet.
-
If prompted, click Authorize and follow the prompts to authorize access to your AppSheet account.
- Select the region to connect to in the Region drop-down.
- Select the app to access the data source in the Application field.
- Click Next.
- Select a table to use as the data source in the Table field.
- Click Connect.
Use Looker Studio to visualize data in your AppSheet app
Use Looker Studio to visualize data in your AppSheet app as described in the following sections.
Configure the data source
The data source fields panel is where you configure the data source by renaming fields and adding descriptions, adding calculated fields, and changing data types and aggregations. Learn more about working with data source fields.
Control who sees the data
At the top of the fields panel, you can change the data credentials. Credentials control who can see the data that this data source provides.
OWNER'S CREDENTIALS let other people view or create reports that use this data without requiring them to have their own access to the dataset.
VIEWER'S CREDENTIALS, on the other hand, require each user of the data source to provide their own credentials to access the dataset.
Learn more about data credentials.
Create a new report from the data source
To create a new report from the data source, follow these steps:
- In the upper right, click CREATE REPORT. The report editor appears.
- Click ADD TO REPORT.
- This action adds the data source to the report.
- You can now create charts and controls that get their data from this data source.
New to Looker Studio?
Take the Create a report tutorial. Or learn more about the report editor.