Try It

Create drafts on Gmail for new rows on Google Sheets

  1. When this happensStep 1: New Spreadsheet Row

  2. Then do thisStep 2: Create Draft

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
Try It

Connect Gmail + Google Sheets in Minutes

It's easy to connect Gmail + Google Sheets and requires absolutely zero coding experience—the only limit is your own imagination.

All Triggers & Actions

New Attachment

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

New Labeled Email

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

New Email Matching Search

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

New Thread

Triggers when a new thread starts.

New Spreadsheet Row

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

New Label

Triggers when you add a new label.

New Email

Triggers when a new e-mail appears in the specified mailbox.

New Starred Email

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

New Spreadsheet Row (Team Drive)

Triggered when a new row is added to the bottom of a spreadsheet - works best with Team Drives.

New Spreadsheet

Triggered when you create a new spreadsheet.

Connect the Apps You Use Every Day

Get Started with a Free Account

Or
By signing up, you agree to Zapier’s Terms of Service