Connecting BigQuery to Google Sheets with Apps Script

Need help centralizing your data from multiple sources, or processing mass amounts of data that no longer fit on your spreadsheets? In this video, we’ll show you how to use Apps Script to upload multiple Google Spreadsheets to BigQuery, and how to transform your data into dynamic dashboards using Data Studio.


Product: G Suite Development, Sheets, Apps Script; fullname: AGV;

#SheetsToApps

[paulsweeting]

Brilliant to show concept, example, and Data Studio tie in .. in 6 mins. More like this please 🙂

[NavigationForDailyLiving]

Thank you for sharing this very helpful information! Very well designed video.

[ViktorLesyk]

Exactly what I was looking for! Thanks a lot, Google!

[wolfsburgi]

Im watching now, November 2023 and it worked to me.
It helps me a lot in my job. Thanks <3

[westernoverseas]

Big Thanks For This Amazing Knowledgeful Video

[kachensaengow]

Thank you for good demo, very helpful.

[AnthonyBrunson]

Very nice. I may have to publish some more content showing how to use this.

[balrom]

Very interesting video. Please create more video like this! Thanks.

[salvadormartinez]

Thanks, very helpful. There is no limit for google spreadsheets rows to upload?

[PoulavBiswas]

Thanks so much for sharing this video.

[mailmsathishu]

Great Tutorial. Exactly what I wanted. Thanks for the pleasant presentation.

[maraudeuse]

Hello, I did everything, and I got no error messages, but there is no data in my datatable. Can you please tell me how to debug or check why?

[neetubajwa]

I've used this logic for past 3 years. I often have issues when the upload fails and the failure status is not captured in the status column of this gsheet. Is there any way to show the error / failure message from loggers.log in the status column?

[jonathangorman]

Didn't realize I could test Big Query with my Gsuite account. More curious what the cost would be after that.

[facundosoto]

I can't change the link in the sheet, I get an error "TypeError: header.toLowerCase is not a function"

[JitendraBhatt]

Great tutorial. Please help to recognize that a CSV failed to load, get the error message.

[mohammedzaid]

How to update the data right from the sheet, like you have "APPEND" similarly can you share "UPDATE" script functionality?

[brostone]

hi,
great demo

I have a question

How to append raws and colums that are not empty?

Cause I want to append data from facebook and adding there date (date_time of append, and its formula, so I want to append only columns there column A is not empy)

Thanks

[ianlowe]

For me, the "Sheets to BigQuery" menu wasn't showing up when I copied the sheet. To fix: navigate to Tools --> Script Editor...make sure the onOpen function is selected and then press run. Go back to the sheet and the menu should be there.

[muhammedinzamam]

Can you please tell me how can I upload the Google sheets one by one to BigQuery so that I can create a master dataset like the one in this video ?