StacksGPT
Sales & Leads

Apollo Lead Scraper with Personalized Cold Outreach

Describe your ideal leads in a form, scrape matching contacts from Apollo through Apify, research each company and push personalized leads into an Instantly campaign.

The Problem

Building an outbound list means searching a lead database, exporting contacts, researching each company and writing an opening line for every prospect. Most of that is copy and paste.

How This Template Solves It

A founder enters a job title, company size, keywords and location. The workflow builds the Apollo search, scrapes the results, saves clean lead data to Google Sheets, researches each company with Tavily, writes an outreach message and adds the lead to Instantly.

How It Works

  1. 1A form collects job title, company size, keywords and location.
  2. 2An AI step builds the Apollo search URL, which an Apify actor scrapes.
  3. 3OpenAI parses each raw lead into clean fields and the lead is saved to Google Sheets.
  4. 4An AI agent researches the company with Tavily search.
  5. 5OpenAI writes a personalized outreach message and the lead is added to an Instantly campaign.

What You Need

  • An Apify account
  • An OpenAI API key
  • A Tavily API key
  • An Instantly account and API key
  • A Google Sheet for leads

What Stays Under Your Control

  • You review messages and campaign settings in Instantly before anything sends.
  • You define the target audience in the form.

Watch Out For

  • Scraping Apollo through a third party actor may break Apollo's terms of service. Check before using it.
  • Verify email addresses before sending to protect your sender reputation.
  • The author's notes list prices for these tools. Check each vendor's current pricing instead.

Step-by-Step Blueprint

This template is the starting point for a full guide with setup steps and prompts:

Adapted from a community workflow template. Before publishing we removed credentials, account and file IDs, email addresses and sample data. The original author's setup notes are kept inside the workflow file.

More Sales & Leads Templates