Write and send personalized cold email sequences with Gemini, Google Sheets and Gmail
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 34 nodes and runs manually, when you click “Execute workflow” (plus 2 other triggers). Along the way it connects Google Sheets, Google Docs, Google Gemini Chat Model and Gmail.
How it runs
Trigger: Manually, when you click “Execute workflow” (plus 2 other triggers).
- Outreach Settings (Edit Fields (Set)): sets 5 fields: sheet_url, offer_brief_url, send_mode…
- Which Start? (Switch): routes items into 4 branches
- Read CSV (Extract from File): extracts data from a file
- Read Excel (Extract from File): extracts data from a file (xlsx)
- Form Lead (Edit Fields (Set)): sets 5 fields: Email, First Name, Company…
- Read Leads (Google Sheets): uses Google Sheets
- Add To Sheet (Google Sheets): append
- Read Offer Brief (Google Docs): get
- Map Columns (Basic LLM Chain): sends a prompt to an LLM, with model: Columns Model; output parser: Columns Format
- Pick Leads (Code): runs custom JavaScript code
…plus 15 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (14)
- Manual Trigger
n8n-nodes-base.manualTrigger - n8n Form Trigger
n8n-nodes-base.formTrigger - Edit Fields (Set)
n8n-nodes-base.set - Switch
n8n-nodes-base.switch - Extract from File
n8n-nodes-base.extractFromFile - Google Sheets
n8n-nodes-base.googleSheets - Google Docs
n8n-nodes-base.googleDocs - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Code
n8n-nodes-base.code - HTTP Request
n8n-nodes-base.httpRequest - If
n8n-nodes-base.if - Gmail
n8n-nodes-base.gmail
From the author
Quick overview Turn any lead list into cold emails that sound written by hand. AI reads each lead's website, writes the email and a follow-up from your offer brief, and a quality check stops spammy copy. Leads, status and replies are tracked in Google Sheets,…