Google Sheets + OpenAI: cold email drafts ready fast
You know the feeling: a lead list is “ready,” but writing the actual cold emails turns into an all-day project. You copy company names, skim websites, try to sound personal, then end up rewriting the same message ten different ways because the tone keeps drifting.
This is where Sheets OpenAI emails helps. Marketing managers trying to hit outreach numbers feel it first. But agency owners building campaigns for clients and small business operators doing DIY lead gen run into the same wall. The outcome is simple: email drafts appear inside your Google Sheet, consistently written and ready for review.
This workflow pulls only the rows you want, generates a subject + body with OpenAI, then writes the results back to the exact row. Here’s what it does, what you get, and how to set it up without turning it into a “project.”
How This Automation Works
The full n8n workflow, from trigger to final output:
n8n Workflow Template: Google Sheets + OpenAI: cold email drafts ready fast
flowchart LR
subgraph sg0["When clicking ‘Test workflow’ Flow"]
direction LR
n0@{ icon: "mdi:play-circle", form: "rounded", label: "When clicking ‘Test workflow’", pos: "b", h: 48 }
n1@{ icon: "mdi:database", form: "rounded", label: "Add Row1", pos: "b", h: 48 }
n2["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>Code1"]
n3@{ icon: "mdi:swap-vertical", form: "rounded", label: "Loop Over Items", pos: "b", h: 48 }
n4@{ icon: "mdi:database", form: "rounded", label: "Update row in sheet", pos: "b", h: 48 }
n5@{ icon: "mdi:robot", form: "rounded", label: "email writer", pos: "b", h: 48 }
n2 --> n4
n1 --> n3
n5 --> n2
n3 --> n5
n4 --> n3
n0 --> n1
end
%% Styling
classDef trigger fill:#e8f5e9,stroke:#388e3c,stroke-width:2px
classDef ai fill:#e3f2fd,stroke:#1976d2,stroke-width:2px
classDef aiModel fill:#e8eaf6,stroke:#3f51b5,stroke-width:2px
classDef decision fill:#fff8e1,stroke:#f9a825,stroke-width:2px
classDef database fill:#fce4ec,stroke:#c2185b,stroke-width:2px
classDef api fill:#fff3e0,stroke:#e65100,stroke-width:2px
classDef code fill:#f3e5f5,stroke:#7b1fa2,stroke-width:2px
classDef disabled stroke-dasharray: 5 5,opacity: 0.5
class n0 trigger
class n5 ai
class n1,n4 database
class n2 code
classDef customIcon fill:none,stroke:none
class n2 customIcon
The Problem: Cold Email Drafting Eats Your Best Hours
Cold email “personalization” is usually fake personalization. You intend to reference the prospect’s business, but you’re staring at a spreadsheet with 200 rows and you can’t realistically research each clinic, write a clean opener, and still have energy left to run the rest of your marketing. So drafts come out rushed. Or inconsistent. Or they sound like everyone else’s template, which gets ignored. And when you do take the time to write thoughtfully, you end up stuck in a loop of copy-paste tweaks that never really end.
It adds up fast. The friction compounds, especially when you’re trying to do this weekly instead of once.
- Writing even 30 decent first drafts can take about 2–3 hours, and that’s before edits.
- Small inconsistencies in tone (too pushy, too vague) create rework across the whole batch.
- Spreadsheet columns get messy, so you lose track of what’s drafted, approved, and ready to send.
- Manual personalization invites errors like the wrong company name in the wrong email, which is honestly painful.
The Solution: Google Sheets to OpenAI Drafts, Written Back to the Same Row
This n8n workflow turns your Google Sheet into a draft factory. You keep a lead list with fields like verified email, company name, description, website, and a category marker. When you run the workflow, it pulls only the rows that match your criteria (for example, “Good” leads that haven’t been drafted yet). Then OpenAI (GPT-4o-mini) generates a subject line and email body that reads like you did quick research. After that, the workflow cleans up the AI response, extracts the subject and body, and updates the exact same row in Google Sheets. It also flips a status field (like “email created” to “yes”) so you can track progress without guesswork.
The workflow starts with a manual trigger, so you run it when you’re ready. n8n processes your leads in batches, generates one draft per prospect, then writes the results back into your sheet until the list is done. No tab juggling. No copy-paste marathon.
What You Get: Automation vs. Results
| What This Workflow Automates | Results You’ll Get |
|---|---|
|
|
Example: What This Looks Like
Say you want to draft 60 cold emails for dental clinics each week. Manually, even a quick “personalized” draft often takes about 5 minutes per row once you read the description, check the website, and write a subject line, which is roughly 5 hours total. With this workflow, you trigger it once, let n8n loop through the 60 rows, and the drafts are written back into the sheet as it runs. Your “work” becomes review and light edits, often closer to 30–45 minutes instead of an afternoon.
What You’ll Need
- n8n instance (try n8n Cloud free)
- Self-hosting option if you prefer (Hostinger works well)
- Google Sheets for your lead list and draft storage
- OpenAI API to generate the subject and body
- Google Sheets OAuth2 credentials (create in Google Cloud Console)
Skill level: Beginner. You’ll connect accounts, map sheet columns, and paste a prompt you can tweak later.
Don’t want to set this up yourself? Talk to an automation expert (free 15-minute consultation).
How It Works
You kick it off manually. Run the workflow when your sheet is ready, which is great if you want a human review step before anything gets sent.
Google Sheets is filtered before anything happens. The workflow retrieves rows and only keeps prospects that match your rules (like category equals “Good” and email created equals “no”), so you don’t waste tokens drafting for the wrong leads.
OpenAI writes one email per prospect. n8n loops through rows in batches and feeds the company name, description, and website into GPT-4o-mini, asking for a structured JSON response with a subject and body.
Your sheet gets updated in place. A code step parses the JSON cleanly, then Google Sheets writes the subject, body, and a “done” marker back to the same row so you can sort, assign review, or export to your sending tool.
You can easily modify the filter logic to target a different segment based on your needs. See the full implementation guide below for customization options.
Step-by-Step Implementation Guide
Step 1: Configure the Manual Trigger
Set up the workflow entry point so you can manually run the automation while testing.
- Add and position Manual Start Trigger as the first node in the workflow.
- Connect Manual Start Trigger to Retrieve Sheet Rows to start the data pull on each manual run.
Step 2: Connect Google Sheets
Configure the Google Sheets nodes to read target rows and update results back into the sheet.
- Open Retrieve Sheet Rows and select the spreadsheet Document as
verified emailsand Sheet ascalifornia. - In Retrieve Sheet Rows, set filters: category =
Goodand email created =no. - Credential Required: Connect your googleSheetsOAuth2Api credentials to Retrieve Sheet Rows.
- Open Update Sheet Row and confirm Operation is
updatewith the same Document and Sheet values. - Set the Columns mapping to use expressions: body =
{{ $json.body }}, email subject ={{ $json.subject }}, EMAIL verified ={{ $('Retrieve Sheet Rows').item.json['EMAIL verified'] }}, and email created =yes. - Credential Required: Connect your googleSheetsOAuth2Api credentials to Update Sheet Row.
EMAIL verified, email subject, body, and email created so the update mapping can match correctly.Step 3: Set Up Batch Processing
Use batching to process rows one at a time, which prevents rate limits and ensures each draft is parsed and saved before continuing.
- Connect Retrieve Sheet Rows to Batch Iterator.
- Connect the second output of Batch Iterator to Compose Email Draft so each row is processed sequentially.
- Connect Update Sheet Row back into Batch Iterator to move to the next item after each update.
Step 4: Configure AI Drafting and Parsing
Compose personalized email openers using OpenAI, then parse the JSON response into structured fields for storage.
- Open Compose Email Draft and set Model to
gpt-4o-mini. - In Compose Email Draft, confirm the system and user prompt include the JSON output format and data references like
{{ $json['EMAIL verified'] }},{{ $json.companyName }},{{ $json[' description'] }}, and{{ $json.website }}. - Credential Required: Connect your openAiApi credentials to Compose Email Draft.
- Open Parse Draft JSON and paste the provided JavaScript in Code to safely parse the OpenAI response into
subjectandbody. - Connect Compose Email Draft to Parse Draft JSON, and connect Parse Draft JSON to Update Sheet Row.
Step 5: Test & Activate Your Workflow
Validate the full run and confirm updates are written back to Google Sheets before going live.
- Click Execute Workflow to run Manual Start Trigger and process a sample set of rows.
- Verify that Compose Email Draft returns a JSON message and that Parse Draft JSON outputs
subjectandbody. - Check the Google Sheet to confirm Update Sheet Row writes the email subject and body, and sets email created to
yes. - Once verified, switch the workflow to Active for production use.
Common Gotchas
- Google Sheets credentials can expire or need specific permissions. If things break, check the n8n Credentials area and confirm the Google account still has access to that sheet first.
- If you’re using Wait nodes or external rendering, processing times vary. Bump up the wait duration if downstream nodes fail on empty responses.
- OpenAI prompts that “kind of work” still create slow edits. Add your brand voice, offer, and forbidden phrases early or you will be rewriting every draft.
Frequently Asked Questions
About 30 minutes if your sheet columns are already in place.
No. You’ll mostly map fields from your sheet and paste a prompt. The included code step is already done for you, unless you want to customize parsing.
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 (often just a few dollars for hundreds of drafts).
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.
Yes, and it’s mostly prompt work. Swap the service offer and examples inside the “Compose Email Draft” OpenAI node, then adjust your sheet columns if you want different inputs (like “jobTitle” or “techStack”). Common tweaks include changing the tone to more formal, adding a hard constraint on length (like “under 90 words”), and inserting a specific CTA that matches your funnel.
Most of the time it’s expired OAuth access or the wrong Google account. Reconnect Google Sheets in n8n Credentials and confirm the sheet is shared with that account. Also double-check the spreadsheet ID and tab name, because a renamed tab can silently break lookups. If it fails only on updates, the service account/user may have view-only access.
Hundreds per run is normal, and you can batch through more as long as you stay within your n8n and OpenAI limits. On n8n Cloud Starter, you are capped by monthly executions, so very large sheets may push you toward a higher plan. If you self-host, there’s no execution limit, but your server resources and OpenAI rate limits become the bottleneck. Practically, most teams run this in batches of 25–100 rows to keep review manageable.
Often, yes, because this flow benefits from looping, structured parsing, and control over how rows are filtered and marked complete. n8n handles batch iteration cleanly, and you’re not forced into paying more just to add branches, retries, or extra processing. If you only need “new row → send to OpenAI → write back,” Zapier or Make can work fine. The moment you care about filtering logic, status fields, and scaling drafts without surprises, n8n is usually the calmer choice. Talk to an automation expert if you want a quick recommendation for your stack.
Once this is running, your spreadsheet stops being a list and starts being a production line. You review, approve, and move on.
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.
