Send and track GPT-4 outreach emails with Gmail 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 22 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets, Gmail and OpenAI Chat Model.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Retrieve Lead Records from Google Sheets (Google Sheets): uses Google Sheets
- Validate Lead Data Payload (If): checks a condition and branches into true / false
- Filter for Booked Leads (If): checks a condition and branches into true / false
- Log Invalid Leads to Google Sheets (Google Sheets): append
- AI Agent: runs an AI agent, with model: OpenAI Chat Model
- Parse AI Email Output (JavaScript) (Code): runs custom JavaScript code
- Send Initial Outreach Email via Gmail (Gmail): uses Gmail
- Wait: waits 30 seconds
- Fetch Sent Email Thread from Gmail (Gmail): get (thread)
- Check for Client Reply (If Condition) (If): checks a condition and branches into true / false
…plus 10 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 (9)
- Manual Trigger
n8n-nodes-base.manualTrigger - Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if - Code
n8n-nodes-base.code - Gmail
n8n-nodes-base.gmail - Wait
n8n-nodes-base.wait - Edit Fields (Set)
n8n-nodes-base.set - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - AI Agent
@n8n/n8n-nodes-langchain.agent
From the author
Quick overview This workflow pulls lead records from Google Sheets, uses OpenAI to generate personalized HTML outreach emails, sends them through Gmail, waits and checks the Gmail thread for replies, and then updates lead status and reply details back in…