Scrape Apollo leads with BrowserAct, draft Gemini emails, and save to Sheets

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 1. BrowserAct Configuration Double-click the "Run a workflow" node and paste your specific BrowserAct Workflow ID. 2. Google Sheets Setup Create a new Google Sheet. Crucial: Add these headers in the first row: id, name, email, jobtitle, profileurl, company, location, emaildraft. Update the "Save to Google Sheets" node to select this file. 3. Credentials BrowserAct Account Google Gemini (PaLM) API (for AI generation) Google Sheets (Service Account or OAuth2) Gmail (OAuth2 - for notifications)