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

Go to Workflow
0 views
Built by Basil Irfan Basil Irfan
Created on June 07, 2026

Description

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

What this workflow does
Collect audience specs – simple web-form asks for your ideal company profile.
Generate a laser-targeted Apollo search URL with GPT-4o (no manual filtering).
Scrape the matching leads via an Apify actor (returns clean JSON).
Craft hyper-personalized icebreakers for each lead using GPT-4o (ultra-short, human-sounding).
Log everything to Google Sheets – name, LinkedIn URL, company site, summary, and the icebreaker.
(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 personalization:** 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 | Lead JSON |
| 4 | OpenAI (GPT-4o) | Lead JSON | 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)
Import the workflow into n8n.
Add the required credentials in Credentials β†’ OpenAI, Apify, Google Sheets, Phantombuster.
Paste your Phantombuster Agent ID into the HTTP Request node URL.
Publish the Form Trigger URLβ€”this is where you (or your SDRs) describe the target audience.
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.

Nodes Used (3)

Google Sheets
n8n-nodes-base.googleSheets
HTTP Request
n8n-nodes-base.httpRequest
OpenAI
@n8n/n8n-nodes-langchain.openAi