1. How to use BigQuery as a source
Aside from spreadsheets, you can also use Sheetgo to connect the data from a BigQuerry database creating a more powerful and streamlined workflow. To use these options you need to select the BigQuery as a source when creating a new workflow.
Sheetgo will ask you to grant permission to access your BigQuerry 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 BigQuerry 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 query syntax to further refine your workflow.
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.