Send personalized cold email sequences with Google Sheets, Gmail, Gemini and Slack
Ready for 3.0What this workflow does
This AI workflow has 36 nodes and runs on a schedule (every day at 09:00) (plus 2 other triggers). Along the way it connects Gmail, Google Sheets, Slack and Google Gemini Chat Model.
How it runs
Trigger: On a schedule (every day at 09:00) (plus 2 other triggers).
- Fetch All Leads (Google Sheets): uses Google Sheets
- Fetch Follow-up 1 Leads (Google Sheets): uses Google Sheets
- Fetch Follow-up 2 Leads (Google Sheets): uses Google Sheets
- Return Pixel Image (Respond to Webhook): sends the response back to the webhook caller
- Decode Tracking ID (Code): runs custom JavaScript code
- Extract Email Sender Info (Code): runs custom JavaScript code
- Filter Pending Only (Code): runs custom JavaScript code
- Filter FU1 Due (Code): runs custom JavaScript code
- Filter FU2 Due (Code): runs custom JavaScript code
- Valid Email? (If): checks a condition and branches into true / false
…plus 22 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.
- Still check Gmail Trigger below v1.4 runs as v1.4 (drafts skipped, max emails per poll) (When New Email Received).
Nodes used (11)
- Gmail Trigger
n8n-nodes-base.gmailTrigger - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if - Slack
n8n-nodes-base.slack - Webhook
n8n-nodes-base.webhook - Respond to Webhook
n8n-nodes-base.respondToWebhook - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Gmail
n8n-nodes-base.gmail - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm
From the author
Quick overview This workflow runs daily to send Gemini-generated cold emails from leads stored in Google Sheets via Gmail, schedules two follow-ups based on time since sending, and continuously monitors Gmail for replies to update the sheet and alert a Slack…