Gmail + Google BigQuery

Create rows in Google BigQuery for new labeled emails in Gmail

Effortlessly manage your business data with this efficient workflow. When a new labeled email arrives in Gmail, the related information will be added as a new row in Google BigQuery without any manual intervention. This seamless process ensures all relevant data captured from Gmail is accurately stored in your Google BigQuery for easy access and analysis. It's the ideal way to streamline and enhance your data handling operations.

When this happens...
New Labeled Email
Triggers when you label an email.
TriggerScheduled
automatically do this!
Create Row
Creates a new row of data in a table. Note: Does not create a job.
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?

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

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

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