+are joining forces |Read moreabout the journey ahead!

BigQuery, Google Sheets Integrations

BigQuery
Google Sheets
Try Integromat for FREE
No credit card. You'll love it.

What is Integromat?

GmailWatch emailsGoogle SheetsAdd a rowGmailIterate attachmentsRouterFacebookCreate a postArchiveCreate an archiveDropboxUpload a fileDocuments onlyImages onlyWhen new email arrivesAdd a row to a sheetProcess attachmentsone by one ...Post images to pageZip all documentsUpload archive

Integromat will automate processes that you currently handle manually. It is not only capable of connecting apps but can also transfer and transform data. It works 24 hours a day, seven days a week and does not require your intervention. Simply set Integromat to do what you want and let it work for you. Save your time!

Triggers

BigQuery

Watch Query Jobs Completed

Triggers when a query job has completed processing successfully or unsuccessfully.

BigQuery

Watch Tables

Triggers when a new table is created in a dataset.

Google Sheets

Perform a Function INSTANT

Receives data passed to the function INTEGROMAT used in a sheet. Sheets Add-On required.

Google Sheets

Watch Changes INSTANT

Triggers when a cell is updated. Watches only changes made in Google Sheet app. Sheets Add-On required.

Google Sheets

Watch Rows

Watches for new rows.

Actions

BigQuery

Create a Dataset

Creates a new dataset.

BigQuery

Create a Row

Creates a new row of data in a table.

BigQuery

Create a Table

Creates a new, empty table in the dataset.

BigQuery

Delete a Dataset

Deletes the dataset specified by ID.

BigQuery

Delete a Table

Deletes the table specified by ID.

BigQuery

Get a Dataset

Returns the dataset specified by dataset ID.

BigQuery

Get a Table

Gets the specified table resource by table ID.

BigQuery

Make an API Call

Performs an arbitrary authorized API call.

BigQuery

Update a Dataset

Updates information in an existing dataset.

BigQuery

Update a Table

Updates information in an existing table.

BigQuery

Write Query

Runs a BigQuery SQL query synchronously and returns query results if the query completes within a specified timeout.

Google Sheets

Add a Row

Appends a new row to the bottom of the table.

Google Sheets

Add a Sheet

Adds a new sheet.

Google Sheets

Clear a Cell

Cleares a specific cell.

Google Sheets

Clear a Row

Clears values from a specific row.

Google Sheets

Create a Spreadsheet

Creates a new spreadsheet.

Google Sheets

Delete a Row

Deletes a specific row.

Google Sheets

Delete a Sheet

Deletes a specific sheet.

Google Sheets

Get a Cell

Gets a specific cell.

Google Sheets

Make an API Call

Performs an arbitrary authorized API call.

Google Sheets

Perform a Function - Responder

Returns processed data as a result of the INTEGROMAT function. Sheets Add-On required.

Google Sheets

Update a Cell

Updates a specific cell.

Google Sheets

Update a Row

Updates a row.

Searches

BigQuery

List Datasets

Lists all datasets in the specified project to which the user has been granted the READER dataset role.

BigQuery

List Jobs

Lists all jobs that user started in the specified project.

BigQuery

List Table Data

Lists the content of a table in rows.

BigQuery

List Tables

Lists all tables in the specified dataset.

Google Sheets

Get Range Values

Gets a range content.

Google Sheets

List Sheets

Gets a list of all sheets in a spreadsheet.

Google Sheets

Search Rows

Returns results matching the given criteria.

Google Sheets

Search Rows (Advanced)

Returns results matching the given criteria. This module doesn't return a row number.

Integrate BigQuery, Google Sheets with these services