LinkedIn lead finder & Gemini-powered personalized outreach with Google Sheets
Ready for 3.0What 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”).
- Create boolean search strings (Google Gemini): uses Google Gemini
- Get Linkedin Company (HTTP Request): calls googleapis.com
- Split Out: splits a list into separate items
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Send Email: sends an email over SMTP
- Append row in sheet (Google Sheets): append or update
- Writing message (Google Gemini): uses Google Gemini
- Update sheet (Google Sheets): update
Services it uses
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)
- Split Out
n8n-nodes-base.splitOut - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - n8n Form Trigger
n8n-nodes-base.formTrigger - Google Gemini
@n8n/n8n-nodes-langchain.googleGemini - HTTP Request
n8n-nodes-base.httpRequest - Google Sheets
n8n-nodes-base.googleSheets - Send Email
n8n-nodes-base.emailSend
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…