Apollo Lead Generation Automation

This automation instantly builds your prospect list by finding high-quality business leads and saving them directly to your Google Sheet. Instead of manually searching for people and copying their details one by one, you simply tell the system who you are looking for (e.g., "CEOs in New York"), and it handles the rest—finding their verified email, LinkedIn profile, and company details automatically.

Key Benefits

• Fully Automated: Runs in the background while you do other work.
• Clean Data: Automatically filters out contacts without emails and removes duplicates so your list is always ready for outreach.
• Simple Input: Uses AI to understand your simple search terms and find the right people.

How to Use It

1. Open the Form: Click the link to access the search form.
2. Enter Criteria: Type in the job title (e.g., "Marketing Manager") and location.
3. Set Limit: Choose how many leads you want (e.g., 50).
4. Get Results: The system scrapes the data and populates your Google Sheet with names, emails, and phone numbers within minutes.

Lead Gen Automation Quick Guide

Prerequisites: n8n, Apify account, Gemini API Key, Google Sheet.

Setup Steps:

1. Import: Load Lead Gen 1.json into n8n.
2. Credentials:

• Apify: Update apify_api_token in the "Set API Key" node.
• Gemini: Add your API Key in the "Generate Apify Input" node.
• Google: Connect OAuth in both Sheet nodes.

1. Sheet: Create a new sheet. Paste its ID into the n8n nodes. Add these headers to row 1: firstName, lastName, personalEmail, companyName, linkedInURL, location, jobTitle, phoneNumber.

How to Run: Toggle workflow to Active. Open the Form URL, submit your search, and leads will auto-save to your sheet!