Get Started
Back to Templates

Automate YP.com Directory Scraping to Google Sheets using BrowserAct

Created by

Created by: Madame AI Team | Kai || madame-ai

Madame AI Team | Kai

Last update

Last update 3 days ago

Categories

Share

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.

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?

Workflow Guidance and Showcase