Create your customized scenario with Integromat. Automate repetitive tasks involved in using BigQuery and make your work easier.Try Integromat for FREE
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!
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).
Every time a new worksheet row is added to Excel 365, Integromat will automatically create a table with the related data.
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).
Every time a new table is created in BigQuery, Integromat will automatically publish a new Topic in Google Cloud Pub/Sub.
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.
Triggers when a query job has completed processing successfully or unsuccessfully.
Triggers when a new table is created in a dataset.
Creates a new dataset.
Creates a new row of data in a table.
Creates a new, empty table in the dataset.
Deletes the dataset specified by ID.
Deletes the table specified by ID.
Returns the dataset specified by dataset ID.
Gets the specified table resource by table ID.
Performs an arbitrary authorized API call.
Updates information in an existing dataset.
Updates information in an existing table.
Runs a BigQuery SQL query synchronously and returns query results if the query completes within a specified timeout.
Lists all datasets in the specified project to which the user has been granted the READER dataset role.
Lists all jobs that user started in the specified project.
Lists the content of a table in rows.
Lists all tables in the specified dataset.