🎣 Automate YP.com directory scraping to Google Sheets using BrowserAct

⚡ 45 views · 🎣 Lead Generation & Enrichment

💡 Pro Tip — HTTP Request scraping tends to break when sites update their markup. If you’re scraping a major platform, check if ScraperNode covers it — it has maintained scrapers for LinkedIn, Instagram, TikTok, YouTube, and 20+ other platforms that return structured data.

Description

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

🔗 Nodes Used

Google Sheets

📥 Import

Download workflow.json and import into n8n: Workflow menu → Import from File

📖 Importing guide · 🔑 Credential setup