Templates / Score and route leads with Google Gemini, Sheets, Slack and Gmail

Score and route leads with Google Gemini, Sheets, Slack and Gmail

Ready for 3.0

by Oka Hironobu ✓ · 11 views · created 2026-02-16 · CRM, 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.

What this workflow does

This AI workflow has 12 nodes and runs when someone submits an n8n form. Along the way it connects Google Gemini Chat Model, Google Sheets, Slack and Gmail.

How it runs

Trigger: When someone submits an n8n form.

  1. Process Lead Data (Code): runs custom JavaScript code
  2. Enrich Lead Data (HTTP Request): calls an HTTP API
  3. AI Lead Analyzer (Basic LLM Chain): sends a prompt to an LLM, with model: Google Gemini Chat Model
  4. Parse AI Scoring (Code): runs custom JavaScript code
  5. Lead Quality Router (If): checks a condition and branches into true / false
  6. Revenue Predictor (Basic LLM Chain): sends a prompt to an LLM, with model: Google Gemini Chat Model
  7. Sales Team Alert (Slack): uses Slack
  8. Update Revenue Dashboard (Google Sheets): uses Google Sheets
  9. Send Lead Report (Gmail): uses Gmail

Services it uses

Google Gemini Chat ModelGoogle SheetsSlackGmail

Before you upgrade to n8n 3.0

Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.

Nodes used (9)

From the author

💰 AI Revenue Intelligence: 360° Customer Journey with Sales Analytics Transform your sales pipeline with this comprehensive AI-powered platform that automates lead capture, scoring, revenue prediction, and sales team coordination. Perfect for B2B teams…

Excerpt from Oka Hironobu's description on n8n.io.

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.