Run a full lead-to-meeting pipeline with Google Sheets, Gmail, Gemini and OpenAI
Email & inbox workflow for n8n with 52 active steps. Starts with Webhook, Schedule Trigger. Uses Google Gemini, OpenAI. Integrations include Google Gemini, Google Sheets, Gmail, OpenAI, Slack.
What it does
52 active nodes · Starts with Webhook, Schedule Trigger.
Steps in the template include:
- New Lead Webhook (Webhook)
- Normalize Lead Data (Edit Fields (Set))
- Enrich Lead (Clearbit/Apollo) (HTTP Request)
- Merge Enrichment Into Lead (Edit Fields (Set))
Nodes and integrations
- Webhook ×3
- Edit Fields (Set) ×2
- HTTP Request ×2
- Google Gemini ×3
- Code ×5
- Google Sheets ×16
- Gmail ×6
- Switch ×2
- OpenAI ×5
- Schedule Trigger ×3
- Filter ×2
- Wait
- Slack ×2
See the author’s step names
- New Lead Webhook (Webhook)
- Normalize Lead Data (Edit Fields (Set))
- Enrich Lead (Clearbit/Apollo) (HTTP Request)
- Merge Enrichment Into Lead (Edit Fields (Set))
- AI: Qualify & Score Lead (Google Gemini)
- Parse Lead Score (Code)
- Log Lead to CRM Sheet (Google Sheets)
- AI: Write Personalized Outreach (Google Gemini)
- Parse Outreach Message (Code)
- Send Outreach Email (Gmail)
- Send Outreach SMS (Twilio) (HTTP Request)
- Log Outreach Sent (Google Sheets)
- AI: Write Polite Decline (Google Gemini)
- Send Decline Email (Gmail)
- Log Declined Lead (Google Sheets)
- Route by Tier (Switch)
- Update row in sheet (Decline) (Google Sheets)
- Inbound Reply Webhook (Webhook)
- Lookup Lead by Contact (Google Sheets)
- Parse Reply Intent (Code)
- Route by Intent (Switch)
- Send Booking Link Email (Gmail)
- Mark Status: Booking Sent (Google Sheets)
- Send Objection Response (Gmail)
- Mark Status: Closed Lost (Google Sheets)
- AI: Classify Reply Intent (OpenAI)
- AI: Draft Objection Response (OpenAI)
- Update row in sheet (Objection) (Google Sheets)
- Follow-Up Check (Every 6h) (Schedule Trigger)
- Read Leads Awaiting Reply (Google Sheets)
- Filter: No Reply, Under 3 Follow-Ups (Filter)
- Parse Follow-Up (Code)
- Send Follow-Up Email (Gmail)
- Increment Follow-Up Count (Google Sheets)
- Message a model (OpenAI)
- Meeting Booked Webhook (Webhook)
- Mark Status: Meeting Booked (Google Sheets)
- Get Full Lead History (Google Sheets)
- Wait Until 30 Min Before Meeting (Wait)
- Send Brief to Salesperson (Slack)
- AI: Generate Pre-Call Brief (OpenAI)
- Weekly Report Trigger (Schedule Trigger)
- Read All CRM Rows (Google Sheets)
- Aggregate Conversion Metrics (Code)
- Write Weekly Report (Google Sheets)
- Send Weekly Summary to Slack (Slack)
- No-Show Check (Hourly) (Schedule Trigger)
- Read Today's Meetings (Google Sheets)
- Filter: Meeting Time Passed (Filter)
- Mark Status: No-Show (Google Sheets)
- Send Re-Engagement Email (Gmail)
- AI: Write Re-Engagement Message (OpenAI)
Accounts and credentials
- Google Gemini access
- Google Sheets
- Gmail
- OpenAI access
- Slack
Check the HTTP request steps for any additional service accounts or API keys.
AI models and swaps
Google Gemini · Model or API operation
Model ID not specified in the template in AI: Qualify & Score Lead. Provider-specific step. A different provider requires edits and testing.
Google Gemini · Model or API operation
Model ID not specified in the template in AI: Write Personalized Outreach. Provider-specific step. A different provider requires edits and testing.
Google Gemini · Model or API operation
Model ID not specified in the template in AI: Write Polite Decline. Provider-specific step. A different provider requires edits and testing.
OpenAI · Model or API operation
Model ID not specified in the template in AI: Classify Reply Intent. Provider-specific step. A different provider requires edits and testing.
OpenAI · Model or API operation
Model ID not specified in the template in AI: Draft Objection Response. Provider-specific step. A different provider requires edits and testing.
OpenAI · Model or API operation
Model ID not specified in the template in Message a model. Provider-specific step. A different provider requires edits and testing.
OpenAI · Model or API operation
Model ID not specified in the template in AI: Generate Pre-Call Brief. Provider-specific step. A different provider requires edits and testing.
OpenAI · Model or API operation
Model ID not specified in the template in AI: Write Re-Engagement Message. Provider-specific step. A different provider requires edits and testing.
Resource information
- Credit basis
- Author listed by n8n
- Pricing
- Paid template listed by n8n
- License
- Not specified
- Last record update
- Nov 5, 2026
