Connect Google Sheets & BigQuery - Connected Sheets

[@mckegler]

Thanks!

[@ExcelGoogleSheets]

Thank You!

[@mohammadal-hasani6547]

Thank you! This is - as always - very helpful. I've been watching your tutorials religiously for the past 5-6 years and I'm not overstating when I say they've changed my whole (work) life.

[@ExcelGoogleSheets]

Glad to help!

[@johnmillersr.colorado]

Having worked in IT using SQL for more years than I care to remember, I've wanted something more than the QUERY function that Sheets offers. This tutorial shed light on a realistic approach to utilize the power of SQL with Sheets I plan to use. Thanks so much for all your training videos. I always look forward to notifications for new content. 😊

[@ExcelGoogleSheets]

👍

[@joshbottube]

The "BigQuery Tutorial for Beginners" linked vid says "This video has been removed for violating KZbin's policy on harassment and bullying"

[@neilsuarezore6078]

Bro, you're amazing! Thank you so much :DD

[@silvestrecamposano6317]

Thank you very much.

[@ExcelGoogleSheets]

😊

[@huzaifahshah3841]

Thanks sir 🙏

[@themocona8495]

The Big Query video is removed 😢

[@veevee7555]

Big query video removed. .. can you share if new video available

[@RegRegi-n6q]

The "BigQuery Tutorial for Beginners" linked video says "This video has been removed for violating KZbin's policy on harassment and bullying"

[@vlrvrl4443]

Yep unfortunately

[@akshaykrishnan7985]

Hi sir, loved this video.. could you please upload a video regarding how to write data from a Google sheet to big query database using apps script?

[@imranmasud4032]

"This video has been removed for violating KZbin's policy on harassment and bullying." The BigQuery video linked shows this message. Is there any other link?

[@ExcelGoogleSheets]

No, sorry. KZbin's automatic system decided that my education video was "harassment and bullying" lol. Trying to appeal, you only get AI robot saying, sorry, we are right, you are wrong. So unfortunately the one hour video that I spent 2 weeks creating is gone.

[@imranmasud4032]

@@ExcelGoogleSheets , ooh, it's pathetic. Didn't you back up this video on your computer? I am your daily student. Since last couple of months, I have been watching your videos regarding Google Sheets and app scripts. Those are very helpful for me. A lot of thanks, buddy, for your worthy effort. May Almighty bless you.

[@stephaniecameron1519]

Hi there, thanks for the video. I was trying to access your BigQuery for beginners video but the link is down. Do you have an updated link?

[@danielg1294]

nice video! however i don't understand the point of importing/connecting a google sheet into bigquery if the loading speed is super slow as well. Do you know how i can synchronize a google sheet with bigquery? but the data has to actually be in bigquery because i want fast reports and not suuper super slow

[@nutshell5494]

Huh? The data that in the video is from bigquery, sheet is just like easier view of the data

[@elricho72]

Very useful , thanks for sharing, can I use a direct conection to load the table with a google webapp using a datatable ? or I need to link first to a spreadsheet the table ?

[@ExcelGoogleSheets]

Yes, you can. You'll have to use BigQuery API.

[@wojciechurban1162]

As I understand, when i delete row in spreadsheet its also disappear in BigQuery?

[@ExcelGoogleSheets]

Yes.

[@lukeebulo8628]

Thank you for sharing. I would also like to ask if you have a video where we can let multiple user toggle a "drop down" for a specific category, without it changing the data on other users end (same sheet)? I'm a beginner at this. I hope this is possible.

[@ExcelGoogleSheets]

Assuming you're asking about dropdowns/datavalidation, It's not possible. It's only possible for filters/sort.

[@lukeebulo8628]

@@ExcelGoogleSheets Thanks for the response! Maybe I'll think of another way, but I really do appreciate the response!

[@bulbulahmed3098]

❤❤❤

[@AjadSingh-r1j]

Very help full video how to get data Big Query to app script?.

[@juanpauloalmazan2997]

Good day!, I'm having a hard time converting the datetime column to just date in bigquery. Can you teach me pls.

[@simulcast.stream]

Every query to BG is costing money. Is there a way to preview how much data will return before connecting/pulling it into the sheet?

[@FunkyFaulc]

You have like 1TB of free. I'd just do the free trial for a month and see where you are at. Honestly unless you are HUGE, I wouldn't expect to surpass the free tier very quickly.

[@AviKalra-jp2vv]

How do we get multiple tabs from a sheet?

[@roginaazmy8077]

How to make sure that bigQuery will detect the right data types in the schema when connecting a google sheet? Because I got that error, I have a column that should be a string and every time I connect this sheet with bigQuery it's identified in the schema as Integer, however I made sure to modify the data type of this column in the original google sheet as text, but this didn't work.

[@koungsareth8623]

What will happen once the Google sheet is hit the limit space?

[@ExcelGoogleSheets]

It won't. It doesn't actually pull the data to Google Sheets, it just gives you a preview. When you do calculations & pivot tables, it does those directly in bigquery and loads only the results of those calculations to your spreadsheet.

[@battlebear]

I wonder would using Apps Script with BigQuery will help with performance? I've been using Google Sheet to store data for webapp but in some cases, it was slow. I saw that App Script has API connecting to Bigquery but I have never tried it.

[@ExcelGoogleSheets]

I suppose that depends. The amount of data in BigQuery would definitely not be an issue. Weather you'll be satisfied with speed in general is something for you to decide.

[@billyhenrylopez519]

Is there a possibility to add data from spreadsheets to big query using google app script

[@ExcelGoogleSheets]

Sure, if you have a billing account set up.

[@BrianNguyenC]

Is there a cell limit when connecting Google Sheets to BigQuery?

[@ExcelGoogleSheets]

Not if you have a paid account.

[@staticalmo]

Why do they allow such an overkill solution for data connectors, big query, and not other google solutions for "small data"?

[@lindaholder2225]

Is Big Query free with Google? 😊

[@tnminh9400]

I used importxml to get data from web but some case the command error like ‘could not fetch url’. How to solve it. Thanks advance

[@ExcelGoogleSheets]

importxml only work with websites where page is loaded by the server. Unfortunately, more & more websites today move to loading the data on client side with javascript, which means it won't work on a lot of websites.

[@ilkhommakhkambaev4698]

it is not working

[@samirbensaci451]

Is it possible to make more than 2 parameters in Google sheets ( list of elements) ?

[@ExcelGoogleSheets]

It won't accept a range, it only accepts a single cell.

[@ExcelGoogleSheets]

You can do more than one parameter.