The Rundown: In this tutorial, you’ll learn how to create email drafts in Gmail using Zapier and Google Sheets. This is one of the simplest but most effective automations I use. It takes a list of contacts from Google Sheets (or really any data source Zapier supports), and automatically creates draft emails in Gmail. Personally, this workflow saves me a ton of time - especially when I’m doing repetitive communication with subscribers, leads, or workshop attendees.

🧰 Who is this useful for:

• Coaches and consultants managing client outreach
• Newsletter creators sending subscriber updates
• Sales teams handling cold or warm leads
• Anyone tired of manually drafting emails one by one

STEP 1: Accessing and setting up your Zap

First, open Zapier.

• If you don’t already have a Zap, click Create a Zap.
• If you do, you can just edit an existing one.

For me, starting fresh works best so I can control each step.

STEP 2: Set up your actions and triggers for your zap

Now we’ll set up the Trigger App. This is where Zapier pulls the information from.

• In my case, I’m using Google Sheets.
• Zapier has over 7,000 connections, so you can plug in almost any data source.

Here’s how I configure it:

1. Select Google Sheets as the app.
2. Choose the event: New Spreadsheet Row. That means every time a new contact is added, the workflow fires.
3. Connect your Google account, then pick the right spreadsheet.
4. • I used one called ChatGPT Tips.
   • Inside it, I selected the correct tab (Sheet1).

Pro Tip: Always hit “Refresh & Find New Records” to make sure Zapier is seeing the latest data. I’ve had moments where I forgot to refresh, and Zapier missed new leads.

STEP 3: Draft your email in gmail

Next, we’ll create the Action Step.

Select Gmail as the app, choose Create Draft (I prefer drafts over auto-send because it gives me control - I can tweak wording if I want before hitting send). Then connect your Gmail account.

Now set up the draft:

• To: Pull the email address directly from your sheet.
• Subject: Whatever fits your workflow (mine was “Thanks for joining the workshop”).
• Body Copy: I’ve found HTML works best here - you can embed links, format text, and keep things professional.

After you test this step, Zapier will create a draft in Gmail. In my test, it popped up perfectly formatted with my subject line, message, and embedded links.

STEP 4: Test and refine the output

To see it in action:

1. Go back to your Google Sheet.
2. Paste in a batch of new contacts (I tested with 10 rows).
3. Hit Run in Zapier.

What happens:

• Zapier immediately detects the new rows.
• Gmail creates the corresponding drafts - ready for me to review and send.

When I tested, all 10 drafts showed up instantly. No manual copy-pasting, no repetitive typing. Below you can find the final zap setup:

STEP 5: Publish zap and share with others

Once it’s working, save the Zap.

• Rename it something clear (e.g., Google Sheets → Gmail Drafts).
• You can duplicate it later and tweak for different audiences (free vs. paid subscribers, different campaigns, etc.).

Pro Tip: The simplest of workflows can often save you the most time. For me, it’s been a huge time-saver in handling email communications without burning hours in Gmail.