Google BigQuery is a powerful, fully-managed data warehouse that allows you to run super-fast SQL queries on large datasets. Integrating BigQuery with Sheetgo enables you to build automations that integrate your database directly into a spreadsheet.

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

Start by creating a new Blank workflow, and selecting the BigQuery option on the source step.

Sheetgo will ask you to grant permission to access your BigQuery account, to do this you just need to click on the Grant permission button and follow the steps that will appear on the Google pop-up window.

After you give Sheetgo access to your BigQuery a new box will appear where you will be able to select which project you want to work on.

After you select the right project Sheetgo will show you the available datasets and the tables that are inside each dataset. You will need to choose one dataset and one table to work on, when you are done selecting these you can filter the information on the Query Editor, by selecting one or all columns and using SQL syntax to further refine your data selection.

When you are satisfied with the source setup you just need to click on the next step where you will be able to select a data processor or the destination of your information.

Using BigQuery as a source in Sheetgo allows you to leverage the power of BigQuery's data warehousing capabilities while automating your data workflows. By following these steps, you can easily set up and manage data transfers from BigQuery to your preferred destinations, ensuring efficient and up-to-date data processes.