🔓 Unlock all 10,000+ workflows & prompts free Join Newsletter →
✅ Full access unlocked — explore all 10,000 AI workflow and prompt templates Browse Templates →
Home › n8n › Workflow
January 22, 2026

Google Sheets to Gmail, follow ups that pause on reply

Google Sheets to Gmail, follow ups that pause on reply - n8n workflow automation template
Lisa Granqvist Partner Workflow Automation Expert
Google Sheets to Gmail, follow ups that pause on reply - n8n workflow automation template
Get a free AI assessment → Get a free AI assessment → ⬇️ Use template

Your outreach looks “organized” right up until follow-ups start. One lead replies, another gets missed, and suddenly you’re scanning Gmail threads while your Google Sheet turns into a graveyard of half-updated statuses.

This Sheets Gmail followups automation hits sales reps hardest, but agency owners and consultants feel it too. You get a consistent 3-email sequence that pauses the second a prospect replies, so you stop annoying warm leads and you stop losing track of who needs what.

Below you’ll see how the workflow runs, what results you can expect, and what you need to turn a simple spreadsheet into a reliable follow-up machine.

How This Automation Works

The full n8n workflow, from trigger to final output:

n8n Workflow Template: Google Sheets to Gmail, follow ups that pause on reply

The Problem: Follow-Ups Break the Moment You Get Busy

Most cold outreach doesn’t fail because your first email is terrible. It fails because follow-ups are inconsistent. You send Email 1, then the day gets away from you. Or you do follow up, but you accidentally follow up to someone who already replied because the “status” in your sheet is two days behind your inbox. Even worse, you change the wording every time, so you can’t tell what’s actually working. It’s messy, and frankly it drains focus fast.

It adds up fast. Here’s where it breaks down in real life.

  • Manually sending three emails to 30 prospects can eat up about 2 hours, and that’s before you even log notes.
  • Your Google Sheet stops being trustworthy because “sent” and “replied” updates happen when you remember, not when they happen.
  • Replying prospects still get scheduled follow-ups, which is awkward at best and reputation-damaging at worst.
  • Even good templates underperform when timing is random and you send on bad days (hello, Monday inbox pileups).

The Solution: A Google Sheets → Gmail Sequence That Stops on Reply

This workflow turns one Google Sheet row into a complete, scheduled, personalized outreach sequence. When you add a new prospect (name, email, company, role, sector), n8n calculates send times that avoid the “bad days” and aim for mornings on Tuesday, Wednesday, or Thursday. Then AI drafts Email 1 based on the prospect profile, you send through Gmail, and the Sheet is updated immediately so your tracking stays real. After that, the system waits the right number of days and sends Email 2 and Email 3 only if the lead hasn’t replied. If a reply shows up in Gmail, the workflow flags that prospect as hot, alerts you in Slack, and pauses the rest automatically.

The workflow starts with a new row in Google Sheets. AI generates message copy (French or English depending on the prospect), Gmail sends on a schedule, and Google Sheets stays updated with every send and every “stop” event. Replies change the whole path, which is the point.

What You Get: Automation vs. Results

Example: What This Looks Like

Say you add 30 new prospects each week to your sheet. Manually, a 3-email sequence is about 90 sends, and even at “only” 2 minutes per send (open, paste, tweak, double-check, log) that’s roughly 3 hours. With this workflow, adding the rows might take 20 minutes total, then emails send automatically over the week at the planned times. Replies pause the sequence, and your sheet updates without you babysitting it.

What You’ll Need

  • n8n instance (try n8n Cloud free)
  • Self-hosting option if you prefer (Hostinger works well)
  • Google Sheets for lead list and status tracking
  • Gmail to send emails and detect replies
  • OpenAI API key (get it from your OpenAI dashboard)

Skill level: Intermediate. You’ll connect accounts, map sheet columns, and verify your sending rules.

Don’t want to set this up yourself? Talk to an automation expert (free 15-minute consultation).

How It Works

A new prospect is added to Google Sheets. The workflow triggers on the new row, then pulls the fields you care about (name, role, company, industry, language signals).

Send times are planned around deliverability. A scheduler calculates the next Tue/Wed/Thu morning window and adds small randomization so your Gmail activity doesn’t look robotic.

AI writes each email, then Gmail sends it. Email 1 goes out at day 0, then n8n waits 3 days for Email 2, waits 4 more days for Email 3, and updates your Sheet after each send so you always know what happened.

Replies stop everything and alert you. A Gmail reply watcher flags the prospect as hot in Google Sheets and pings Slack, which means the follow-up path gets cut off automatically.

You can easily modify the send days and wait times to match your market based on your needs. See the full implementation guide below for customization options.

Step-by-Step Implementation Guide

Step 1: Configure the Trigger Type

This workflow starts from a new row in Google Sheets and also watches Gmail replies for hot prospects.

  1. Open Sheet Row Added Trigger and set Event to rowAdded.
  2. Choose the correct Document and Sheet where new prospect rows will appear.
  3. Credential Required: Connect your googleSheetsTriggerOAuth2Api credentials.
  4. Open Gmail Reply Watcher and confirm Filters → labelIds includes INBOX and Poll Times is set to everyMinute.
  5. Credential Required: Connect your gmailOAuth2 credentials.
Tip: Keep the Gmail watcher label filter tight to avoid flagging unrelated replies as “hot.”

Step 2: Connect Google Sheets

Multiple Google Sheets nodes update scheduling, status, and hot-prospect flags. Configure the document and sheet IDs consistently.

  1. In Update Schedule Row, map Email to {{ $json.Email }} and scheduling columns to {{ $json.email1_at }}, {{ $json.email2_at }}, and {{ $json.email3_at }}.
  2. In Update Email 1 Status and Update Email 2 Status, verify Operation is update and mappings include {{ $json.to }} with timestamps like {{ $now.toISO() }}.
  3. In Finalize Sheet Update, ensure Operation is appendOrUpdate and Email maps to {{ $json.to }} with =Sent at {{ $now.toISO() }} for email3_Statut.
  4. In Flag Prospect Hot, set Email to {{ $json.From }} and Statut Prospect to hot.
  5. Credential Required: Connect your googleSheetsOAuth2Api credentials to all Google Sheets update nodes (7 total, including Retrieve Status Pre Email 2 and Retrieve Status Pre Email 3).
⚠️ Common Pitfall: Mismatched sheet IDs between nodes can cause status updates to write to a different spreadsheet than the trigger is watching.

Step 3: Set Up the Scheduling and Company Profile Processing

New rows are split into parallel branches for scheduling and company profile enrichment.

  1. Confirm Sheet Row Added Trigger outputs to both Smart Send Scheduler and Company Profile Setup in parallel.
  2. In Smart Send Scheduler, keep the JavaScript code intact to calculate email1_at, email2_at, and email3_at scheduling fields.
  3. In Company Profile Setup, set companyName to YOUR COMPANY NAME, senderName to YOUR NAME – YOUR TITLE, and Description of the companies or product to your value proposition.
  4. Ensure Company Profile Setup outputs to Combine Streams A, Combine Streams B, and Combine Streams C in parallel.
Tip: If your schedule needs different weekdays or send times, adjust the constants at the top of Smart Send Scheduler.

Step 4: Configure the Wait Timers and Status Checks

Each email is delayed until its scheduled time, and the workflow checks for “hot” prospects before sending follow-ups.

  1. In Delay Until Email 1 Time, set Resume to specificTime and Date Time to {{ $('Smart Send Scheduler').item.json.email1_at }}.
  2. In Delay Until Email 2 Time, set Date Time to {{ $('Smart Send Scheduler').item.json.email2_at }}, then connect to Retrieve Status Pre Email 2 and Hot Check After Email 2.
  3. In Delay Until Email 3 Time, set Date Time to {{ $('Smart Send Scheduler').item.json.email3_at }}, then connect to Retrieve Status Pre Email 3 and Hot Check After Email 3.
  4. In Hot Check After Email 2 and Hot Check After Email 3, confirm the condition checks {{ $json['Statut Prospect'] }} equals hot.
⚠️ Common Pitfall: If the “hot” status column name changes in the sheet, the IF nodes will always evaluate false and send follow-ups to replied prospects.

Step 5: Set Up AI and Gmail Sending

Three AI agents write and send Email 1, 2, and 3. Each agent uses a dedicated OpenAI chat engine and Gmail tool.

  1. In AI Agent Email Intro, review the Text prompt and ensure prospect fields are mapped as shown (e.g., {{ $json["First Name"] }} and {{ $json.Email }}).
  2. In AI Agent Followup and AI Agent Final Followup, verify the timing fields are present such as {{ $json.email2_at }} and {{ $json.email3_at }}.
  3. AI Chat Engine A is connected as the language model for AI Agent Email Intro — Credential Required: Connect your openAiApi credentials.
  4. AI Chat Engine B is connected as the language model for AI Agent Followup — Credential Required: Connect your openAiApi credentials.
  5. AI Chat Engine C is connected as the language model for AI Agent Final Followup — Credential Required: Connect your openAiApi credentials.
  6. In Gmail Dispatch Email A, Gmail Dispatch Email B, and Gmail Dispatch Email C, confirm sendTo, subject, and message are set to {{ $fromAI('to') }}, {{ $fromAI('subject') }}, and {{ $fromAI('message_html') }}.
  7. Credential Required: Connect your gmailOAuth2 credentials to the Gmail tool nodes. These are AI tool sub-nodes—credentials are managed on the tool nodes, not inside the AI agents.

Step 6: Parse Agent Output and Update Email Status

Each AI agent returns JSON that must be parsed before writing status updates back to the sheet.

  1. In Parse Agent Output A, Parse Agent Output B, and Parse Agent Output C, keep the JavaScript parser that converts the AI response to JSON.
  2. Ensure Parse Agent Output A connects to Update Email 1 Status and Parse Agent Output B connects to Update Email 2 Status.
  3. Confirm Parse Agent Output C connects to Finalize Sheet Update to mark Email 3 as sent.
⚠️ Common Pitfall: If the AI output is not valid JSON, the parser nodes will fail. Keep the agent’s “FINAL OUTPUT FORMAT” instructions intact.

Step 7: Configure Slack Alerts and Reply Handling

Replies are flagged and posted to Slack for quick follow-up.

  1. Verify Gmail Reply Watcher connects to Flag Prospect Hot, which updates Statut Prospect to hot.
  2. Connect Flag Prospect Hot to Slack Prospect Reply Alert to notify your team.
  3. In Slack Prospect Reply Alert, set Channel to your desired Slack channel and keep Text to your message or customize it.
  4. Credential Required: Connect your slackOAuth2Api credentials for Slack Prospect Reply Alert.

Step 8: Add Error Handling

The workflow uses a dedicated error trigger to alert Slack when any node fails.

  1. Open Failure Event Trigger and ensure it is connected to Slack Error Notification.
  2. In Slack Error Notification, keep the Text field with error details such as {{ $json.execution.error.message }} and {{ $json.execution.lastNodeExecuted }}.
  3. Credential Required: Connect your slackOAuth2Api credentials.

Step 9: Test and Activate Your Workflow

Run a controlled test to confirm the scheduling, AI content, Gmail send, and sheet updates work end-to-end.

  1. Click Execute Workflow and add a test row to the sheet monitored by Sheet Row Added Trigger.
  2. Verify that Smart Send Scheduler produces email1_at, email2_at, and email3_at and that Update Schedule Row writes them back.
  3. Confirm that after the scheduled wait, AI Agent Email Intro sends via Gmail Dispatch Email A, and Update Email 1 Status updates the sheet.
  4. Send a reply to the test email and confirm Gmail Reply Watcher triggers Flag Prospect Hot and Slack Prospect Reply Alert.
  5. Once successful, switch the workflow to Active for production use.
🔒

Unlock Full Step-by-Step Guide

Get the complete implementation guide + downloadable template

Common Gotchas

  • Google Sheets permissions can be sneaky. If rows aren’t updating, check the n8n credential and the specific spreadsheet sharing settings first.
  • If you’re using Wait nodes or external scheduling logic, processing times vary. Bump up the wait duration if downstream nodes fail on empty responses.
  • OpenAI prompts that are too generic create bland emails. Add your value prop, positioning, and a couple “do not say” rules early, or you will be editing outputs forever.

Related Workflows

If your team also needs a database-backed system instead of a spreadsheet, Supabase + Mailgun: cold emails that follow up is a solid companion workflow for scaling beyond “Sheet-as-CRM.”

For teams doing list building and message writing separately, Google Sheets + ChatGPT: personalized cold openers helps you generate first-line openers you can feed into this follow-up sequence.

When lead quality is your bottleneck (duplicates, bad formatting, missing fields), Google Sheets to Instantly, cleaner leads uploaded fits nicely upstream, so only clean prospects enter your Gmail sequence.

Need quick personalization at scale without rewriting your whole template? Google Sheets + OpenAI: cold email icebreakers done focuses on icebreakers you can drop into Email 1 for a more human first touch.

Finally, if you want a simpler “write the opener, you handle the rest” approach, Google Sheets + OpenAI: cold email openers ready is useful when you’re not ready to automate the entire follow-up chain.


Quick reference:

Frequently Asked Questions

How long does it take to set up this Sheets Gmail followups automation?

About 45 minutes if your Sheet columns are already clean.

Do I need coding skills to automate Sheets Gmail followups?

No. You will mostly connect accounts and map fields from your sheet into the email prompts.

Is n8n free to use for this Sheets Gmail followups workflow?

Yes. n8n has a free self-hosted option and a free trial on n8n Cloud. Cloud plans start at $20/month for higher volume. You’ll also need to factor in OpenAI API costs (about $0.50 per 100 emails in this setup).

Where can I host n8n to run this automation?

Two options: n8n Cloud (managed, easiest setup) or self-hosting on a VPS. For self-hosting, Hostinger VPS is affordable and handles n8n well. Self-hosting gives you unlimited executions but requires basic server management.

Can I customize this Sheets Gmail followups workflow for a 5-email sequence instead of 3?

Yes, but plan to duplicate the “generate email → parse output → send → update sheet → wait” pattern for each extra message. In practice, you’d add another AI Agent node for Email 4, another Gmail send node, and another status update in Google Sheets. You’ll also want to extend the scheduler logic so send days still land on Tue/Wed/Thu. Most people also add a “stop after X days” rule so long sequences don’t drag on forever.

Why is my Google Sheets connection failing in this workflow?

Usually it’s a permissions issue on the spreadsheet or an expired credential inside n8n. Reconnect Google Sheets in n8n, then confirm the exact file and worksheet still exist and haven’t been renamed. If updates fail only sometimes, check whether someone added required columns or changed headers, because field mapping can break quietly.

How many prospects can this Sheets Gmail followups automation handle?

A few hundred prospects per week is normal if your Gmail sending limits allow it.

Is this Sheets Gmail followups automation better than using Zapier or Make?

For this kind of sequence, n8n tends to be easier to keep “stateful” because you can branch on lead status, merge streams, and run multiple wait periods without duct-taping extra zaps together. Reply detection is also more natural since the workflow can react to Gmail triggers and update your Google Sheet immediately. Zapier or Make can work, but multi-step follow-up logic often gets expensive and fiddly. If you’re only sending one email and logging it, they’re fine. If you want the pause-on-reply behavior plus scheduling rules, n8n is usually the cleaner fit. Talk to an automation expert if you want help choosing.

Set this up once and your follow-ups keep running, even when your calendar gets ugly. The workflow handles the repetitive parts, so you can spend your time on replies that actually matter.

Need Help Setting This Up?

Our automation experts can build and customize this workflow for your specific needs. Free 15-minute consultation—no commitment required.

Talk to Automation Expert →

Lisa Granqvist

Workflow Automation Expert

Expert in workflow automation and no-code tools.

×

Use template

Get instant access to this n8n workflow Json file

Copy and import json workflow into your n8n workflow

💬
Get a free quote today!
Get a free quote today!

Tell us what you need and we'll get back to you within one working day.

Get a free quote today!
Get a free quote today!

Tell us what you need and we'll get back to you within one working day.