Visualize your app data using Looker Studio

Looker Studio (formerly Data Studio) is a free reporting and dashboarding tool that enables you to generate fully customizable visualizations of your app data. You can combine data from multiple data sources to generate a rich dashboard to share with stakeholders.

For example, the following dashboard built using Looker Studio shows charts and reports for facility inspections.

To visualize your app data using Looker Studio:

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:

  1. Sign in to Looker Studio.
  2. Select Create > Data source.
  3. Edit the data source name and click AppSheet.

    Set the name to My Data Source and search for and click AppSheet
  4. If prompted, click Authorize and follow the prompts to authorize access to your AppSheet account.

    AppSheet integration dialog prompting for username and token

  5. Select the app to access the data source in the Application field.
  6. Click Next.
  7. Select a table to use as the data source in the Table field.
  8. Click Connect.

Use Looker Studio to visualize data in your AppSheet app

You must be an app creator or app editor to visualize your app data using Looker Studio. You can only access your AppSheet apps created with the same Google account.

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 provided by this data source.

OWNER'S CREDENTIALS lets other people view or create reports that use this data without requiring them to have their own access to the data set.

VIEWER'S CREDENTIALS, on the other hand, requires each user of the data source to provide their own credentials to access the data set.

Learn more about data credentials.

Create a new report from the data source

  1. In the upper right, click CREATE REPORT.
    1. The report editor appears.
  2. Click ADD TO REPORT.
    1. This adds the data source to report.
    2. 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.


Was this helpful?

How can we improve it?

Need more help?

Try these next steps:

Clear search
Close search
Google apps
Main menu
Search Help Center