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:
bigquery.config.get
bigquery.connections.list
bigquery.datasets.get
bigquery.datasets.getIamPolicy
bigquery.jobs.create
bigquery.models.list
bigquery.routines.list
bigquery.tables.get
bigquery.tables.getData
bigquery.tables.getIamPolicy
bigquery.tables.list
bigquery.transfers.get
bigquery.transfers.update
resourcemanager.projects.get
Read more about permissions here.
Key features of BigQuery automations:
Import data from a BigQuery table into Google Sheets, Excel, CSV or generate a Google Docs file.
Schedule automatic updates to refresh the data set at regular intervals.
No import limit on the number of rows.
Building your automation
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.
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.