Google Sheets to Instantly, personalized cold emails
You’ve got leads sitting in Google Sheets, “ready” for outreach, and somehow it still turns into a messy loop of research tabs, half-finished drafts, and “I’ll send it later.” Then later never happens.
This is the kind of work that quietly drains marketing managers running campaigns, sales reps trying to hit daily activity, and founders doing outbound between meetings. With Sheets Instantly emails automation, you turn a spreadsheet row into a researched, personalized cold email draft that’s ready to queue.
Below, you’ll see how the workflow runs, what it produces, and what you need to set it up without turning your week into an “automation project.”
How This Automation Works
The full n8n workflow, from trigger to final output:
n8n Workflow Template: Google Sheets to Instantly, personalized cold emails
flowchart LR
subgraph sg0["When clicking ‘Execute workflow’ Flow"]
direction LR
n0["<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/httprequest.dark.svg' width='40' height='40' /></div><br/>Add Lead to Instantly AI"]
n1@{ icon: "mdi:database", form: "rounded", label: "Add Company Info to Google S..", pos: "b", h: 48 }
n2@{ icon: "mdi:robot", form: "rounded", label: "Structured Output Parser1", pos: "b", h: 48 }
n3@{ icon: "mdi:robot", form: "rounded", label: "Generate Outreach Message", pos: "b", h: 48 }
n4@{ icon: "mdi:robot", form: "rounded", label: "Company Research", pos: "b", h: 48 }
n5@{ icon: "mdi:cog", form: "rounded", label: "Tavily", pos: "b", h: 48 }
n6@{ icon: "mdi:brain", form: "rounded", label: "OpenRouter Chat Model2", pos: "b", h: 48 }
n7@{ icon: "mdi:brain", form: "rounded", label: "OpenRouter Chat Model3", pos: "b", h: 48 }
n8@{ icon: "mdi:swap-vertical", form: "rounded", label: "Loop Over Items", pos: "b", h: 48 }
n9@{ icon: "mdi:play-circle", form: "rounded", label: "When clicking ‘Execute workf..", pos: "b", h: 48 }
n10@{ icon: "mdi:cog", form: "rounded", label: "Limit(Test)", pos: "b", h: 48 }
n11@{ icon: "mdi:database", form: "rounded", label: "Get Business card data extra..", pos: "b", h: 48 }
n5 -.-> n4
n10 --> n8
n8 --> n4
n4 --> n3
n6 -.-> n4
n7 -.-> n3
n0 --> n8
n3 --> n1
n2 -.-> n4
n1 --> n0
n11 --> n10
n9 --> n11
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 n9 trigger
class n2,n3,n4 ai
class n6,n7 aiModel
class n1,n11 database
class n0 api
classDef customIcon fill:none,stroke:none
class n0 customIcon
The Problem: Personalization Doesn’t Scale When It’s Manual
Cold email “personalization” is usually a good intention that dies in the details. You open a lead in a sheet, Google the company, skim a homepage, maybe hunt for recent news, then try to compress it into one sentence that doesn’t sound forced. Do that 20 times and your brain is mush. And if you’re switching between research, drafting, and campaign tools, mistakes creep in: wrong company names, outdated info, missing fields, or drafts that never make it into your sending platform.
It adds up fast. Here’s where it breaks down in real life:
- Research turns into tab chaos, and you still end up writing generic openers.
- Your Google Sheet becomes a “lead graveyard” because drafting takes too long to keep up.
- Copy-paste errors happen when you move drafts into Instantly, especially under time pressure.
- Tracking gets fuzzy, so you can’t tell what’s ready, drafted, sent, or stuck.
The Solution: Google Sheets → Company Research → Instantly-Ready Drafts
This n8n workflow pulls companies from Google Sheets that you’ve marked as ready for outreach, then processes them one by one so nothing gets mixed up. For each lead, it runs automated company research using a LangChain agent connected to the Tavily search tool, which gathers useful context like what the company does and what they’ve been up to recently. That research is fed into an LLM chain (via OpenRouter chat models) that writes a concise, professional cold email draft in English using your business context (YOUR_COMPANY_NAME) so the message is aligned with what you actually sell. Finally, the workflow writes the generated email back into Google Sheets for clean tracking, and can also push the lead into your Instantly campaign via HTTP request so it’s ready for sending.
The workflow starts with a manual run trigger, which is handy when you want control (for example, “generate drafts for today’s 30 leads”). From there, it fetches rows from Google Sheets, loops through them in batches, researches each company, drafts the email, logs results back to the sheet, then registers the lead in Instantly if you’ve enabled that step.
What You Get: Automation vs. Results
| What This Workflow Automates | Results You’ll Get |
|---|---|
|
|
Example: What This Looks Like
Say you generate drafts for 30 leads every morning. Manually, you might spend about 5 minutes researching each company and another 3 minutes drafting, plus a minute to paste it into Instantly. That’s roughly 9 minutes per lead, or about 4.5 hours. With this workflow, you mark 30 rows as “ready,” run it once, and let it process in the background. You’ll spend maybe 10 minutes reviewing the outputs, and the rest is handled automatically.
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 status tracking
- Instantly.ai to add leads into a campaign (optional)
- Tavily API key (get it from your Tavily dashboard)
- OpenRouter API key (get it from your OpenRouter dashboard)
Skill level: Intermediate. You’ll connect accounts, add API keys, and tweak a prompt to match your offer.
Don’t want to set this up yourself? Talk to an automation expert (free 15-minute consultation).
How It Works
You trigger a run when you’re ready. In the provided workflow, it starts with a manual run, then pulls records from Google Sheets so you control when drafts get generated.
Leads are processed one at a time. n8n loops through the sheet rows in batches, which helps keep outputs clean and makes it easier to avoid API rate limit issues.
AI research and drafting happen in sequence. Tavily gathers company info, a structured parser keeps that info usable, then the LLM chain writes a tailored email using your company context and a consistent format.
Everything is logged and optionally pushed to Instantly. The workflow writes the generated email back to Google Sheets, then sends the lead data to Instantly through an HTTP request so the campaign queue stays current.
You can easily modify the “ready” criteria to a different status column based on your needs. See the full implementation guide below for customization options.
Step-by-Step Implementation Guide
Step 1: Configure the Manual Run Trigger
Start the workflow manually so you can validate the lead processing and outreach output before automating further.
- Add and select Manual Run Trigger as the start node.
- Connect Manual Run Trigger to Retrieve Card Records to match the execution flow.
Step 2: Connect Google Sheets
Pull ready leads from Google Sheets and prepare a smaller test set before iterating through each lead.
- Open Retrieve Card Records and select your spreadsheet in Document using the ID
[YOUR_ID]. - Set Sheet Name to the target sheet with
gid=[YOUR_ID]. - Confirm the filter is set to status equals
readyin filtersUI so only ready leads are pulled. - Credential Required: Connect your googleSheetsOAuth2Api credentials in Retrieve Card Records.
- Open Limit Sample Records and set Max Items to
10to limit test volume. - Connect Limit Sample Records to Iterate Through Leads so batches are processed sequentially.
ready, Retrieve Card Records will return no rows.Step 3: Set Up Research and Email Composition (AI)
Use AI to research each company and draft a personalized outreach message.
- In Research Company Profile, set Text to
=company: {{ $json.company_name }} company website: {{ $json.website_url }}. - Ensure Research Company Profile has hasOutputParser enabled and is connected to Structured JSON Parser as the output parser.
- Connect OpenRouter Chat Model A as the language model for Research Company Profile. Credential Required: Connect your openRouterApi credentials in OpenRouter Chat Model A.
- Connect Tavily Search Tool as the tool for Research Company Profile. Credential Required: Connect your tavilyApi credentials in Tavily Search Tool.
- In Compose Outreach Email, set Text to
=name: {{ $('Iterate Through Leads').item.json.full_name }} company name: {{ $('Iterate Through Leads').item.json.company_name }} company background: {{ $json.output.comprehensiveSummary }}. - Connect OpenRouter Chat Model B as the language model for Compose Outreach Email. Credential Required: Connect your openRouterApi credentials in OpenRouter Chat Model B.
Step 4: Configure Logging and Instantly Registration
Write the research and email output back to Google Sheets and then register the lead in Instantly.
- Open Log Company Details Sheet and set Operation to
appendOrUpdate. - Map fields in Log Company Details Sheet as defined in the node: company_name to
={{ $('Limit Sample Records').item.json.company_name }}, Key Offerings to={{ $('Research Company Profile').item.json.output.keyOfferings }}, Company Summary to={{ $('Research Company Profile').item.json.output.comprehensiveSummary }}, Outreach Message to={{ $json.text }}, Company Background to={{ $('Research Company Profile').item.json.output.companyOverview }}, and Recent Company News to={{ $('Research Company Profile').item.json.output.recentWebsiteNews }}. - Credential Required: Connect your googleSheetsOAuth2Api credentials in Log Company Details Sheet.
- In Register Lead in Instantly, set URL to
https://api.instantly.ai/api/v2/leadsand Method toPOST. - Set JSON Body to
={ "campaign": "[YOUR_ID]", "email": "{{ $('Iterate Through Leads').item.json.email }}", "full_name": "{{ $('Iterate Through Leads').item.json.full_name }}", "company_name": "{{ $('Iterate Through Leads').item.json.company_name }}", "custom_variables": { "custom_body": "{{ $('Compose Outreach Email').item.json.text }}" } }. - Configure headers in Register Lead in Instantly with Authorization set to
Bearer [CONFIGURE_YOUR_TOKEN]and Content-Type set toapplication/json.
[YOUR_ID] and [CONFIGURE_YOUR_TOKEN] in Register Lead in Instantly before testing, or the API call will fail.Step 5: Test and Activate Your Workflow
Run a manual test to confirm data flows through AI research, email composition, sheet logging, and Instantly registration.
- Click Execute Workflow on Manual Run Trigger to start the test.
- Verify that Retrieve Card Records returns rows with
statusset toready, then that Limit Sample Records outputs no more than10items. - Check that Research Company Profile produces structured JSON output and that Compose Outreach Email returns a 100–150 word email body.
- Confirm Log Company Details Sheet appends/updates rows and Register Lead in Instantly returns a successful HTTP response.
- When successful, toggle the workflow to Active to enable production use.
Common Gotchas
- Google Sheets credentials can expire or lack edit access. If drafts aren’t written back, check the connected Google account permissions and the sheet name/document ID 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.
- Tavily and OpenRouter can throttle you on bigger batches. If runs stall or come back empty, reduce the batch size in the Limit/Split-in-batches area and retry.
Frequently Asked Questions
About an hour if your API keys and sheet are ready.
No. You’ll mostly paste in API keys and adjust a few fields in n8n.
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 Tavily and OpenRouter usage, which is usually a few cents per lead depending on how much research you pull.
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 you should. The main change is in the “Compose Outreach Email” LLM chain where the prompt references YOUR_COMPANY_NAME and the style rules. Many teams also adjust what the “Research Company Profile” agent looks for (for example, hiring signals, tech stack, or recent funding) and add extra Google Sheets columns so the draft includes a specific CTA or pain point.
Most of the time it’s permissions or a mismatched document ID/sheet name. Reconnect the Google Sheets credential in n8n and confirm the account can edit the file, not just view it. Also check that you didn’t rename the tab after setting up the node, because that breaks lookups. If it still fails, run one test execution and inspect the execution log to see which node returns the error text.
It can handle hundreds of leads per run as long as you keep batch sizes reasonable and respect Tavily/OpenRouter rate limits.
Often, yes, because this flow relies on multi-step AI research plus structured parsing, which gets awkward (and pricey) in simpler automation tools. n8n also makes it easier to loop through many sheet rows without creating separate “tasks” for every micro-step. Another practical advantage is debuggability: you can open the execution log and see exactly where a lead failed, then rerun just that batch. The tradeoff is setup: Zapier is faster for a two-action zap, while this workflow is a small system. If you’re torn, Talk to an automation expert and get a straight answer for your volume and stack.
Once this is running, your spreadsheet stops being a to-do list and starts acting like a real outreach pipeline. Honestly, getting drafts created and logged automatically is the difference between “we should do outbound” and actually doing it.
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.
