Gmail + Google BigQuery

Send emails in Gmail for new rows in Google BigQuery

Stay on top of updates in your Google BigQuery with this efficient workflow. As soon as new data enters into a row in Google BigQuery, an email will swiftly be sent via your Gmail account, keeping you up to speed. No more manual monitoring, make your data management smarter and faster with this seamless data to email automation.

When this happens...
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.
TriggerScheduled
automatically do this!
Send Email
Triggers when a new email appears in the specified mailbox.
ActionWrite

Start free with email

Start free with Google

Start free with email

Start free with Google

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

Supported triggers and actions

What does this mean?

- ProjectRequired
- Dataset
- Table
Trigger
Scheduled
Try It
- Project IDRequired
- Job IDRequired
- LocationRequired
Trigger
Scheduled
Try It
- ProjectRequired
- DatasetRequired
- TableRequired
Action
Write
- Project IDRequired
- DatasetRequired
- TableRequired
- Where ColumnRequired
- Where ValueRequired
Action
Write
- Project IDRequired
- SQL QueryRequired
- Location
Action
Write

- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
- Project IDRequired
- DatasetRequired
- TableRequired
- Sort By Column
- Sort Direction
- Where ClauseRequired
- LimitRequired
Action
Search

- ProjectRequired
- DatasetRequired
- TableRequired
- Sort By Column
- Sort Direction
- Where ClauseRequired
Action
Search or write
New Label
Triggers when you add a new label.
Trigger
Scheduled
Try It
- Label or mailbox
Trigger
Scheduled
Try It
New Starred Email
Triggers when you receive a new email and star it within two days.
Trigger
Scheduled
Try It
- Label
- MessageRequired
Action
Write
- Recipient Instructions
- To
- Cc
- Bcc
- SubjectRequired
- From
- From Name
- Body type
- BodyRequired
- Add signature default
- Label or mailbox
- Attachments
Action
Write
- Name of labelRequired
Action
Write
- MessageRequired
- Label(s) to removeRequired
Action
Write
- Search StringRequired
Action
Search

- Project IDRequired
- DatasetRequired
- TableRequired
- Sort By ColumnRequired
- Unique ColumnRequired
Trigger
Scheduled
Try It
- Project IDRequired
- DatasetRequired
- TableRequired
- Unique ColumnRequired
- IS Operator
Trigger
Scheduled
Try It
- ProjectRequired
- DatasetRequired
- TableRequired
Action
Write
- Project IDRequired
- DatasetRequired
- TableRequired
- RowsRequired
- Skip Invalid Rows
- Ignore Unknown Values
Action
Write
- Project IDRequired
- DatasetRequired
- TableRequired
- Where ColumnRequired
- Where ValueRequired
- Update ColumnsRequired
Action
Write
- Project IDRequired
- DatasetRequired
- TableRequired
- Sort By Column
- Sort Direction
- Where ClauseRequired
Action
Search
- Project IDRequired
- Job IDRequired
- LocationRequired
Action
Search
- Label or mailbox
- Search keywords
Trigger
Scheduled
Try It
- Label or mailboxRequired
Trigger
Scheduled
Try It
- Search keywordsRequired
Trigger
Scheduled
Try It
- Label/Mailbox
Trigger
Scheduled
Try It
- Email message to be DeletedRequired
Action
Write
- Trigger Instructions
- ThreadRequired
- To
- Cc
- Bcc
- From
- From Name
- Body type
- BodyRequired
- Add signature default
- Label or mailbox
- Attachments
Action
Write
- To
- Cc
- Bcc
- From
- From Name
- Reply To
- SubjectRequired
- Body type
- BodyRequired
- Add signature default
- Label or mailbox
- Attachments
Action
Write
- Trigger Instructions
- ThreadRequired
- To
- Cc
- Bcc
- From
- From Name
- Reply To
- Body type
- BodyRequired
- Label or mailbox
- Attachments
Action
Write
- Search StringRequired
- To
- Cc
- Bcc
- From
- From Name
- Reply To
- SubjectRequired
- Body type
- BodyRequired
- Add signature default
- Label or mailbox
- Attachments
Action
Search or write

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.

Learn more

Related categories

Similar apps

About Google BigQuery

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

Learn more

Related categories

Related Zap Templates

Create rows in Google BigQuery for new Gmail emails matching search parameters

Create rows in Google BigQuery for new emails in Gmail

Gmail + Google BigQuery

Send emails in Gmail for new rows in Google BigQuery

Query Job Completed (With Row Data)

Dataset

Table

New Job Completed

Create Row

Delete Rows

Run a Query

Location

API Request (Beta)

Query String Parameters

Headers

Additional Request Headers

Body

Find Row(s)

Sort By Column

Sort Direction

Find or Create Record

Sort By Column

Sort Direction

New Label

New Email

Label or mailbox

New Starred Email

Add Label to Email

Label

Create Draft

Recipient Instructions

To

Cc

Bcc

From

From Name

Body type

Add signature default

Label or mailbox

Attachments

Create Label

Remove Label From Email

Find Email

New Row

Updated Row

IS Operator

Create Rows

Import Data

Skip Invalid Rows

Ignore Unknown Values

Update Row(s)

Find One Row

Sort By Column

Sort Direction

Get Rows for Job Completed

New Attachment

Label or mailbox

Search keywords

New Labeled Email

New Email Matching Search

New Thread

Label/Mailbox

Delete Email

Create Draft Reply

Trigger Instructions

To

Cc

Bcc

From

From Name

Body type

Add signature default

Label or mailbox

Attachments

Send Email

To

Cc

Bcc

From

From Name

Reply To

Body type