Gmail + Google Sheets

Save new Gmail emails matching certain traits to a Google Spreadsheet

Often it's helpful to store, backup and organize emails matching certain characteristics to a Google Spreadsheet. This Gmail Google Sheets integration makes it a breeze to setup a simple rule (i.e. emails from: boss@work.com) and automatically save them as a new row in a Google Spreadsheet so you have them backed up and for reference later - add your rules to the "search string" field while setting up this Zap, and we'll do the rest.

When this happens...
New Email Matching Search
Triggers when you receive a new email that matches a search string you provide.
TriggerScheduled
automatically do this!
Create Spreadsheet Row
Create a new row in a specific spreadsheet.
ActionWrite

Try this template

Supported triggers and actions

What does this mean?

New Attachment
Triggers when you receive a new attachment (triggers once per attachment).
Trigger
Scheduled
New Label
Triggers when you add a new label.
Trigger
Scheduled
New Labeled Email
Triggers when you label an email.
Trigger
Scheduled
New Email
Triggers when a new e-mail appears in the specified mailbox.
Trigger
Scheduled
New Email Matching Search
Triggers when you receive a new email that matches a search string you provide.
Trigger
Scheduled

New Starred Email
Triggers when you receive a new email and star it within two days.
Trigger
Scheduled
New Thread
Triggers when a new thread starts.
Trigger
Scheduled

Add Label to Email
Add a label to an email message.
Action
Write

Gmail
Create (but do not send) a new email message.
Scheduled
Action
Gmail
Creates a new label.
Scheduled
Action
Gmail
Create and send a new email message.
Scheduled
Action
Gmail
Remove a label from an email message.
Scheduled
Action
Gmail
Send a reply to an email message.
Scheduled
Action
Gmail
Finds an email message.
Scheduled
Action
Gmail
Finds or creates a specific message.
Scheduled
Action
Google Sheets
Triggered when a new row is added to the bottom of a spreadsheet - works best with Team Drives.
Scheduled
Trigger
Google Sheets
Triggered when a new row is added to the bottom of a spreadsheet.
Instant
Trigger
Google Sheets
Triggered when you create a new spreadsheet.
Scheduled
Trigger
Google Sheets
Triggered when a new row is added or modified in a spreadsheet - works best with Team Drives.
Scheduled
Trigger
Google Sheets
Triggered when a new row is added or modified in a spreadsheet.
Instant
Trigger
Google Sheets
Triggered when you create a new worksheet in a spreadsheet.
Scheduled
Trigger
Google Sheets
Create a new column in a specific spreadsheet.
Scheduled
Action
Google Sheets
Create a new row in a specific spreadsheet.
Scheduled
Action
Google Sheets
Create one or more new rows in a specific spreadsheet (with line item support).
Scheduled
Action
Google Sheets
Create a new worksheet by copying an existing worksheet.
Scheduled
Action
Google Sheets
Create a blank spreadsheet or duplicate an existing spreadsheet. Optionally, provide headers.
Scheduled
Action
Google Sheets
Create a blank worksheet with a title. Optionally, provide headers.
Scheduled
Action
Google Sheets
Deletes the content of a row in a specific spreadsheet. Deleted rows will appear as blank rows in your spreadsheet. Please use with caution.
Scheduled
Action
Google Sheets
Update a row in a specific spreadsheet.
Scheduled
Action
Google Sheets
Finds many matched rows (10 max.) by a column and value.
Scheduled
Action
Google Sheets
Returns many rows (20 max.) as a single JSON value and flat rows (line items).
Scheduled
Action
Google Sheets
Finds a row by a column and value. Returns the entire row if one is found.
Scheduled
Action
Google Sheets
Finds or creates a specific lookup row.
Scheduled
Action

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