To view the n8n flow demo and copy the JSON you need to purchase our Bundle... don't worry, it's FREE

Go to the BUNDLE

LinkedIn Lead Generation with GPT-4o, Apify Scraping, and Automated Outreach

πŸš€ LinkedIn Lead-Gen Flywheel – Apify β†’ GPT-4o β†’ Google Sheets β†’ Phantombuster

What this workflow does

  1. Collect audience specs – simple web-form asks for your ideal company profile.
  2. Generate a laser-targeted Apollo search URL with GPT-4o (no manual filtering).
  3. Scrape the matching leads via an Apify actor (returns clean JSON).
  4. Craft hyper-personalized icebreakers for each lead using GPT-4o (ultra-short, human-sounding).
  5. Log everything to Google Sheets – name, LinkedIn URL, company site, summary, and the icebreaker.
  6. (Optional) Auto-launch Phantombuster to fire off those connection requests at scale.

Why it matters

  • Zero grunt work: audience research, scraping, copy-writing, and outreach all run hands-free.
  • Punchy customization: micro-icebreakers outperform canned intros, boosting accept rates.
  • Scales with you: flip a switch to go from 10 to 1 000+ connections/day.

Node rundown

Step Node Key Inputs Key Outputs
1 Form Trigger Audience description description_of_company
2 OpenAI (GPT-4o) Audience text SearchUrl
3 HTTP Request – Apify SearchUrl , APIFY_TOKEN JSON Lead
4 OpenAI (GPT-4o) JSON Lead Icebreaker
5 Google Sheets Lead + Icebreaker Row append/update
6 Aggregate Sheet rows Batched output
7 HTTP Request – Phantombuster PHANTOM_KEY , AGENT_ID Launch status

Prerequisites

  • OpenAI API key (GPT-4o access recommended)
  • Apify API token with access to actor id
  • Google Service Account creds shared with your target sheet
  • Phantombuster API key and Agent ID for your LinkedIn connector
  • Active Apollo account to open the generated search URL (only required for debugging)

Setup (5-minute sprint)

  1. Import the workflow into n8n.
  2. Add the required credentials in Credentials β†’ OpenAI , Apify , Google Sheets , Phantombuster .
  3. Paste your Phantombuster Agent ID into the HTTP Request node URL.
  4. Publish the Form Trigger URLβ€”this is where you (or your SDRs) describe the target audience.
  5. Hit Execute Workflow once to verify data flows end-to-end.

Customization tips

  • Titles & keywords: tweak the prompt in the first GPT-4o node to lock in different roles or industries.
  • Icebreaker style: adjust the second GPT-4o prompt to match your brand voice.
  • Data columns: map extra fields from Apify into Google Sheets as needed.
  • Skip outreach: disable the Phantombuster node if you only want the leads + icebreakers.
Do you want to automate your business?

Let's talk about your project