Templates / LinkedIn lead finder & Gemini-powered personalized outreach with Google Sheets

LinkedIn lead finder & Gemini-powered personalized outreach with Google Sheets

Ready for 3.0

by Cong Nguyen ✓ · 1,569 views · created 2025-08-28 · Lead Generation, Multimodal AI

Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.

What this workflow does

This AI workflow has 9 nodes and runs when someone submits an n8n form (“1.0 S_LG_Find LinkedIn Accounts by keywords and Write person”). Along the way it connects Google Gemini and Google Sheets. It also calls googleapis.com over HTTP.

How it runs

Trigger: When someone submits an n8n form (“1.0 S_LG_Find LinkedIn Accounts by keywords and Write person”).

  1. Create boolean search strings (Google Gemini): uses Google Gemini
  2. Get Linkedin Company (HTTP Request): calls googleapis.com
  3. Split Out: splits a list into separate items
  4. Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
  5. Send Email: sends an email over SMTP
  6. Append row in sheet (Google Sheets): append or update
  7. Writing message (Google Gemini): uses Google Gemini
  8. Update sheet (Google Sheets): update

Services it uses

Google GeminiGoogle Sheets

HTTP calls to: googleapis.com

Before you upgrade to n8n 3.0

Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.

Nodes used (7)

From the author

📄 What this workflow does This workflow automates the process of finding LinkedIn leads and writing personalized outreach messages. It takes user input (keywords + purpose), generates a Boolean LinkedIn search query with Gemini, fetches up to 20 results via…

Excerpt from Cong Nguyen'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.