Connecting BigQuery to Google Sheets with Apps Script

Рет қаралды 43,464

4 жыл бұрын

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.
Previous Episode → goo.gle/2UqaTOv
Copy Sheet → goo.gle/3henTR5
Instructions → goo.gle/2Ab1jIM
BigQuery Sandbox → goo.gle/3f6dDsr
Google Apps Script → goo.gle/3cMWwLz
Beginner tutorial for Google Apps Script → goo.gle/2zOtDA6
Sign-in to BigQuery with your Google account → goo.gle/2Sq9N4S
Sheets to Apps playlist → goo.gle/SheetstoApps
Customizing G Suite playlist → goo.gle/2Rp30br
Subscribe to G Suite → goo.gle/GSuite
Product: G Suite Development, Sheets, Apps Script; fullname: AGV;
#SheetsToApps

Пікірлер: 35

@paulsweeting1163 4 жыл бұрын

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

@ViktorLesyk 3 жыл бұрын

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

@NavigationForDailyLiving 4 жыл бұрын

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

@kachensaengow3787 3 жыл бұрын

Thank you for good demo, very helpful.

@westernoverseas9193 3 жыл бұрын

Big Thanks For This Amazing Knowledgeful Video

@danielaavelar1418 2 жыл бұрын

Wonnnnndeeeeeeful Tutorial! Just love it so much!

@balrom 4 жыл бұрын

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

@AnthonyBrunson 4 жыл бұрын

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

@mail2msathishu 4 жыл бұрын

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

@PoulavBiswas 2 жыл бұрын

Thanks so much for sharing this video.

@wolfsburg20i 8 ай бұрын

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

@salvadormartinez1597 3 жыл бұрын

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

@neetubajwa01 3 жыл бұрын

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?

@jonathangorman7820 4 жыл бұрын

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

@kristiandimitrov533 Жыл бұрын

Thank you!

@mohammedzaid3878 3 жыл бұрын

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

@brostone2538 2 жыл бұрын

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

@JitendraBhatt28 3 жыл бұрын

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

@AmrEdTech 4 жыл бұрын

Awesome

@maraudeuse952 2 жыл бұрын

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?

@muhammedinzamam1505 Жыл бұрын

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 ?

@MuhammadDaudkhanTV100 4 жыл бұрын

Nice

@facundosoto7744 3 жыл бұрын

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

@ramgopalnalluri Жыл бұрын

Thanks

@ianlowe7074 2 жыл бұрын

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.

@illumina-t-info 3 күн бұрын

thanks

@haohuynh464 Жыл бұрын

Anyone tested it? I use it but after Upload the table in Bigquery all data get null ##

@muhammedinzamam1505 Жыл бұрын

same here,i tried to update details from different google workbooks,did you find a solution?

@juanmaradiaga 2 жыл бұрын

needs to be uptaded on how everything looks and works. I didnt have the upload to big query button available.

@ThePablo505 2 жыл бұрын

same here

@abdullahislam 3 жыл бұрын

@brijbhangupta4244 Жыл бұрын

How to set auto referesh sheet to bigquery menu in once time in a day

@motogoa Жыл бұрын

It seems to me this script has a bug. Any ideas how to fix this? After extensive testing here's what I found: /** ON PRIMARY UPLOAD: * if all is FALSE, then will upload ONLY first and last sheets, but not the middle. * if all is TRUE, then will upload ALL data, appending MIDDLE to LAST * * WHEN POPULATED: * if all is FALSE, then will change nothing (first and last remain the same as previous) * if TRUE is selected on LAST sheet and FALSE on middle, then will append MIDDLE sheet before last * if TRUE is selected on MIDDLE sheet and FALSE on last, then will display only LAST sheet * if TRUE is selected on both MIDDLE and LAST, then will append LAST AND MIDDLE sheets to existing LAST (makes LAST doubled up) */