This template fully automates lead generation by scraping Yellow Pages, enriching the data, and scoring leads using AI. Important: Before starting, please read the [Data Store Setup Guide](https://docs.google.com/document/d/1T0kpEMUeEfwjxNtCFgmDmTkZW3bfr7kNUQHnJNFReNY/edit?usp=sharing) to create the required database. Prerequisites: You must create a Google Sheet with two tabs: "Input" Tab Columns: DirectoryURL, Data_Limit, Keyword, Location, Status, RowID. "Results" Tab Columns: Company Name
Automated Yellow Pages Lead Generation with BrowserAct is a ready-made Make.com workflow you import as a blueprint JSON file — no build required. It connects Slack, Airtable, Google Sheets, Salesforce. It's free to download. Follow the 5-step import below to go live in minutes.
This template fully automates lead generation by scraping Yellow Pages, enriching the data, and scoring leads using AI.
Important: Before starting, please read the [Data Store Setup Guide](https://docs.google.com/document/d/1T0kpEMUeEfwjxNtCFgmDmTkZW3bfr7kNUQHnJNFReNY/edit?usp=sharing) to create the required database.
Prerequisites:
You must create a Google Sheet with two tabs:
"Input" Tab Columns: DirectoryURL, Data_Limit, Keyword, Location, Status, RowID.
"Results" Tab Columns: Company Name, Website, Lead Score, Summary, Phone, LinkedIn, Address, Email.
How it works:
Trigger: Watches a Google Sheet for a Yellow Pages URL.
Scrape: BrowserAct scrapes the directory for businesses.
De-duplicate: Checks a Data Store to ensure the domain hasn't been processed before.
Enrich: BrowserAct scans the company website and extracts social links.
Analyze: OpenAI classifies the business, extracts contacts, and scores the lead.
Log: Saves the enriched data to a "Results" sheet.
Apps used: BrowserAct, OpenAI, Google Sheets, Data Store.
Customization: You can optionally add a Router after the AI module to send data to Salesforce, Slack, or Airtable.
Download the blueprint JSON file after purchase.
Open Make.com → go to Scenarios → click Import Blueprint.
Select the downloaded JSON file and confirm.
Connect your app credentials in each module.
Run once manually to test, then activate the schedule.
Setup guide included
Purchase to unlock the full step-by-step guide
Auto-Reply to New Shopify Orders via Gmail
Parse JSON from HTTP request ( Basic )
Watch Notion database items and update them based on search results
Summarize emails with Gmail and OpenAI then send it on Slack
Add new Google Calendar events to a Google Sheets spreadsheet as new rows and email it to a specified email address
Generate images with OpenAI and upload files to Google Drive
No reviews yet
Be the first to buy and share your experience.
Leave a review
Sign in to share your experience with this workflow.
Create a free account to purchase workflows.
Need help setting this up?
Book a 3-hour live setup session with an Agility consultant.