Transfer data from BigQuery to Google Sheets Automatically

Connect and transfer data from BigQuery to Google Sheets
Reading Time: 3 minutes

Google BigQuery is a fully-managed data warehouse where you can store, analyse data assess the data. It gives you a bird’s eye view of your data. For a more granular analysis, though, Google Sheets would serve a better purpose. A worm’s eye view from Google Sheets combined with the bird’s eye view from BigQuery will give a more complete view of the picture thus minimising the chance of minute but critical trends being overlooked.

Another benefit of connecting BigQuery data to Google Sheets is the ability to easily share the data and collaborate with team members and clients.

We can transfer data from BigQuery to Google Sheets by connecting them using a Google Sheets extension–Amigo–and retrieve the data automatically and periodically.

Let’s learn how to connect BigQuery to Google Sheets and import BigQuery data to Google Sheets.

Steps to connect and transfer data to BigQuery to Google Sheets

Install the Amigo extension in Google Sheets

The Amigo add-on acts as a bridge allowing you to move data from BigQuery to Google Sheets.

Get it from the Google Workspace Marketplace by clicking the link given below.

Amigo Data in Google Workspace Marketplace

Amigo installation link

Alternatively, you can get it from within Google Sheets itself.

  • Open a Google Sheets document
  • Go to Extensions→Add-ons→Get add-ons
  • Search for Amigo and install

Once the installation is complete, the Amigo add-on should appear in your Google Sheets Extensions list.

Connect BigQuery to Google Sheets

Open Google Sheets and launch Amigo by clicking Extensions→Amigo: Data Exports and Reports→Connect.

Connecting to Amigo

From the list of available sources to connect select BigQuery and click Import from Tables.

Select the source to connect
The project ID in Google API Console
Creating a connection

Transfer data from BigQuery to Google Sheets

On the dashboard to the left is a list of data tables. Click on any one of them to preview.

List of data tables

All metrics will be selected automatically. Unselect those that you don’t require and set a limit to the number of items to import with the limit button.

Preview of the data

Name the report if you need to and then click the IMPORT button. In a few seconds the data from BigQuery will be imported into Google Sheets.

BigQuery data imported to Google Sheets

If you want the data to be updated periodically, set a refresh schedule by clicking the Yes, set a refresh timing. Or you can set it up later. To learn more on how ot set a refresh schedule and set up alerts to receive the report in your inbox or Slack, click here.

Amigo can connect Google Sheets to multiple sources and allows you to import data automatically. It is a convenient and versatile tool to import and export data to Google Sheets. Visit our blog to discover more.

Some related articles you may find useful:
Importing MySQL Data to Google Sheets

Import Data From Amazon Redshift To Google Sheets

How to Connect Amazon Marketplace to Google Sheets

Export Data From Snowflake To Google Sheets