BigQuery

BigQuery

Create your customized scenario with Integromat. Automate repetitive tasks involved in using BigQuery and make your work easier.

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!

BigQuery integrations

Export BigQuery Tables to Google Sheets

Export BigQuery Tables to Google Sheets

This template helps you export a BigQuery table to Google Sheets. The scenario can be set up to run at regular intervals (every hour, day, week or a specific date).


40
Create BigQuery tables from Excel 365 worksheets

Create BigQuery tables from Excel 365 worksheets

Every time a new worksheet row is added to Excel 365, Integromat will automatically create a table with the related data.


7
Execute scheduled queries in BigQuery

Execute scheduled queries in BigQuery

This template helps you schedule BigQuery SQL queries. The scenario can be set up to run at regular intervals (every hour, day, week or on a specific date).


3
Create Google Cloud Pub/Sub Topics from new BigQuery tables

Create Google Cloud Pub/Sub Topics from new BigQuery tables

Every time a new table is created in BigQuery, Integromat will automatically publish a new Topic in Google Cloud Pub/Sub.


0
Create new rows in Google BigQuery from new Refiner survey submissions

Create new rows in Google BigQuery from new Refiner survey submissions

This template creates new rows in a Google BigQuery table based on new Refiner survey submissions. The template expects your Refiner survey to have these questions: 1) How likely are you to recommend our service a friend or colleague? (as an NPS score question) 2) What do you value you most about our service? (as an open question) 3) How many starts would you give us? (as a star rating question) The template also expects your destination BigQuery table to have these columns: 1) `receivedat` as datetime 2) `nps` as integer 3) `starts` as integer 4) `whatdoyouvalue` as string Note that email values from Refiner will only be passed to BigQuery if they are available for the particular survey submission.


0

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.

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.

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.

Integrate BigQuery with these services