When this happens...
Google SheetsNew Spreadsheet Row
Then do this...
GmailSend Email

After you set this Zapier integration up, a Gmail email will be automatically sent to any recipient (including yourself) when a row is added to a Google Sheets spreadsheet. This works great with Google Forms and Google Sheets alike.

How It works

  1. Create a Google spreadsheet or form to trigger Gmail emails from.
  2. Anytime you want a send an email, just add another row in the spreadsheet.

If you use Google Forms, when anyone fills out the form that will send an email too. Or, if you want to get really fancy, you can use another Zap to populate the spreadsheet. The sky is the limit!

What You Need

  • Google Spreadsheet account
  • Gmail 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!
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

Create a new row in a specific spreadsheet.

Gmail
New Starred Email

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

Google Sheets
Update Spreadsheet Row

Update a row in a specific spreadsheet.

Gmail
New Thread

Triggers when a new thread starts.

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