Connect your BigQuery to Google Sheets
Effortlessly connect your BigQuery data to Google Sheets for simplified reporting and analysis.
Why use Superjoin’s Google Sheets-BigQuery Integration?
Quick and Easy Integration
We’ve meticulously organized the data points to ensure easy accessibility in a format you’re already familiar with.
Preview your imports visually
Get a sneak peek of your data. Select columns, apply filters & limits as per your need before importing.
Automatic Refreshes
Enjoy one-click refreshes or schedule regular updates to ensure your sheets are always up to date.
Power of Google Sheets
Benefit from Google Sheets’ collaborative data analysis & other powerful capabilities.
Step-by-step walkthrough: How to connect BigQuery to Google Sheets.
Get Add-ons
Select Add-ons and choose Get Add-ons. This action will redirect you to the Google Workspace Marketplace.
Search Superjoin
In the Google Workspace Marketplace pop-up window, search for “Superjoin”.
Click on Install
Click on the Install button to install Superjoin.
Launch Superjoin
Once installed, navigate back to the Extensions menu tab in Google Sheets. Launch Superjoin from here. You should now see Superjoin running as a side panel on the right side of your screen.
Navigate to Queries
To begin, you can navigate to Queries , choose to Create new query.
Connect a New Source
Navigate to Sources, select Connect to a new source and search for BigQuery.
Enter Connection Details and Authorize
Enter your Project ID, which is the GCP project ID associated with the BigQuery dataset.
Once this is done click on Authorize to allow Superjoin to access your BigQuery data.
Choose a Query Method
Choose between three query methods through which you would like to import.
Enter your SQL Query and Run
Enter you SQL query and click Run query and then you can preview your data.
Import Data
Once you have previewed the data select Import and wait for a few seconds. This action pulls all your data from BigQuery to Google Sheets.
Setup Auto-Refresh
The data from your BigQuery account is now available in Google Sheets. If needed, schedule the data to refresh daily, weekly, or monthly at a particular time.
Connect your BigQuery to Google Sheets
Effortlessly connect your BigQuery data to Google Sheets for simplified reporting and analysis.
Why use Superjoin’s Google Sheets-BigQuery Integration?
Quick and Easy Integration
We’ve meticulously organized the data points to ensure easy accessibility in a format you’re already familiar with.
Preview your imports visually
Get a sneak peek of your data. Select columns, apply filters & limits as per your need before importing.
Automatic Refreshes
Enjoy one-click refreshes or schedule regular updates to ensure your sheets are always up to date.
Power of Google Sheets
Benefit from Google Sheets’ collaborative data analysis & other powerful capabilities.
Step-by-step walkthrough: How to connect BigQuery to Google Sheets.
Get Add-ons
Select Add-ons and choose Get Add-ons. This action will redirect you to the Google Workspace Marketplace.
Search Superjoin
In the Google Workspace Marketplace pop-up window, search for “Superjoin”.
Click on Install
Click on the Install button to install Superjoin.
Launch Superjoin
Once installed, navigate back to the Extensions menu tab in Google Sheets. Launch Superjoin from here. You should now see Superjoin running as a side panel on the right side of your screen.
Navigate to Queries
To begin, you can navigate to Queries , choose to Create new query.
Connect a New Source
Navigate to Sources, select Connect to a new source and search for BigQuery.
Enter Connection Details and Authorize
Enter your Project ID, which is the GCP project ID associated with the BigQuery dataset.
Once this is done click on Authorize to allow Superjoin to access your BigQuery data.
Choose a Query Method
Choose between three query methods through which you would like to import.
Enter your SQL Query and Run
Enter you SQL query and click Run query and then you can preview your data.
Import Data
Once you have previewed the data select Import and wait for a few seconds. This action pulls all your data from BigQuery to Google Sheets.
Setup Auto-Refresh
The data from your BigQuery account is now available in Google Sheets. If needed, schedule the data to refresh daily, weekly, or monthly at a particular time.