Classify and route form leads with DeepSeek, Gmail, and Google Sheets

by Shuo Yuan ✓ · 0 views · created 2026-10-01 · Lead Generation, AI Summarization

What this workflow does

This workflow has 15 nodes and runs when an HTTP POST request hits its webhook URL (plus 1 other trigger). Along the way it connects Gmail and Google Sheets. It also calls api.deepseek.com over HTTP.

How it runs

Trigger: When an HTTP POST request hits its webhook URL (plus 1 other trigger).

1. Normalize Lead Data (Code): runs custom JavaScript code
2. Validate Approval Decision (If): checks a condition and branches into true / false
3. Check Lead Not Processed (Data table): row not exists
4. Append Lead to Fulfillment Sheet (Google Sheets): append
5. Mark Lead Processed (Data table): create or update (row)
6. Display Approval Confirmation (Respond to Webhook): sends the response back to the webhook caller
7. Classify and Score Lead (HTTP Request): calls api.deepseek.com (POST)
8. Extract LLM Response Data (Code): runs custom JavaScript code
9. Notify LLM Classification Failed (Gmail): uses Gmail
10. Route by Lead Priority (Switch): routes items into 2 branches

…plus 3 more steps. See the full node list below.

Services it uses

GmailGoogle Sheets

HTTP calls to: api.deepseek.com

Before you upgrade to n8n 3.0

Nodes used (9)

• Webhookn8n-nodes-base.webhook
• Coden8n-nodes-base.code
• Data tablen8n-nodes-base.dataTable
• HTTP Requestn8n-nodes-base.httpRequest
• Switchn8n-nodes-base.switch
• Gmailn8n-nodes-base.gmail
• Ifn8n-nodes-base.if
• Google Sheetsn8n-nodes-base.googleSheets
• Respond to Webhookn8n-nodes-base.respondToWebhook

From the author

Quick overview A webhook captures form leads, a Data Table blocks duplicates, and DeepSeek scores each lead from 1 to 100. A three-way switch routes high scores to an approval email, mid scores to a fast-track approval, and low scores to a polite decline. How…

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