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 Loc
At a glance
Scrape Apollo leads with BrowserAct, draft Gemini emails, and save to Sheets is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Gmail, Google Sheets, Gemini. It's free to download. Follow the 5-step import below to go live in minutes.
- Platform
- n8n
- Connects
- Gmail, Google Sheets, Gemini
- Modules
- 9
- Price
- Free
- Version
- v1.0

About this workflow
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)
How to import this n8n workflow
- 1
Download the workflow JSON file after purchase.
- 2
Open n8n → click the menu → Import from File.
- 3
Select the downloaded JSON and import.
- 4
Set up credentials for each node that requires them.
- 5
Click Execute Workflow to test, then activate.
Setup guide
Setup guide included
Purchase to unlock the full step-by-step guide
Related N8n workflows
Add Salesflare opportunities from new Google Sheets rows
Send Gmail emails for new fulfilled Printful orders
Auto-create and publish AI social videos with Telegram, GPT-4 and Blotato
Generate verified local leads from Google Maps with Apify and Google Sheets
Create G-Suite users from Gravity Forms entries
Add new TSheets timesheets to Google Sheets
XOR encryption and decryption with Base64 encoding for workflow data
Create stunning AI images directly from WhatsApp with Gemini
Reviews
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.
- JSON blueprint — instant download
- Setup guide PDF included
- 5 downloads · valid 30 days
- Works with n8n
Need help setting this up?
Book a 3-hour live setup session with an Agility consultant.
- Configure live on Google Meet / Zoom
- Free follow-up if workflow has defects
- Platform expert assigned to you