Effortlessly connect your BigQuery data to Google Sheets for simplified reporting and analysis.
Add-ons
and choose Get Add-ons
. This action will redirect you to the Google Workspace Marketplace.Install
button to install Superjoin.
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.Queries
, choose to Create new query
.Sources
, select Connect to a new source
and search for BigQuery.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.Run query
and then you can preview your data.Import
and wait for a few seconds. This action pulls all your data from BigQuery to Google Sheets.