how to route and score Salesforce leads using Zapier + ChatGPT
We need a Zapier flow that enriches and scores new Salesforce leads with ChatGPT analyses and assigns them to SDRs. Looking for webhook setup, field mappings, and how to avoid double-processing duplicates.
Best tools for this use case
Based on the workflow in this discussion, these tools are useful starting points to review.
Zapier
Best general-purpose automation layer for connecting tools and processes quickly.
Make
Powerful automation builder for advanced visual flow design and multi-step operations.
n8n
Technical automation platform with strong flexibility, control and AI workflow potential.
Answers
Approved replies, operator insight, and tactical follow-up from the community.
Flow (concise): 1) Trigger: Salesforce New Lead. 2) Find Record by Email/Phone — if found and custom flag processed=true, STOP. 3) Use Formatter to assemble prompt with FirstName, LastName, Company, Email, Phone, LeadSource, Industry, Description. 4) Call ChatGPT (via Zapier Webhook/OpenAI) to return JSON {score,recommended_owner_email,reason}. 5) Update Lead: set lead_score__c, ownerId, notes, processed_at. 6) Create Task/notification for SDR. To avoid duplicates, use Storage by Zapier or set a short-lock key (leadId TTL) before calling the API.