Automate YP.com Directory Scraping to Google Sheets using BrowserAct

Related Templates

Detail

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.