You’ve probably seen that Apify has taken down all Apollo scrapers, so I’m coming with an alternative so it doesn’t disrupt your list building process.

I created an n8n workflow that automates LinkedIn lead generation using LeadRapidly's API.

👉 Access the template here

Here’s a summary of how it works:

Users submit their lead requirements through a web form, and the system automatically:

1. Generates an Apollo.io search URL based on criteria

2. Executes the search and retrieves leads

3. Exports results to a Google Sheet

What you'll need

• n8n instance (self-hosted or cloud)

• Apollo.io API access via LeadsRapidly API

• OpenAI API key (for URL generation)

• Google Sheets API (for data export)

📋 How to Use

Step 1: Access the Form

1. Navigate to your n8n workflow

2. Open the "On form submission" node

3. Click on "Test URL" or copy the production webhook URL

4. Share this URL with users who need to generate leads

Step 2: Fill Out the Lead Request Form

The form includes the following fields:

Job Title
Company Size
Industry
Location
Number of Leads Required

Example Form Submission:

Job Title: Founder, CEO, President
Company Size: 1-10, 11-50
Industry: Real Estate
Location: United States, Austin, Texas
Verified Emails Only?: Yes
Number of Leads Required: 150

Step 3: Submit and Wait

1. Click Submit on the form

2. The workflow will:

   • Generate an Apollo.io search URL

   • Execute the search

   • Wait for results (typically 1-5 minutes)

   • Export data to Google Sheets

Process

1. Form Submission to captures user input from the web form

2. Apollo URL Generator (AI Agent)

   • Uses OpenAI GPT-4.1 to convert form data into a valid Apollo.io search URL

   • Handles multiple values (e.g., multiple job titles)

   • Maps industries to Apollo's internal IDs

   • Properly encodes all URL parameters

3. Run Apollo

   • Sends a POST request to LeadsRapidly API

   • Initiates the lead search transaction

4. Wait & Status Check Loop

   • Waits 1 minute, then checks if results are ready

   • Repeats until leads are fully processed

   • Ensures data completeness before export

5. Download Data

   • Retrieves the final lead list in JSON format

6. Structure Data

   • Parses and formats the lead information

7. Export to Google Sheets

   • Appends or updates rows in your Google Sheet

   • Prevents duplicate entries based on LinkedIn URLs

📊 Output Data

Google Sheet Columns

The workflow exports the following fields:

First Name
Last Name
Email
Personal LinkedIn profile URL
Job title 
LinkedIn headline 
Job seniority level 
Department 
Company Name
Company Website
Company LinkedIn page 
Industry 
Employees 
City, State, Country
Phone Number 
Keywords

⚙️ Configuration

API Credentials Required

1. LeadsRapidly/Apollo API

• Where to add: Run Apollo and Status Check nodes

• Header: Authorization: Bearer YOUR_API_KEY

2. OpenAI API

• Where to add: OpenAI Chat Model node

• Credential name: OpenAI API

3. Google Sheets API

• Where to add: Append or update row in sheet node

• Credential name: Google Sheets OAuth2

Google Sheet Setup

1. Create or open your Google Sheet

2. Use the template column headers (see Output Data section)

3. Update the "Append or update row in sheet" node with your Sheet ID

4. Grant n8n access to your Google account

👉 Access the template here