Automate Yellow Pages to Google Sheets with n8n Workflow

Transform your lead generation process by automatically extracting Yellow Pages business data directly into Google Sheets with this powerful n8n workflow. No more manual copying and pasting—just set it up once and watch your prospect database grow effortlessly.

What this workflow does

This automation streamlines the entire Yellow Pages data extraction process through a series of intelligent steps. First, it initiates a scraping job using the AutoScrape Apify actor to pull local business leads from Yellow Pages based on your search criteria. The workflow then monitors the scraping process, automatically waiting for the data extraction to complete. Once finished, it retrieves the collected dataset items containing business information like company names, addresses, phone numbers, and other contact details. Finally, it seamlessly appends all the extracted data as new rows to your designated Google Sheets spreadsheet, creating an instantly accessible lead database.

Use cases

• Build targeted prospect lists for sales teams by extracting businesses in specific industries or locations
• Create comprehensive local business directories for market research and competitive analysis
• Generate leads for B2B marketing campaigns by automatically collecting contact information
• Maintain updated databases of potential partners, suppliers, or clients in your target market
• Streamline lead qualification processes by organizing Yellow Pages data in structured spreadsheets

Technical details

This n8n workflow leverages several key integrations to deliver seamless automation:

• Manual Trigger: Allows you to start the workflow on-demand when you need fresh leads
• HTTP Request: Communicates with the Apify API to manage scraping operations
• Google Sheets: Automatically appends extracted business data to your spreadsheet
• AutoScrape Apify Actor: Performs the actual Yellow Pages data extraction

Setup requires only an Apify API token for accessing the scraping service and Google Sheets credentials for data storage. Once configured, this workflow transforms hours of manual research into an automated process that runs in minutes, making it essential for any business focused on efficient lead generation and data collection.