Personalized cold email system with Google Gemini, Telegram approval & Google Sheets
Ready for 3.0What this workflow does
This AI workflow has 28 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Gemini Chat Model, Telegram and Google Sheets.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Date & Time: formats or calculates dates
- Get Lead from Google Sheet (Google Sheets): uses Google Sheets
- Limit: keeps the first few items
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Send a text message (Telegram): uses Telegram
- AI Agent: runs an AI agent, with model: Google Gemini Chat Model; output parser: Structured Output Parser
- Merge: merges the data from its input branches
- AI Agent: runs an AI agent, with model: Google Gemini Chat Model; 2 tools (Sent Leads Append, Filtered Leads Update); memory: Simple Memory
- Send message and wait for response (Telegram): send and wait for a reply
- AI Agent: runs an AI agent, with model: Google Gemini Chat Model; 1 tool (Add Email Draft to Google Sheet)
…plus 5 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 (15)
- Manual Trigger
n8n-nodes-base.manualTrigger - AI Agent
@n8n/n8n-nodes-langchain.agent - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Switch
n8n-nodes-base.switch - Wait
n8n-nodes-base.wait - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Telegram
n8n-nodes-base.telegram - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Simple Memory
@n8n/n8n-nodes-langchain.memoryBufferWindow - Google Sheets Tool
n8n-nodes-base.googleSheetsTool - Send Email
n8n-nodes-base.emailSend - Date & Time
n8n-nodes-base.dateTime - Merge
n8n-nodes-base.merge - Limit
n8n-nodes-base.limit - Google Sheets
n8n-nodes-base.googleSheets
From the author
Personalized Cold Email System with Google Gemini AI and Telegram Approval An AI-powered cold email automation that uses Google Gemini to generate personalized outreach and a Telegram workflow for manual approval, ensuring high-quality, human-in-the-loop…