Skip to content
  • Gmail logoGmail logo
  • Google BigQuery logoGoogle BigQuery logo

Gmail + Google BigQuery

Create drafts in Gmail for every new row in Google BigQuery

Stay prepared and organized with this workflow that begins whenever a new row appears in Google BigQuery. This event will swiftly lead to the creation of a Gmail draft, ensuring that your email communications keep pace with data updates. It's a flawless union of data management and efficient communication, ensuring you're always ready to tackle necessary tasks with up-to-date information.

Stay prepared and organized with this workflow that begins whenever a new row appears in Google BigQuery. This event will swiftly lead to the creation of a Gmail draft, ensuring that your email communications keep pace with data updates. It's a flawless union of data management and efficient communication, ensuring you're always ready to tackle necessary tasks with up-to-date information.

  1. When this happens...
    Google BigQueryGoogle BigQuery
    New Row

    Triggers when a new row is added to a table. We know when a new row is added whenthe table is sorted by a column and the latest row is different from the previous latest row.

    TriggerPolling
  2. automatically do this!
    GmailGmail
    Create Draft

    Create a draft email message.

    ActionWrite
  • Free forever for core features
  • 14 day trial for premium features & apps

Supported triggers and actions

    • ProjectRequired

    • Dataset

    • Table

    Trigger
    Polling
    Try It
    • Project IDRequired

    • Job IDRequired

    • LocationRequired

    Trigger
    Polling
    Try It
    • ProjectRequired

    • DatasetRequired

    • TableRequired

    Action
    Write
    • Project IDRequired

    • DatasetRequired

    • TableRequired

    • Where ColumnRequired

    • Where ValueRequired

    Action
    Write
    • Project IDRequired

    • DatasetRequired

    • TableRequired

    • Sort By ColumnRequired

    • Unique ColumnRequired

    Trigger
    Polling
    Try It
    • Project IDRequired

    • DatasetRequired

    • TableRequired

    • Unique ColumnRequired

    • IS Operator

    Trigger
    Polling
    Try It
    • ProjectRequired

    • DatasetRequired

    • TableRequired

    Action
    Write
    • Project IDRequired

    • DatasetRequired

    • TableRequired

    • RowsRequired

    • Skip Invalid Rows

    • Ignore Unknown Values

    Action
    Write
gmail logo
gmail logo

About Gmail

One of the most popular email services, Gmail keeps track of all your emails with threaded conversations, tags, and Google-powered search to find any message you need.

Related categories

google-bigquery logo
google-bigquery logo

About Google BigQuery

BigQuery is Google's serverless and highly scalable enterprise data warehouse, designed to make all your data analysts productive.

Related categories

Triggers & Actions