$5 · Support the community
Lead GenerationFREE

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
Lead GenerationFREE
Notionn8n
agent ready—

Log Every Facebook Lead Ads Lead to Notion Automatically

This n8n workflow watches Facebook Lead Ads for a new lead and automatically add it as a new page in a Notion database. Set it once and it runs 24/7.

n8nn8nNotionNotion
Beginner · 25 min setup
Lead GenerationFREE
Google Sheetsn8n
agent ready—

Automatically Send Every Facebook Lead Ads Lead to Google Sheets in Real Time

Connect Facebook Lead Ads and Google Sheets in n8n: each new lead is captured and sent straight to Google Sheets, in real time and completely hands-off.

n8nn8nGoogle SheetsGoogle Sheets
Beginner · 30 min setup
Lead GenerationFREE
Telegramn8n
agent ready—

Automatically Send Every Facebook Lead Ads Lead to Telegram in Real Time

Connect Facebook Lead Ads and Telegram in n8n: each new lead is captured and sent straight to Telegram, in real time and completely hands-off.

n8nn8nTelegramTelegram
Beginner · 30 min setup
Explore more like this
All Lead Generation recipes →n8n Google Sheets automationsn8n Slack automations
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.