Logo for Google Sheets
BigQuery Connector

5 / month

Google Sheets

Periodically fetch data from a google sheet into bigquery. Sending data from a google sheet can help you build in forecast / budget data into your reporting so you can correlate performance with your targets. It's also good to use for data enrichment in cases where you lack data from your main systems, such as product price data and more. Your only limitation is your imagination!

Guide / Information

In order to keep the data integrity intact. You need to add the fields from your sheet to "custom fields". Specify field to fetch, and data type ( then our connector will make sure the correct data type is inserted into bigquery from your sheet. ) BigQuery needs your data to have one data type per column.