Extract Business Email Addresses Using Serper.dev and ScrapingBee from Google Sheets

Description

Lead Enrichment & Email Discovery from Google Sheets

What this workflow does
This template automates the enrichment of business leads from a Google Sheet by:
Triggering when a row is activated
Searching for company information with Serper.dev
Generating and validating potential contact pages
Scraping company pages with ScrapingBee
Extracting emails and updating the sheet
Marking rows as finished
Prerequisites
Google Sheet with columns: business type, city, state, activate
Copy the ready-to-use template:**
Sheet Template
Google Sheets API credentials (from Google Cloud)
Serper.dev API key (free tier available)
ScrapingBee API key (free tier available)
Inputs
Google Sheet row:**
Must include business type, city, state, activate
Set Information Node:**
country, country_code, language, result_count (can also be provided via columns in the sheet)
Outputs
Google Sheet update:**
Company names, URLs, found email addresses (comma-separated if multiple), and status updates (Running, Missing information, Finished)
Configuration Required
Connect Google Sheets node with your Google Cloud credentials
Add your Serper.dev API key to the HTTP Request node
Add your ScrapingBee API key to the scraping node
Adjust search and filtering options as needed
How to customize the workflow
Send country, country_code, and result_count from the sheet:**
Add these as columns in your sheet and update the workflow to read their values dynamically, making your search fully configurable per row.
Add more blacklist terms:**
Update the code node with additional company names or keywords you want to exclude from the search results.
Extract more contact details:**
Modify the email extraction code to find other contact info (like phone numbers or social profiles) if needed.