Templates / Route and qualify email leads with Gmail, Gemini, Slack, Sheets and Salesforce

Route and qualify email leads with Gmail, Gemini, Slack, Sheets and Salesforce

Ready for 3.0

by Milo Bravo ✓ · 225 views · created 2026-02-26 · Lead Generation, AI Summarization

Ready 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.

Worth a look

Nodes used (15)

Sentiment AnalysisGmailEvaluationGoogle Gemini Chat ModelSlackInformation ExtractorGoogle SheetsSalesforce

What it does

Email Lead Router: Gmail → Gemini → Salesforce Pipeline Who is this for? Event sales teams & conference organizers processing 100+ sponsor/partner emails weekly who need instant lead qualification, Salesforce automation, & pipeline analytics. What problem is this workflow solving? Event email chaos kills revenue: - 200+ sponsor emails/week → manual Salesforce entry - No sentiment/intent scoring = missed $ opps - 10+ hours/week routing + logging - Fragmented pipeline visibility Zero-drop AI qualification → auto-Salesforce → team routing. What this workflow does 1. Gmail Trigger captures event inbox emails 2. Gemini 1 scores sentiment (Positive/Neutral/Negative + confidence) 3. Gemini 2 extracts topic, intent, urgency (1-10), org, budget signals 4. Upserts Salesforce Lead (deduped by email) w/ 9 custom fields: Sentimentc, UrgencyScorec, etc. 5. Hot leads (Positive + urgency ≥7) → auto Salesforce Opportunity 6. Creates Salesforce Task w/ AI-suggested follow-up action 7. Logs to emailanalytics Data Table + Google Sheets (Looker Studio dashboard) 8. Routes: Positive → Hot email + Slack hot-leads (2h); Neutral → Follow-up + follow-ups (24h); Negative → Insights + insights Setup (8 minutes): - Gmail OAuth2 (event inbox) - Google Gemini API - Salesforce OAuth2 + 9 custom Lead fields (Sentimentc, UrgencyScorec, etc.) - Slack OAuth2 + channels (hot-leads, follow-ups, insights) - emailanalytics Data Table ID - Update Send Email recipients - Test w/ Evaluation Dataset How to customize: - Tune urgency threshold (7→8) - Add event keywords (webinar/tradeshow) - Swap Slack → Teams; Salesforce → HubSpot - Multi-inbox territory routing ROI: - 100% Salesforce coverage (no manual entry) - 8x faster qualification (2min vs 16h/week) - 30% opp velocity (auto opps/tasks) - Live Looker dashboard → data-driven decisions --- Need help customizing?: Contact me for consulting and support: LinkedIn / Message Keywords: event sales leads, Salesforce automation, Gemini lead scoring, email sentiment, sales pipeline n8n, AI sales routing

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.