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 Loc

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)
Download the workflow JSON file after purchase.
Open n8n → click the menu → Import from File.
Select the downloaded JSON and import.
Set up credentials for each node that requires them.
Click Execute Workflow to test, then activate.
Setup guide included
Purchase to unlock the full step-by-step guide
No reviews yet
Be the first to buy and share your experience.
Leave a review
Sign in to share your experience with this workflow.
Create a free account to purchase workflows.
Need help setting this up?
Book a 3-hour live setup session with an Agility consultant.