Templates / AI Lead Scoring with GPT to Google Sheets

AI Lead Scoring with GPT to Google Sheets

Intermediate   Apps: Webhook, OpenAI, Google Sheets, Slack  ·  Setup: 15 minutes

When 40 leads a week come in, sales triages by gut and recency - and the enterprise prospect who wrote two thoughtful sentences at 2am waits behind 'pls send price'. This workflow has GPT-5.6 read each lead's company, role, and message against YOUR ideal customer profile, score it 1-10 with a reason, and route: 8+ pings Slack immediately, everything else just files into the sheet for batch follow-up.

Download workflow JSON (free) Setup guide

What this workflow does

  1. A Webhook node receives the lead (from your form, landing page, or another workflow).
  2. An OpenAI node scores the lead against your ideal customer profile - edit the profile text in the prompt to match your business.
  3. A Code node parses the score and reason from the AI reply.
  4. A Google Sheets node appends the scored lead.
  5. An IF node checks score >= 8 and posts hot leads to Slack with the reasoning.

Setup guide

  1. Import the JSON into n8n (Workflows > Import from File).
  2. Edit the OpenAI prompt: replace the example ideal-customer-profile paragraph with who YOU sell to.
  3. Add your OpenAI API key.
  4. Connect Google Sheets (columns: Timestamp, Name, Email, Company, Message, Score, Reason).
  5. Connect Slack for the hot-lead channel.
  6. Point your form's POST at the webhook URL (fields: name, email, company, message) and send a test lead.

Want this running 24/7?

Self-host n8n on a cheap VPS and this workflow runs around the clock for less than a coffee a month.

Get an n8n VPS from $5/month

FAQ

How accurate is AI scoring?It's a triage layer, not an oracle - it reliably separates 'enterprise buyer describing a real problem' from 'student asking for free access', which is 80% of the value. Tune the profile prompt after your first 50 leads.
What does it cost per lead?A score with gpt-5.6-luna costs a fraction of a cent; with gpt-5.6-terra about a cent. Even at heavy volume it's coffee money.
Can it enrich the lead with company data first?Yes - insert an HTTP Request node before the AI step calling an enrichment API (Clearbit, Apollo), and include the result in the prompt for sharper scores.

Want the workflows this one is a warm-up for?

The Mega Bundle packs both WorkflowForge Pro volumes — 32 production-grade workflows: automations (cart recovery, lead scoring, invoice extraction) and AI agents (support agent, calendar assistant, research agent), each with a setup guide. $39 for both, instant download.

Get the Mega Bundle →

Need it customized for your exact process?

I build custom n8n automations and AI agents professionally: your tools, your edge cases, tested and documented.

Hire me on Fiverr →