Scrape Apollo leads with BrowserAct, draft Gemini emails, and save to Sheets
UnknownWhat this workflow does
This AI workflow has 9 nodes and runs when someone submits an n8n form (“Lead Gen Request”). Along the way it connects Google Sheets, Google Gemini Chat Model, Gmail and Browseract (community).
How it runs
Trigger: When someone submits an n8n form (“Lead Gen Request”).
- Scrape Apollo via BrowserAct (Browser Act): uses Browser Act
- Clean & Flatten JSON (Code): runs custom JavaScript code
- Basic LLM Chain: sends a prompt to an LLM, with model: Google Gemini Chat Model
- Merge: merges the data from its input branches
- Map Columns (Edit Fields (Set)): sets 7 fields: name, job_title, email…
- Save to Google Sheets (Google Sheets): append
- Send a message (Gmail): uses Gmail
Services it uses
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that n8n-nodes-browseract is verified or supports 3.0 (used in Scrape Apollo via BrowserAct).
Nodes used (9)
- n8n Form Trigger
n8n-nodes-base.formTrigger - Browser Act
n8n-nodes-browseract.browserAct - Code
n8n-nodes-base.code - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Gmail
n8n-nodes-base.gmail - Merge
n8n-nodes-base.merge
From the author
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…