Skip to main content
All CollectionsFeaturesBigQuery
Use BigQuery as a source
Use BigQuery as a source

Bring data from your BigQuery database to a workflow

Karoline Fernezlian avatar
Written by Karoline Fernezlian
Updated this week

Google BigQuery is a powerful, fully-managed data warehouse that allows you to run fast SQL queries. Integrating BigQuery with Sheetgo lets you bring information from a database to spreadsheets.

This article will guide you through the steps to set up and use BigQuery as a source in your Sheetgo workflows.

First, create a new Blank workflow. Under Select source, select BigQuery.

Sheetgo needs permission to access your BigQuery account. To do this, click Grant permission and follow the steps that appear on the Google pop-up.

After giving Sheetgo access to your BigQuery a new box will appear where you can select which project you want to work with.

After selecting a project, Sheetgo will show you available datasets and their corresponding tables. You need to choose a dataset and a table to work with. Next, introduce a query on the Query Editor to select table columns or further refine your data selection.

Keep in mind: You can use the Validate query button to check if the query you are using is giving a valid response.

Once the source is setup, just click Next step to select a data processor and the destination for the information.

In Sheetgo, using BigQuery as a source lets you leverage its power and data warehousing capabilities while automating your data Workflows. By following these steps, you can set up and manage data transfers from BigQuery to your preferred destinations.

Need more help?

Contact us via chat, on our email ([email protected]), or send us a ticket!

Visit our Community for help, tips, tricks, and feedback for Sheetgo.

Did this answer your question?