B2B lead follow-up automation with Gemini AI, Gmail and Google Sheets
Ready for 3.0What this workflow does
This AI workflow has 14 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Gmail, Google Sheets, Google Gemini Chat Model and HTTP Request.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Get many messages (Gmail): get many
- Get row(s) in sheet (Google Sheets): uses Google Sheets
- Wait: pauses before continuing
- Update row in sheet (Google Sheets): update
- If: checks a condition and branches into true / false
- AI Agent: runs an AI agent, with model: Google Gemini Chat Model; 1 tool (HTTP Request); output parser: Structured Output Parser
- Edit Fields (Edit Fields (Set)): sets 2 fields: ClientEmail, ClientEmailBody
- Get many messages (Gmail): get many
- Reply to a message (Gmail): reply (thread)
- Update row in sheet (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 (10)
- Manual Trigger
n8n-nodes-base.manualTrigger - Gmail
n8n-nodes-base.gmail - Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if - AI Agent
@n8n/n8n-nodes-langchain.agent - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Http Request Tool
n8n-nodes-base.httpRequestTool - Wait
n8n-nodes-base.wait - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Edit Fields (Set)
n8n-nodes-base.set
From the author
Overview This n8n workflow template automates your B2B marketing follow-up process. It tracks which introductory emails have received a reply, identifies leads who haven't responded within a set time, uses Gemini AI to draft a personalized, casual reminder,…