Quick overview
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 Runs every hour, filtered to a business-hours window (default 9am–6pm, timezone configurable). Reads all leads from Google Sheets and filters those due for follow-up skipping replies, unsubscribes, and completed leads. Routes by stage Stage 1 (Welcome), Stage 2 (Check-in), or Stage 3 (Final nudge). AI writes the email an LLM (via OpenRouter) generates a personalized subject + body using the lead's name, source, and service of interest. Sends via Gmail, and optionally an SMS via Seven/Twilio (Day 1 and Day 4, with consent and dedupe checks). Updates Google Sheets advances the lead's stage, sets the next follow-up timestamp, and marks SMS sent. Setup Import all 4 workflows they share one Google Sheet. Paste your Sheet ID/tab name into each 🔧 CONFIG node (same Sheet ID throughout). Connect Google Sheets, Gmail, and OpenRouter credentials. Edit the 3 LLM prompt nodes to replace "YOUR NAME/company" with your actual brand name. (Optional) Connect Seven/Twilio for SMS, and adjust the business-hours filter to your timezone. Requirements Google Sheets (OAuth2) Gmail (OAuth2) OpenRouter API key (free-tier models supported) Seven or Twilio API key optional, for SMS Customization Swap Gmail/SMS for any other email or SMS provider with a native n8n node. Adjust delivery hours or timezone in the "Adjusting Hours" filter. Edit LLM prompts to change tone, length, or add new personalization fields. Part of a 4-workflow system: Lead Intake → Nurture Scheduler (this one) → Reply Listener → Daily Report. Additional info This is Workflow 1 of 4 in a complete AI lead nurturing system built for freelancers, agency owners, and solo founders: Workflow 1 — Lead Intake : Captures, validates, deduplicates, and stores leads Workflow 2 — Nurture Scheduler (this template): Sends AI-written email and SMS follow-ups across 3 stages Workflow 3 — Reply Listener: Classifies lead replies with an LLM and escalates hot leads in real time Workflow 4 — Daily Report: Emails you a morning summary of pipeline activity and follow-up counts. An n8n automation workflow template by Syed Jawad.
Syed Jawad
web
free
Others in the same category, ranked by how often they are opened.
