Automate YP.com Directory Scraping to Google Sheets using BrowserAct
Go to WorkflowDescription
Automate Directory Scraping to Google Sheets using BrowserAct
This n8n template helps you generate local business leads by automatically scraping online directories and saving the results directly to a spreadsheet.
This workflow is perfect for sales teams, marketing agencies, or anyone looking to build a list of local business leads by scraping online directories like YP.com.
Self-Hosted Only
This Workflow uses a community contribution and is designed and tested for self-hosted n8n instances only.
How it works
The workflow is triggered manually. You can set the business_category and city_location inputs in the "Run a workflow task" node.
A BrowserAct node initiates the web scraping task on your BrowserAct account using the template specified.
A second BrowserAct node ("Get details of a workflow task") patiently waits for the scraping job to finish before allowing the workflow to proceed.
A Code node takes the raw output from the scraper (which is a single JSON string) and correctly parses it, splitting the data into individual items for each business.
Finally, a Google Sheets node appends or updates each business as a new row in your spreadsheet, matching on "Company Name" to prevent duplicates.
Requirements
BrowserAct** API account for web scraping
BrowserAct* "Online Directory Lead Scraper (YP.com)*" Template
BrowserAct** n8n Community Node -> (n8n Nodes BrowserAct)
Google Sheets** credentials for saving the leads
Need Help?
How to Find Your BrowseAct API Key & Workflow ID
How to Connect n8n to Browseract
How to Use & Customize BrowserAct Templates
How to Use the BrowserAct N8N Community Node
Workflow Guidance and Showcase
STOP Manual Leads! Automate Lead Gen with BrowserAct & n8n