Connect Google Sheets & BigQuery - Connected Sheets

Support This Channel / chicagocomputerclasses
How to Connect Google Sheets and BigQuery?
In this tutorial we'll use Connected Sheets to get BigQuery data to Google Sheets and then we'll create a live link from BigQuery to access Google Sheets data directly.
00:00 Connect Google Sheets & BigQuery Tutorial
00:20 Pull BigQuery Data to Google Sheets with Connected Sheets
05:59 Use Spreadsheet Parameters in BigQuery SQL Statements
08:22 Use Google Sheets Data in BigQuery
11:52 Query Live Google Sheets Data in BigQuery
BigQuery Tutorial for Beginners • Video
#bigquery #googlesheets #tutorial

[@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]

👍

[@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!

[@neilsuarezore6078]

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

[@joshbottube]

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

[@huzaifahshah3841]

Thanks sir 🙏

[@mckegler]

Thanks!

[@ExcelGoogleSheets]

Thank You!

[@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?

[@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?

[@user-wz9xo5fy7o]

is there any way to using importrange with the data source is the connected sheets? or we need to extract the connected first?

[@veevee7555]

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

[@user-pu1ow5oi6j]

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

[@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.

[@bulbulahmed3098]

❤❤❤

[@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.

[@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!

[@juanpauloalmazan2997]

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

[@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

[@AviKalra-jp2vv]

How do we get multiple tabs from a sheet?

[@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.

[@wojciechurban1162]

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

[@ExcelGoogleSheets]

Yes.

[@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.

[@themocona8495]

The Big Query video is removed 😢

[@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.

[@flipsnap]

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.

[@BrianNguyenC]

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

[@ExcelGoogleSheets]

Not if you have a paid account.

[@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.

[@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? 😊

[@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.

[@ilkhommakhkambaev4698]

it is not working

[@user-oe6bu1ud3w]

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