EnglishBy Jitendra Kavire ·16 Nov 2026 · 3 min read
n8n B2B Lead Scoring and Cold Email Workflow with Google Sheets, Apify and OpenAI
Automate B2B lead research and scoring with n8n, Google Sheets, Apify, and OpenAI. This guide explains how the Sales Lead Scraper workflow finds, scores, and saves high-quality leads for your cold email campaigns.
Ye guide Hinglish me padhein →
If you want to automate B2B lead scoring and cold email prep using Google Sheets, Apify, and OpenAI in n8n, the Sales Lead Scraper workflow covers the hardest part: finding, scoring, and saving quality leads from Google Maps. You send a request to your Telegram bot, and the workflow hands you a scored, deduped list in your Google Sheet, ready for your next cold email step.
What does this n8n B2B lead scoring workflow do?
You text your Telegram bot something like "find me 20 gyms in Pune." The workflow uses AI to understand your request, scrapes matching businesses from Google Maps with Apify, removes duplicates and leads without emails, then uses AI again to score each lead. Only the best leads are saved to your Google Sheet, ready for outreach.
This workflow solves the first and most time-consuming part of B2B lead generation: researching and qualifying leads before you email them. It does not send cold emails itself, you will need to add a cold email workflow after this one.
How does the n8n Sales Lead Scraper workflow work?

- You send a request to the Telegram bot: You send a message to your Telegram bot with your search request, such as the type of business and city. This starts the workflow.
- AI turns it into search details: AI reads your message and extracts the details needed for a Google Maps search, making it easy for anyone to use.
- Apify scrapes matching businesses from Google Maps: Apify uses those search details to scrape matching businesses from Google Maps, collecting key info like names and emails.
- Duplicates and leads without email are removed: The workflow removes any duplicate businesses and skips leads that do not have an email address, so your list is clean.
- AI scores each lead; good ones are saved: AI scores each lead based on your criteria, and only the best leads are saved to your Google Sheet for outreach.
The full setup (every node, every prompt, ready-to-import JSON, and setup videos) is in Sales Lead Scraper, n8n Sales Workflow (Step-by-Step + JSON).
What do I need to run this workflow?
You need:
- An n8n account (self-hosted or n8n Cloud)
- A Telegram bot, with your chat ID (so only you can send requests)
- An Apify account and API token (for the Google Maps scraper)
- An OpenAI or OpenRouter API key (gpt-4o-mini works for the AI steps)
- A Google Sheet (your CRM) and Google Sheets credential
Each of these is explained step-by-step in the n8n ebook chapter, including how to get API keys and connect accounts.
What is a common mistake or limitation?
This workflow only finds and scores leads. It does not send cold emails, you will need to add a separate cold email workflow after this one. Also, it only keeps leads with email addresses. If your search is too narrow or the businesses do not list emails, you may get few or no results. Make sure your Google Sheet has the correct "Email" column header, as this is used for deduplication.
Frequently asked questions
Does this n8n workflow send cold emails too?
No, it only finds, scores, and saves leads to your Google Sheet. You need to add a cold email workflow to send messages to these leads.
Can I run this on free n8n?
Yes. The workflow runs on both self-hosted (free Community edition) and n8n Cloud. You only pay for outside services like Apify and OpenAI, many of which have free tiers.
How long does setup take?
If you use the ready workflow JSON, setup takes about 2 hours. With Claude Code, it's usually 30–45 minutes. The ebook has a setup video for every API you need.
For every node, setting, and prompt, plus the ready-to-import JSON, see the full n8n Sales Growth Automations ebook. You can also try the free n8n starter workflow or browse all workflows.
Written by
Jitendra Kavire · Founder, n8nebooks
Jitendra builds n8n automations for real businesses — real estate, clinics, gyms, agencies and creators. He has written 13 n8n ebooks with 65 tested, ready-to-import workflows, and runs Revision Wave Production House in Pune, India.