Extract Business Emails from Google Sheets via Serper & ScrapingBee

This n8n workflow automates the discovery and extraction of business email addresses from leads in a Google Sheet. It triggers on new or activated rows containing business type, city, and state. Using Serper.dev, it performs targeted Google searches for company websites. It then generates potential contact page URLs (e.g., /contact, /about), validates them, and scrapes content with ScrapingBee to identify email addresses. Finally, it updates the sheet with company details, URLs, extracted emails, and status markers like 'Running', 'Missing information', or 'Finished'.

Prerequisites include a Google Sheet with specific columns, Google Sheets API credentials, Serper.dev API key (free tier available), and ScrapingBee API key. The workflow supports dynamic inputs like country, language, and result count from sheet columns for per-row customization. Setup involves connecting credentials and minor tweaks to search filters or blacklists.

Benefits include massive time savings on manual lead research, higher accuracy through API-powered search and scraping, and scalability for thousands of leads. Use cases span e-commerce customer service (finding vendor contacts), sales prospecting, marketing campaigns, and business intelligence in competitive analysis. It reduces outreach bounce rates by delivering verified business emails directly into your CRM workflow.

Customization options allow adding sheet-based parameters for fully automated, row-specific searches. Integrate with CRMs like HubSpot or email tools for end-to-end lead nurturing, making it a powerhouse for revenue teams.