🎣 Scrape Apollo leads with BrowserAct, draft Gemini emails, and save to Sheets
⚡ 90 views · 🎣 Lead Generation & Enrichment
💡 Pro Tip — HTTP Request scraping tends to break when sites update their markup. If you’re scraping a major platform, check if ScraperNode covers it — it has maintained scrapers for LinkedIn, Instagram, TikTok, YouTube, and 20+ other platforms that return structured data.
Description
This workflow creates a fully automated B2B lead generation & outreach pipeline. It combines BrowserAct (for scraping) with Google Gemini AI (for writing) to automate the entire prospecting process.
It takes a search request via a Form, scrapes verified leads from Apollo.io, uses AI to write a personalized cold email for EACH lead, saves everything to Google Sheets, and notifies you via Gmail when the batch is done.
How it works
- Form Trigger: You input the Target Role (e.g., “Engineer”) and Location (e.g., “New York”).
- BrowserAct Automation: Triggers a remote browser to search Apollo.io and extract contact details (Name, Job, Company, Email).
- AI Email Drafter: Google Gemini reads the lead’s info and automatically generates a personalized cold email draft tailored to their role and company.
- Data Merging: Seamlessly combines the scraped contact info with the AI-generated email content.
- Google Sheets Storage: Appends the full profile + the AI email draft into your spreadsheet.
- Email Notification: Sends you a summary report via Gmail listing who was scraped and confirming the job is finished.
Set up steps
- BrowserAct Configuration
- Double-click the “Run a workflow” node and paste your specific BrowserAct Workflow ID.
- Google Sheets Setup
- Create a new Google Sheet.
- Crucial: Add these headers in the first row:
id,name,email,job_title,profile_url,company,location,email_draft. - Update the “Save to Google Sheets” node to select this file.
- Credentials
- BrowserAct Account
- Google Gemini (PaLM) API (for AI generation)
- Google Sheets (Service Account or OAuth2)
- Gmail (OAuth2 - for notifications)
🔗 Nodes Used
Google Sheets, Gmail, Basic LLM Chain, n8n Form Trigger, Google Gemini Chat Model
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File