Automated BBB Lead Generation with BrowserAct π Overview This workflow automates business data extraction , duplicate checking , and email outreach using BrowserAct , Google Sheets , Gmail , and Google Gemini AI β all inside n8n . Itβs designed for marketers, lead generation specialists, or automation developers who want to build a fully autonomous AI agent that finds businesses online, filters duplicates, and automatically sends personalized outreach emails. π§© Key Features π BrowserAct Integration β Scrapes business data (name, phone, email, website, rating) from any target site. π€ AI Data Extraction Agent β Uses Google Gemini AI to clean, structure, and validate scraped data into standardized JSON. π Google Sheets Sync β Reads all existing records Checks for duplicates Appends new rows automatically βοΈ Automated Gmail Outreach β Validates email addresses Sends outreach emails to valid leads Logs each status (e.g., Successful , Duplicate , Pending - Invalid Email ) β³ Smart Delay Control β Uses Wait node to pause execution and respect email sending limits (max 2 emails per run). π οΈ Included Nodes Node Function π Schedule Trigger Runs the workflow automatically on schedule π BrowserAct Scrapes or extracts business data βοΈ If Node Checks scraping results before processing π§ AI Agent (Gemini) Extracts structured business info π» Code (JavaScript) Cleans and parses AI output into usable JSON π© AI Agent 2 (Gemini) Handles decision-making for email + sheet updates π Google Sheets Tools Reads, appends, and manages lead data π¨ Gmail Node Sends automated outreach emails β±οΈ Wait Node Adds delay to control workflow speed π§Ύ How It Works Schedule Trigger starts the automation. BrowserAct fetches business listings based on defined keywords and location. AI Agent (Gemini) extracts business details ( business_name , website_url , phone_number , email_address , rating ). JavaScript Code Node parses the AIβs JSON response. AI Agent 2 (Gemini) decides: If duplicate β send message on your email address Duplicate data found If invalid email β marks as βPending - Invalid Emailβ If valid email β sends via Gmail + updates Google Sheet Final output returns structured statuses for each processed business. πΌοΈ Workflow Diagram Schedule Trigger BrowserAct AI Agent (Gemini) JavaScript Code Gmail & Google Sheets tools ![Workflow Preview] βοΈ Setup Instructions Connect your BrowserAct , Google Sheets , Gmail , and Google Gemini API credentials. Define search keywords and locations inside the BrowserAct node. Set your Google Sheet ID in the relevant nodes. Customize the Gmail message if needed. Activate the workflow and schedule it. π€ Output Example [
{
"business_name": "ABC Restaurant",
"email_sent": "Successful"
},
{
"business_name": "XYZ Foods",
"email_sent": "Duplicate - Already Exist"
},
{
"business_name": "Fresh Eats",
"email_sent": "Pending - Invalid Email"
}
] π¨βπ» Created by Bakir Ali Automation & AI Workflow Creator β specialized in BrowserAct, Google AI (Gemini), and n8n-based automation systems.