Gmail
When this happens...
Google SheetsNew or Updated Spreadsheet Row
Then do this...
GmailCreate Draft (Legacy)

Spreadsheets make excellent repositories when you're gathering information for your outreach. Once you're happy with what you've put together, use this Google Sheets-Gmail integration to kick off your workflow: change a column on your sheet to signify you're ready, and the Zap will trigger. It will then create a draft email for you on Gmail, complete with custom copy and values from your spreadsheet so everything is ready for a final scan and to be sent off.

How It Works

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

What You Need

  • Google Sheets 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!
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 Worksheet

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

New Starred Email

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

Create Spreadsheet Row

Create a new row in a specific spreadsheet.

New Thread

Triggers when a new thread starts.

Update Spreadsheet Row

Update a row in a specific spreadsheet.

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.

See Google Sheets Integrations