Sheetgo lets you import BigQuery data into your workflows. Before creating a Sheetgo automation to transfer data from your BigQuery platform, your account needs permission to access the datasets. Generally, permissions to access tables are granted to your account by the IT department in your organization.

These are some of the permissions your account might need:

Read more about permissions here.

Open Sheetgo, click the + New button, and select Blank workflow.
​

Start your new workflow using the Create an automation option.

Under Select source, select the BigQuery option.

Now specify the Project, Dataset, and Table you intend to work with. On the Query Editor add the query to retrieve the exact data from the BigQuery database to transfer to a spreadsheet.

Before moving on, you can test whether your query is giving a valid answer by clicking Validate query. If everything is working, click Next step.
​

Now, determine where 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 data to a new Google Sheet, we need to name the new file and tab.

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