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

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