Execute scheduled queries in BigQuery

About

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).

Apps Included

BigQuery

Gmail

Get this template

Categories

Storage

Get this template

Similar templates for inspiration

Looking to get more out of your apps? With Make, you can visually integrate any app into any workflow to save time and resources - no coding required. Try any of these templates in just a few clicks.

Add client inbox label to Gmail

The Google Sheets module checks for matches between the sender’s email address and the list of client email addresses. If a match is found, the label client_mailbox is added to the email. More information here.

Try It ➔

Create a Gmail draft message from a new Google Sheets row

Use this template to create a Gmail draft message when a new row is added to your Google Sheets spreadsheet.

To work with the template's default settings, your Google Sheets spreadsheet should contain these columns: Email address, Subject of the email and Content of the email.

Try It ➔

Save a Gmail email containing a specific phrase to Google Sheets as a new row

Use this template to save a Gmail message containing a specific phrase to your Google Sheets spreadsheet as a new row.

Try It ➔

Save a Gmail email from a specific sender to Google Sheets as a new row

Use this template to save a Gmail message from a specific sender to your Google Sheets spreadsheet as a new row.

Try It ➔

Save a Gmail email to Google Sheets as a new row

Use this template to save a Gmail email message to your Google Sheets spreadsheet as a new row.

Try It ➔

Send a Gmail email from a new Google Sheets row

Use this template to send a Gmail message when a new row is added to your Google Sheets spreadsheet.

To work with the template's default settings, your Google Sheets spreadsheet should contain these columns: Email address, Subject of the email and Content of the email.

Try It ➔

Save Gmail emails and attachments to Google Sheets and Google Drive

Use this template to save a Gmail message to your Google Sheets spreadsheet as a new row and its attachments to Google Drive.

Try It ➔

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).

Try It ➔

Export Firestore documents to Google Sheets

This Template helps you export a collection of Firestore documents to Google Sheets. Make will automatically save all document field values in a new spreadsheet row. This scenario uses this example spreadsheet. Prerequisite: This template can't save fields of Array, Map or Geo type.

Try It ➔

Create your own workflow

Create custom workflows by choosing triggers, actions, and searches. A trigger is an event that launches the workflow, an action is the event.

Copy an email

Copies an email or a draft into a selected folder.

Action

Create a Dataset

Creates a new dataset.

Action

Create a Table

Creates a new, empty table in the dataset.

Action

Create a draft

Creates a new draft and adds it to a selected folder.

Action

Delete a Dataset

Deletes the dataset specified by ID.

Action

Delete a Table

Deletes the table specified by ID.

Action

Delete an email

Removes an email or a draft from a selected folder.

Action

Get a Dataset

Returns the dataset specified by dataset ID.

Action

Get a Table

Gets the specified table resource by table ID.

Action

FAQ

How do I get started with Make?

What is a scenario?

What is a module?

What is mapping?

Execute scheduled queries in BigQuery

About

Apps Included

Create your own workflow

Trusted by 500,000+ Makers