Integrate Google Spreadsheet with Big Query by Apps Script

Save the complex query as a view on Big Query

Overwrite the data rows on the Google sheet

Google Apps Script to Integrate Big Query into Google Sheet

  1. Select “Tools” > “Script Editors” on the spreadsheet menu.
  2. Paste the following code to the script editor.
  3. Change YOUR_PROJECT_ID, YOUR_DATA_SOURCE_SHEET_NAME and YOUR_PROJECT_NAME.DATASET_NAME.TABLE_NAME in the script.
  1. On the Script Editor, “View” > “Show manifest file”
  2. Edit and save as follows:

--

--

--

Based in London and Devon, I love surfing and technology.

Love podcasts or audiobooks? Learn on the go with our new app.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Jun Kaneko

Jun Kaneko

Based in London and Devon, I love surfing and technology.

More from Medium

How to Create Your Own Connector in Google Data Studio

Migrating data from Cloud Firestore to Cloud SQL

Replicate data from BigQuery to Cloud SQL

talend as an ETL Tool