LinkedIn lead personalization with Google Drive, Apify & AI
Needs changesWhat this workflow does
This AI workflow has 18 nodes and runs on Google Drive events (file created). Along the way it connects Anthropic Chat Model, Telegram, Google Drive and OpenAI and 1 more. It also calls api.apify.com over HTTP.
How it runs
Trigger: On Google Drive events (file created).
- Google Drive: download
- Google Sheet Parse (Spreadsheet File): reads or writes a spreadsheet file (legacy node)
- Code: runs custom JavaScript code
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- End of Loops (Code): runs custom JavaScript code
- Scrape LinkedIn Profile Post (HTTP Request): calls api.apify.com (POST)
- Lead Enrichment is ready (Telegram): uses Telegram
- Date & Time: formats or calculates dates
- OpenAI: uses OpenAI
- If: checks a condition and branches into true / false
…plus 5 more steps. See the full node list below.
Services it uses
HTTP calls to: api.apify.com
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- AI Agent v1 (old agent modes) in AI Agent1 (v1.8), AI Agent_Personalization_no LN post (v1.8): replace with Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.
- Also check Spreadsheet File: Convert to File / Extract from File.
| Removed in 3.0 | Replace with |
|---|---|
| AI Agent v1 (old agent modes) AI Agent1 (v1.8), AI Agent_Personalization_no LN post (v1.8) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (14)
- Anthropic Chat Model
@n8n/n8n-nodes-langchain.lmChatAnthropic - Code
n8n-nodes-base.code - Telegram
n8n-nodes-base.telegram - Edit Fields (Set)
n8n-nodes-base.set - HTTP Request
n8n-nodes-base.httpRequest - AI Agent
@n8n/n8n-nodes-langchain.agent - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Google Drive Trigger
n8n-nodes-base.googleDriveTrigger - Google Drive
n8n-nodes-base.googleDrive - OpenAI
@n8n/n8n-nodes-langchain.openAi - Date & Time
n8n-nodes-base.dateTime - If
n8n-nodes-base.if - Spreadsheet File
n8n-nodes-base.spreadsheetFile - Google Sheets
n8n-nodes-base.googleSheets
From the author
This template enriches a lead list by analyzing each contact’s LinkedIn activity and auto-generating a single personalized opening line for cold outreach. Drop a spreadsheet into a Google Drive folder → the workflow parses rows, fetches LinkedIn content…