ConditionalVisibility

new-products-promo

connect-gmail-with-google-sheets-01

connect-gmail-with-google-sheets-02

connect-gmail-with-google-sheets-03

connect-gmail-with-google-sheets-04

connect-gmail-with-google-sheets-05

connect-gmail-with-google-sheets-06

connect-gmail-with-google-sheets-07

connect-gmail-with-google-sheets-08

connect-gmail-with-google-sheets-09

connect-gmail-with-google-sheets-10

connect-gmail-with-google-sheets-11

connect-gmail-with-google-sheets-12

Zapier tutorials

connect-gmail-with-google-sheets-00-hero

Gmail

Google Sheets

In this article, we'll show you how to integrate Gmail with Google Sheets, no matter your use case.

How to connect Gmail with Google Sheets

Track and manage your new emails without slowing for manual updates. Once this integration is active, every new email you receive in Gmail will be automatically passed to a row in a specified Google Sheets spreadsheet, safe and sound. 

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.

Triggers when you receive a new attachment.

New Attachment

New Label

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

New Labeled Email

Triggers when a new email appears in the specified mailbox.

New Email

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

New Email Matching Search

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

New Starred Email

New Thread

Find Email

Find or Send Email

Add Label to Email

Delete Email

Create Draft

Create a draft reply to an existing email.

Create Draft Reply

Create Label

Send Email

Remove Label From Email

Reply to Email

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

Triggers when a new row is added to the bottom of a Google Team Drive spreadsheet.

New Spreadsheet Row (Team Drive)

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

New Spreadsheet Row

Triggers when a new spreadsheet is created.

New Spreadsheet

Triggers when a new row is added or an existing row is updated in a spreadsheet. Optimized for Team Drive.

New or Updated Spreadsheet Row (Team Drive)

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

New or Updated Spreadsheet Row

Triggers when a worksheet is created in a spreadsheet.

New Worksheet

Find up to 500 rows based on a column and value as line items.

Lookup Spreadsheet Rows (Advanced)

Find Worksheet

Return up to 500 rows as a single JSON value or as line items.

Get Many Spreadsheet Rows (Advanced)

Find a specific spreadsheet row based on a column and value. If found, it returns the entire row. Optionally, create a new row if no match is found.

Lookup Spreadsheet Row

Finds or creates a specific find worksheet.

Find or Create Worksheet

Find or Create Row

Create a new column in a specific spreadsheet.

Create Spreadsheet Column

Create a new row in a specific spreadsheet.

Create Spreadsheet Row

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

Create Multiple Spreadsheet Rows

Creates a new spreadsheet row at the top of a spreadsheet (after the header row).

Create Spreadsheet Row at Top

Creates a new worksheet by copying an existing worksheet.

Copy Worksheet

Creates a new spreadsheet. Choose from a blank spreadsheet, a copy of an existing one, or one with headers.

Create Spreadsheet

Creates a new worksheet in a Google Sheet.

Create Worksheet

Clears the contents of the selected row(s) while keeping the row(s) intact in the spreadsheet.

Clear Spreadsheet Row(s)

Deletes the selected row(s) from the spreadsheet. This action removes the row(s) and all associated data.

Delete Spreadsheet Row(s)

Format Spreadsheet Row

Update Spreadsheet Row

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

Update Spreadsheet Row(s)

Custom Actions (Beta)

This is an advanced action which makes a raw HTTP request that includes this integration's authentication.

API Request (Beta)

Add new emails in Gmail to Google Sheets rows

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: 

Save new Gmail emails matching certain traits to a Google Spreadsheet

Easily track and manage important email data  with this integration by Zapier. Set it up and this Zap will automatically trigger with every new email you label in Gmail, adding its data to a new row on Google Sheets to build a per-label index of your messages.

Add new labeled Gmail emails to rows in Google Sheets

This integration makes it easy to trigger an email via Gmail for updates in a Google Spreadsheet. You can trigger an email based on any update or specific updates to a certain column. Get step-by-step directions in our 

Send emails via Gmail when Google Sheets rows are updated

After you set this Zapier integration up, a Gmail email will be automatically sent to any recipient (including yourself) whenever a row is added to a Google Sheets spreadsheet. Or, if you want to get really fancy, you can use another Zap to populate the spreadsheet. The sky is the limit!

How to connect Gmail with Google Sheets

Related articles

Improve your productivity automatically. Use Zapier to get your apps working together.