When this happens...
GmailNew Email Matching Search
Then do this...
Google SheetsCreate Spreadsheet Row

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.

How It Works

  1. Specify a search term for your Gmail emails
  2. When you have new emails that match this search, Zapier copies the message and adds it to a new row in a designated Google Sheets document

What You Need

  • Gmail account
  • Google account

Why Zapier?

Free

Get started for free—14 day trial of premium features and apps.

Easy

No coding required—automate any of 1,000+ apps in minutes.

Secure

Enterprise-level security—connect mission-critical apps.

It's easy to connect Google Sheets + Gmail and requires absolutely zero coding experience—the only limit is your own imagination.

When this happens...
then do this!
Google Sheets
New or Updated Spreadsheet Row

Triggered when a new row is added or modified in a spreadsheet.

Google Sheets
Create Spreadsheet Row

Create a new row in a specific spreadsheet.

Google Sheets
New Spreadsheet Row

Triggered when a new row is added to the bottom of a spreadsheet.

Google Sheets
Update Spreadsheet Row

Update a row in a specific spreadsheet.

Gmail
New Email Matching Search

Triggers when you receive a new email that matches a search string you provide.

Gmail
Create Draft

Create (but do not send) a new email message.

Gmail
New Labeled Email

Triggers when you receive a new email and label it within two days.

Gmail
Send Email

Create and send a new email message.

Gmail
New Attachment

Triggers when you receive a new attachment (triggers once per attachment).

Google Sheets
Create Spreadsheet Row(s)

Create one or more new rows in a specific spreadsheet (with line item support).

Use our free platform to build a single Zapier integration and instantly connect your app with 1,000+ others.

Become a Zapier Integration Partner

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.

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