Route and qualify email leads with Gmail, Gemini, Slack, Sheets and Salesforce
Go to Workflow
Milo Bravo
Description
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
Gmail Trigger captures event inbox emails
Gemini #1 scores sentiment (Positive/Neutral/Negative + confidence)
Gemini #2 extracts topic, intent, urgency (1-10), org, budget signals
Upserts Salesforce Lead (deduped by email) w/ 9 custom fields: Sentiment__c, Urgency_Score__c, etc.
Hot leads (Positive + urgency ≥7) → auto Salesforce Opportunity
Creates Salesforce Task w/ AI-suggested follow-up action
Logs to email_analytics Data Table + Google Sheets (Looker Studio dashboard)
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** (Sentiment__c, Urgency_Score__c, etc.)
Slack OAuth2 + channels (#hot-leads, #follow-ups, #insights)
email_analytics 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
This workflow was created by Milo Bravo and shared publicly on the n8n community template library. n8nFind indexes it for discovery — the workflow remains the property of its original creator.