BQ to GSheet connector

Have you ever dreamt of connecting a GSheet document to BigQuery ? Being able to have data refreshed whenever you want just with the help of a SQL query ? If you recognize yourself, you are reading the right article!

Here we go =>

The Ultimate Guide to Integrate A BQ Query Into A GSheet

  1. Create a Google Sheet

  2. Tool > Script Editor 1

  3. Choose a name for your project 2

  4. Resources > Advanced Google Services > Big Query 3 4

  5. Your are redirected to Google Cloud Platform > Enable Google Big Query API 5 6

  6. Copy / Paste this script in the editor:

  1. Replace:
  • The Project Number (contact a Data Team member)
  • Your SQL Query / It should be Legacy SQL
  • Replace Your Sheet Tab Name

Run the script 4

⚠️ Be careful, the GSHEET doesn’t support nested fields, you must FLATTEN everything if you are dealing with nested tables.

4

Enjoy!

– Anaïs Ghelfi