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 Gmail + Google Sheets and requires absolutely zero coding experience—the only limit is your own imagination.

When this happens...
then do this!
New Email Matching Search

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

Create Draft

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

New Labeled Email

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

Send Email

Create and send a new email message.

New Attachment

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

Create Spreadsheet Row

Create a new row in a specific spreadsheet.

New Starred Email

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

Update Spreadsheet Row

Update a row in a specific spreadsheet.

New Thread

Triggers when a new thread starts.

Add Label to Email

Add a label to an email message.

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

Become a Zapier Integration Partner

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.

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