Sheetgo allows you to import BigQuery data directly into your workflows. Before creating a Sheetgo automation to transfer data from your BigQuery platform, your account needs permission to access the datasets and grant Sheetgo access to your database. In general, the permission your account needs to access tables will be assigned to your account by the IT department in your organization.

In the list below you will find some of the permissions your IT department might need to assign to your account:

Read more about permissions here.

Open Sheetgo, go to + New, and select Blank workflow.
​

Start your new workflow on the Create an automation option.

On the source step of your automation select the BigQuery option.

Now specify the Project, Dataset, and Table that you intend to work with. On the Query Editor step add the filter selecting the exact data that you want to extract from the BigQuery table and transfer to a spreadsheet.

Before going to the next step you can test if the query you wrote is giving a valid answer, you can do this by clicking on the Validate query button. If everything is working click on Next step.
​

Now you can determine where you want to send this data. You can send it to a new spreadsheet, back to a BigQuery table or generate a new document.

In this case, we will send the data to a new Google Sheet, we need to give the new file and tab proper names.

Click Finish and save. And you've create an automation that will capture the data from a BigQuery table and transfer it to a Google Sheet. You can now use this new Google Sheet file as the source of new automations or workflows.