🎣 Route and qualify email leads with Gmail, Gemini, Slack, Sheets and Salesforce
⚡ 197 views · 🎣 Lead Generation & Enrichment
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_analyticsData 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_analyticsData 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
🔗 Nodes Used
Google Sheets, Slack, Salesforce, Gmail, Gmail Trigger, Google Gemini Chat Model
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File