Google Sheets
When this happens...
Google SheetsNew Spreadsheet Row
Then do this...
GmailCreate Draft (Legacy)

If you're using a spreadsheet to track all those leads, set up this Google Sheets-Gmail integration to automate the outreach process. It will then trigger whenever you add a new row on Google Sheets, automatically preparing a new draft email for you on Gmail. From there you can make sure the dynamic content was added to your template as you needed, and hit send!

How It Works

  1. A new row is added on Google Sheets
  2. Zapier automation creates a new draft email on Gmail

What You Need

  • 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!
New Spreadsheet Row

Notifies your Zap when a new row is added to the bottom of a spreadsheet.

Create Worksheet

Create a blank worksheet with a title. Optionally, provide headers.

New or Updated Spreadsheet Row

Notifies your Zap when a new row is added or modified in a spreadsheet.

Create Spreadsheet Row

Create a new row in a specific spreadsheet.

New Email Matching Search

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

Update Spreadsheet Row

Update a row in a specific spreadsheet.

New Labeled Email

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

Create Draft

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

New Attachment

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

Send Email

Create and send a new email message.

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

Become a Zapier Integration Partner

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

Learn More

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.

See Gmail Integrations