Scrape and email business leads with Claude, Apify, Google Sheets and Gmail

💥 Scrape leads from businesses with Claude and Apify to Gmail outreach

📄 Documentation: Notion Guide

Automatically scrape business leads with Claude Co-Work and Apify, send the data to n8n through a webhook, store it in Google Sheets, generate personalized outreach emails, and send them automatically with Gmail.

This workflow combines lead scraping, lead qualification, data organization, AI copywriting, and cold outreach into one automated pipeline.

---

Who is this for?

This template is ideal for:

• Agencies offering SEO, automation, web design, or lead generation services
• Freelancers looking to automate prospecting
• Sales teams doing cold outreach
• Entrepreneurs searching for local business leads
• Anyone using AI to scale outbound email campaigns

---

What problem is this workflow solving? / Use case

Manual prospecting is slow and repetitive.

Most businesses waste hours every week:

• Searching for leads manually
• Copying business data into spreadsheets
• Writing cold emails one by one
• Sending outreach emails manually

This workflow solves that by automating the full process from lead discovery to email delivery.

Example use case:

• Use Claude Co-Work with Apify to find restaurants in Paris
• Scrape lead data such as business name, address, website, phone number, email, and booking status
• Automatically send the collected leads to n8n through a webhook
• Save lead data in Google Sheets
• Generate a personalized outreach email for each valid lead
• Send the email automatically with Gmail

---

What this workflow does

1. Claude Co-Work uses Apify to scrape business leads and collect their data
2. Claude Co-Work automatically triggers the n8n webhook with the scraped lead data
3. n8n splits each business lead into separate items
4. n8n appends lead data to Google Sheets
5. n8n checks whether the lead has an email address
6. n8n uses Claude to generate a personalized outreach email
7. n8n extracts the email subject and body automatically
8. n8n sends the email via Gmail

Expected outcome:

• Automated lead scraping with Claude Co-Work and Apify
• Organized lead database in Google Sheets
• Personalized AI-generated outreach emails
• Automated email sending
• Faster prospecting with less manual work

---

Setup

Before using this template, create and connect the following accounts:

• Google Sheets account
• Gmail account
• Anthropic / Claude account required to run Claude Co-Work
• Apify account required for scraping lead data

Then configure:

1. Claude Co-Work + Apify

Set up Claude Co-Work so it can use Apify to scrape lead data before n8n starts.

Claude Co-Work should collect fields such as:

• collection_date
• business_category
• region_state
• city_name
• street_address
• business_name
• business_description
• website_url
• phone_number
• customer_rating
• email_address
• contact_status

2. Webhook

Configure Claude Co-Work to send the scraped data to the n8n Webhook node.

The webhook receives the lead payload and starts the workflow automatically.

3. Google Sheets

Replace:

• YOUR_ID_GOOLE_SHEETS
• YOUR_ID-sheet_GOOLE_SHEETS

With your own Google Sheet ID and Sheet tab ID.

4. Claude Prompt

Customize the outreach message inside the Outreach email copywriter node.

---

How to customize this workflow to your needs

Change target industry

Replace restaurants with:

• Dentists
• Lawyers
• Real estate agencies
• Coaches
• Ecommerce stores
• Local businesses

Change outreach offer

Instead of SEO or booking systems, promote:

• Web design
• AI chatbots
• Lead generation
• Marketing automation
• CRM setup
• Ads management

Notes

• Claude Co-Work and Apify handle the lead scraping step before n8n starts
• The webhook is triggered automatically after the lead data is collected
• Phone numbers are automatically cleaned before saving to Google Sheets
• Only leads with email addresses continue to outreach
• Gmail errors continue without stopping the workflow

---

Built for users who want to automate scraping, prospecting, and outbound sales with AI.

🎥 Watch This Tutorial

---

👋 Need help or want to customize this?

📩 Contact: LinkedIn 📺 YouTube: @DRFIRASS 🚀 Workshops: n8n courses (in French)

Need help customizing?

Contact me for consulting and support : Linkedin / Youtube / 🚀 n8n courses (in French)