Automated Yellow Pages Lead Generation with BrowserAct

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.

• Configure live on Google Meet / Zoom
• Free follow-up if workflow has defects
• Platform expert assigned to you