Automate cold outreach with email personalization using Gemini and Google Sheets
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 8 nodes and runs on a schedule (every 30 minutes). Along the way it connects Google Sheets and Google Gemini Chat Model.
How it runs
Trigger: On a schedule (every 30 minutes).
- Read Leads from Sheet (Google Sheets): uses Google Sheets
- If: checks a condition and branches into true / false
- Basic LLM Chain: sends a prompt to an LLM, with model: Google Gemini Chat Model; output parser: Structured Output Parser
- Prepare Data for Sheet (Edit Fields (Set)): sets or maps fields
- Update Sheet with Email (Google Sheets): update
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 (7)
- Google Sheets
n8n-nodes-base.googleSheets - Edit Fields (Set)
n8n-nodes-base.set - 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 - Schedule Trigger
n8n-nodes-base.scheduleTrigger - If
n8n-nodes-base.if
From the author
This n8n template from Intuz provides a complete and automated solution for powerful cold outreach campaigns. It connects a Google Sheet of prospect data with Google Gemini to automatically generate highly personalized emails. By analyzing specific keywords…