Query BigQuery from Google Sheets

Exporting to csv manually then opening with Google Sheets is now a thing of the past with Connected sheets functionality.

Connected sheets is the functionality within Google Sheets to directly query BigQuery and have the results populate directly in Google sheets where spreadsheet magic can be used to analyse and share the results further.

But don’t take my word for it, here’s the official video from Google explaining Google Sheets:

Here’s a short video showing how I have pulled in daily Woolworths share price data from my Google Cloud Platform Project:

As an added bonus, it is even possible to schedule the queries to refresh the data on a schedule. Adding another great option for providing automated reporting and analysis.

Send a Comment

Your email address will not be published.