AutomationMart
Home/Browse/Scrape Apollo leads with BrowserAct, draft Gemini emails, and save to Sheets
n8n

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

n8nn8n9 modulesv1.0
GmailGoogle SheetsGemini

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
Scrape Apollo leads with BrowserAct, draft Gemini emails, and save to Sheets workflow diagram

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)

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 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

Every time a new row is added to your Google Sheets spreadsheet, Make will automatically create a new opportunity in Salesflare. If the account name for which the opportunity should be created does not yet exist in Salesflare, Make will create it. The template uses this [example spreadsheet](http://bit.ly/2WUe1F9).

Free

Send Gmail emails for new fulfilled Printful orders

Make will watch for new fulfilled orders in Printful and send an email via Gmail to a customer.

Free

Auto-create and publish AI social videos with Telegram, GPT-4 and Blotato

Auto-create and publish AI social videos with Telegram, GPT-4 and Blotato > ⚠️ Disclaimer: This workflow uses Community Nodes and must be run on a self-hosted instance of n8n. Who is this for? This template is perfect for social media managers, content creators, AI enthusiasts, and automation pros who want to generate short-form videos (Reels) from a simple Telegram message, then publis

Free

Generate verified local leads from Google Maps with Apify and Google Sheets

Quick Overview This workflow uses Apify to scrape Google Maps business leads, verify their emails with a live SMTP check, and append only safe-to-send contacts to a Google Sheets spreadsheet. How it works 1. Starts when you manually run the workflow. 2. Calls the Apify Google Maps Lead Finder actor to search Google Maps for the configured queries and enrich results with email addresses. 3. Filters the results to keep only leads that include a non-empty primary email address. 4. Sends each primar

Free

Create G-Suite users from Gravity Forms entries

Every time a new entry is submitted to Gravity, Make will automatically create a user in G-Suit. Then, the credentials are sent to the new user via gmail.

Free

Add new TSheets timesheets to Google Sheets

Every time a new Timesheet is posted to a specified TSheets account, Make will automatically add that timesheet to Google Sheets. The template uses this [example spreadsheet](https://docs.google.com/spreadsheets/d/1GTHFXIZTYjC7hdnbwsQFL83dq2AJzwxLRm26pF24hY0/edit?usp=sharing).

Free

XOR encryption and decryption with Base64 encoding for workflow data

This workflow performs basic XOR-based encryption and decryption using a custom password. It is intended to be triggered by another workflow and processes structured input in JSON format. Input Structure The workflow expects a single array of objects with the following fields: - action-type: either "encrypt" or "decrypt" - key: the password used for encryption and decryption - data: the content to encrypt or decrypt Example: Encryption Input Example: Decryption Input Output The output returns an

Free

Create stunning AI images directly from WhatsApp with Gemini

Create Stunning AI Images Directly from WhatsApp with Gemini This workflow transforms your WhatsApp into a personal AI image generation studio. Simply send a text message with your idea, and this bot will use the advanced prompt engineering capabilities of Gemini 2.5 Pro to craft a detailed, artistic prompt. It then uses Gemini 2.0 Flash to generate a high-quality image from that prompt and sends it right back to your chat. It's a powerful yet simple way to bring your creative ideas to l

Free

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.

Log in to review
Free
No ratings yet

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.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free