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 Sheets 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.