Automated Yellow Pages Lead Generation with BrowserAct
Automated Yellow Pages Lead Generation with BrowserAct
Get this template
Apps used in template
About
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 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.
Trusted by thousands of fast-scaling organizations around the globe
Similar templates for inspiration
Looking to get more out of your apps? With Make, you can visually integrate any app into any workflow to save time and resources - no coding required. Try any of these templates in just a few clicks.
Create your own workflow
Create custom workflows by choosing triggers, actions, and searches. A trigger is an event that launches the workflow, an action is the event.
Creates a new conditional format rule at the given index. All subsequent rules' indexes are incremented.
Appends a new row to the bottom of the table.
Adds a new sheet.
Adds files to a specified vector store or, if not specified, creates a new vector store based on the configuration.
Analyzes images according to specified instructions.
Appends multiple rows to the bottom of the table.
Updates multiple rows.
Cancels an "in-progress" batch. The batch will be in status "cancelling" for up to 10 minutes, before changing to "cancelled", where it will have partial results (if any) available in the output file.
Clears a specified range of values from a spreadsheet.
FAQ
How it works
Traditional no-code iPaaS platforms are linear and non-intuitive. Make allows you to visually create, build, and automate without limits.
Trusted by 350,000+ customers
"Make really helped us to scale our operations, take the friction out of our processes, reduce costs, and relieved our support team. It is difficult to not become a fan."
Head of Operations at Teleclinic
"Make drives unprecedented efficiency within our business in ways we never imagined. It’s having an extra employee (or 10) for a fraction of the cost."
COO at Shop Accelerator Martech
"The simplicity, flexibility and ability to build real complex automations without any knowledge of programming makes it the best thing since sliced bread."
Product Owner at Smaily
"True citizen development in the entire company. Make is present in every department, empowering the company to offer a unique customer experience."
CTO & Co-founder at FINN
"I can't count the number of hours I've saved by using Make. Every single day is simpler because of Make's automation."
Owner of Media Production