Effortlessly connect your BigQuery data to Google Sheets for simplified reporting and analysis.
We’ve meticulously organized the data points to ensure easy accessibility in a format you’re already familiar with.
Get a sneak peek of your data. Select columns, apply filters & limits as per your need before importing.
Enjoy one-click refreshes or schedule regular updates to ensure your sheets are always up to date.
Benefit from Google Sheets’ collaborative data analysis & other powerful capabilities.
Select Add-ons
and choose Get Add-ons
. This action will redirect you to the Google Workspace Marketplace.
In the Google Workspace Marketplace pop-up window, search for “Superjoin”.
Click on the Install
button to install 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.
To begin, you can navigate to Queries
, choose to Create new query
.
Navigate to Sources
, select Connect to a new source
and search for BigQuery.
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 between three query methods through which you would like to import.
Enter you SQL query and click Run query
and then you can preview your 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.
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.