Google BigQuery and Zapier connect to automate data workflows. You can trigger actions when query jobs complete or new rows are added and create rows or run queries.
Prerequisites
To use the Google BigQuery app on Zapier, you must have:
- A Google Cloud Platform account with billing enabled.
- A Google Cloud project with the BigQuery API enabled.
- Zapier must be added as a Trusted App in your Google Workspace admin settings if you're using a Google Workspace account.
- Appropriate permissions within your Google Cloud project to access BigQuery data and create jobs.
Connect Google BigQuery to Zapier
To create an app connection to Google BigQuery on Zapier:
- Go to the Apps page.
- Click + Add connection.
- A new dialog box will appear. Search for and select Google BigQuery.
- Click Add connection.
- A new browser tab or window will open.
- Log into Google BigQuery to authenticate.
- Grant Zapier permission to access your account if prompted to.
Your Google BigQuery account is now successfully connected to Zapier.
TipFor Zapier Team or Enterprise users, you can use a Static IP address to connect to Zapier.
Troubleshooting Google BigQuery connections
If you get the error message "reauth related error (invalid_rapt)", you must contact your Google administrator to update your reauthentication policy to allow Zapier as a Trusted App.
About Google BigQuery's app
Triggers, searches, and actions
Triggers
- Query Job Completed (With Row Data) - Triggers when a query job has completed processing successfully. (Polling)
- New Job Completed - Triggers when a query job has completed processing successfully or unsuccessfully. (Polling)
- New Row - Triggers when a new row is added to a table. We know when a new row is added when the table is sorted by a column and the latest row is different from the previous latest row. (Polling)
- Updated Row - Triggers when an existing row is updated in a table in BigQuery. (Polling)
Searches
- Get Rows for Job Completed - Gets batch of rows from completed jobs in BigQuery
- Find One Row - Find a row by specifying a table, a WHERE clause, an optional ORDER BY.
Actions
- Create Row - Creates a new row of data in a table.
- Delete Rows - Deletes row(s) in an existing table in BigQuery
- Run a Query - Runs a SQL query against a table in BigQuery.
- API Request (Beta) - This is an advanced action which makes a raw HTTP request that includes this integration's authentication.
- Create Rows - Creates new rows of data in a table (accepts line items).
- Import Data - Imports data into a table. The data must be in JSON format.
- Update Row(s) - Updates new row(s) to an existing table in BigQuery
- Find or Create Record - Find or Create Record
Limitations
- API usage limits apply.
- BigQuery has specific pagination limits that may affect data retrieval through Zapier.
Templates
View all of Google BigQuery's templates.
Use cases
- 5 ways to automate Google BigQuery
- 5 ways to automate your database apps
- Scale your data management with Google BigQuery
0 comments
Article is closed for comments.