Lead Generation · n8n

Score New Leads From Google Sheets and Route Hot Ones to Slack

Automatically score each new lead row using your own rules, then instantly notify sales in Slack when a high-value lead comes in.

difficulty Intermediatesetup 40 minresult Sales gets pinged only for leads that clear your score threshold, so reps focus on the prospects most likely to convert.—
—
  1. 1

    Watch for New Rows

    Add a Google Sheets Trigger node set to fire on newly added rows in your leads sheet.

  2. 2

    Compute a Lead Score

    Add a Code node that assigns points based on fields — company size, budget, job title, source — and outputs a total score. Keep the rules easy to tweak.

  3. 3

    Write the Score Back

    Add a Google Sheets node with operation Update to save the score into the lead's row for later sorting and reporting.

  4. 4

    Route Hot Leads

    Add an IF node checking score is greater than your threshold (e.g. 70). Only high-scoring leads continue.

  5. 5

    Notify Sales in Slack

    Add a Slack node that posts the lead's name, company and score to your sales channel, tagging the on-duty rep. Activate and test with a sample high-score lead.

Frequently asked questions

Can I round-robin leads to different reps?

Yes. Store rep handles in a list and use a Code node to rotate through them, tagging a different rep on each hot lead.

What about enriching the lead first?

Add a Clearbit or Apollo HTTP step before scoring to pull company data, giving your scoring rules more signals to work with.

Related recipes
Free recipe
Zapiern8nMailchimp
Zapiern8nMailchimp
—

Add Facebook Lead Ads Subscribers to Mailchimp via Zapier

An n8n workflow that receives Facebook Lead Ad submissions relayed by Zapier, tags and de-duplicates them, and adds each person to a Mailchimp audience with the right merge fields — so paid Facebook leads flow straight into your email nurture without CSV exports.

Beginner · 35 min setup
Free recipe
WhatsAppn8nHubSpot
WhatsAppn8nHubSpot
—

Capture Inbound WhatsApp Enquiries as CRM Leads Automatically

An n8n workflow that turns every first-time WhatsApp message into a CRM lead — creating a contact with the phone number, the enquiry text and a source tag, then alerting sales — so businesses running WhatsApp click-to-chat ads never lose an interested customer to an unanswered thread.

Intermediate · 55 min setup
Free recipe
Gmailn8n
Gmailn8n
—

Capture Webflow Form Leads in Airtable With an Instant Autoresponder

Send every Webflow form submission straight into Airtable and fire off a branded autoresponder email so leads hear from you immediately.

Beginner · 25 min setup
About this recipe. Recipes on FlowRecipesHub are written for business owners, not developers, and are tested before publishing — how recipes get made. Some ingredient links are affiliate links that cost you nothing — full disclosure.