Templates / LinkedIn lead personalization with Google Drive, Apify & AI

LinkedIn lead personalization with Google Drive, Apify & AI

Needs changes

by Mariela Slavenova ✓ · 373 views · created 2025-09-18 · Lead Generation, AI Chatbot

Needs changes. This template uses 1 thing(s) that n8n 3.0 removes: AI Agent v1 (old agent modes). 1 breaking item(s) found. Static check, last run 2026-10-19.

What 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).

  1. Google Drive: download
  2. Google Sheet Parse (Spreadsheet File): reads or writes a spreadsheet file (legacy node)
  3. Code: runs custom JavaScript code
  4. Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
  5. End of Loops (Code): runs custom JavaScript code
  6. Scrape LinkedIn Profile Post (HTTP Request): calls api.apify.com (POST)
  7. Lead Enrichment is ready (Telegram): uses Telegram
  8. Date & Time: formats or calculates dates
  9. OpenAI: uses OpenAI
  10. If: checks a condition and branches into true / false

…plus 5 more steps. See the full node list below.

Services it uses

Anthropic Chat ModelTelegramGoogle DriveOpenAIGoogle Sheets

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.0Replace 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)

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…

Excerpt from Mariela Slavenova's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.