Nurture leads from Google Sheets with Gmail, SMS, and OpenRouter AI
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 40 nodes and runs on a schedule (every hour). Along the way it connects Gmail, OpenRouter Chat Model, seven and Google Sheets.
How it runs
Trigger: On a schedule (every hour).
- Adjusting Hours (Filter): keeps only the items that match a condition
- 🔧 CONFIG: Paste Sheet Info Here (Edit Fields (Set)): sets 4 fields: TEMPLATE_google_sheet_url_or_id, TEMPLATE_sheet_name, timestamp…
- Read All Leads from Sheets (Google Sheets): uses Google Sheets
- Normalize Dates & Cast Types (Code): runs custom JavaScript code
- Filter: keeps only the items that match a condition
- Batch Leads — 10 at a Time (Loop Over Items (Split in Batches)): loops over the items in batches
- Route by Stage (Switch): routes items into 3 branches
- LLM — Generate Stage 1 Email (Basic LLM Chain): sends a prompt to an LLM, with model: OpenRouter Chat Model
- Merge: merges the data from its input branches
- LLM — Generate Stage 2 Email (Basic LLM Chain): sends a prompt to an LLM, with model: OpenRouter Model — Stage
…plus 25 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 (14)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Code
n8n-nodes-base.code - Filter
n8n-nodes-base.filter - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Switch
n8n-nodes-base.switch - No Operation, do nothing
n8n-nodes-base.noOp - Gmail
n8n-nodes-base.gmail - If
n8n-nodes-base.if - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - OpenRouter Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenRouter - seven
n8n-nodes-base.sms77 - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets - Merge
n8n-nodes-base.merge
From the author
Quick overview Automatically nurture leads with AI-personalized email follow-ups (plus optional SMS) across 3 stages triggered hourly, respecting business hours, and fully tracked in Google Sheets. How it works 1. Runs every hour, filtered to a business-hours…