Skip to main content

Visualizing your data on Google Sheets

Did you know you can sync your data to a Google Sheet AND keep it up to date?

Romulo Gomes avatar
Written by Romulo Gomes
Updated over 3 weeks ago

We get it: sometimes it's just easier to play with the data on a nice spreasheet instead of building charts one by one.

In the video below you'll learn how to do that if you're using BigQuery or our Looker Studio Connectors ๐Ÿ‘‡

Key Steps

Step 1: Access Google BigQuery 0:00

generated-image-at-00:00:00

  • Open your web browser and navigate to Google Sheets.

  • Go to the 'Destinations' section and select 'Google BigQuery'.

  • This will display the names of all your tables and datasets.

Step 2: Open BigQuery Console 0:40

generated-image-at-00:00:40

  • In a new tab, go to the BigQuery console by entering the URL: console.cloud.google.com/bigquery.

  • Ensure you are logged into your Google account.

Step 3: Locate Your Project 1:03

generated-image-at-00:01:03

  • Find your project name in the BigQuery console. For example, 'EasyAppReports'.

  • Click on your project to view the datasets.

Step 4: Identify the Dataset and Table 1:12

generated-image-at-00:01:12

  • Browse through your datasets to find the one you need (e.g., App Store, Search Ads).

  • Locate the specific table you want to use, such as 'App Store Analytics Downloads'.

Step 5: Connect to Google Sheets 1:53

generated-image-at-00:01:53

  • Click on the table you want to connect to.

  • Select the option to open in Google Sheets.

Step 6: View and Refresh Data 2:14

generated-image-at-00:02:14

  • Your data will now appear in Google Sheets.

  • You can create pivot tables and other analyses from this data.

  • To refresh the data, click the refresh button or schedule a refresh (e.g., every 12 hours).

Step 7: Alternative Method Using Looker 3:13

generated-image-at-00:03:13

  • In Looker, click 'Create a data source'.

  • Select 'BigQuery' and choose your data source and report type.

  • Create your report layout and add necessary fields.

Step 8: Exporting Data 4:43

generated-image-at-00:04:43

  • Click on 'More' and choose to export the data.

  • You can export as a CSV or Google Sheet, but note that this will be a static snapshot of the data.

Cautionary Notes

  • Ensure you have the necessary permissions to access BigQuery and Google Sheets.

  • Be aware that exporting data from Looker creates a static snapshot, which will not update automatically.

Tips for Efficiency

  • Schedule regular refreshes in Google Sheets to keep your data up-to-date without manual intervention.

  • Familiarize yourself with the dataset names and structures to streamline the process of locating the data you need.

Did this answer your question?