LinkedIn Lead Finder & Gemini-Powered Personalized Outreach (n8n Template)

Input keywords + purpose → Gemini generates Boolean search string → Google Custom Search fetches LinkedIn results → Write to Google Sheets → Loop to generate personalized outreach messages → Optional email notification

Who

Sales/BD teams, recruiters, marketers, or founders who want to automate LinkedIn prospecting and first-draft outreach

You get

Automatically fetch up to 20 LinkedIn leads via form trigger and generate personalized outreach drafts for each, saved to Google Sheets with optional email notification

You need

n8n · google-gemini · http-request · google-sheets · email

Steps

1. Configure Form Trigger and Gemini Boolean Query Node

   After importing the template into n8n, configure the Form submit trigger: form title is 'Find LinkedIn Accounts by keywords and Write personal message for contact', with two fields: 'Keywords to find Company / Professional' and 'Purpose of Contact'. Then configure the 'Create boolean search strings' Gemini node: select model gemini-2.5-flash and bind the googlePalmApi credential. The prompt is embedded and should not need editing, but verify the credential is active.

   Execution prompt · Source text。Create boolean search strings node, messages.values[].content field

   Copy prompt

   =You are a tool that generates Boolean search strings for Google, in order to search for companies or professionals on LinkedIn.  
   
   # Task:
   - Based on the keyword and the purpose, generate a suitable keyword string for searching on LinkedIn.  
   - Only return the keyword string, without any explanation or additional information.  
   - Always add site:linkedin.com to the keyword string.  
   
   # Input:
   Keyword: {{ $json['Keywords to find Company / Professional'] }}
   Purpose: {{ $json['Purpose of Contact'] }}

2. Configure Google Custom Search HTTP Request Node

   Open the 'Get Linkedin Company' HTTP Request node; URL is fixed at https://www.googleapis.com/customsearch/v1. In Query Parameters, enter your CSE API key, cx (search engine ID), and query string (referencing previous Gemini output). Set num to 20; adjust hl and gl to your target locale (default vi/vn is Vietnam/Vietnamese—change to e.g. en/us).

3. Configure Google Sheets Append Node

   Configure the 'Append row in sheet' Google Sheets node: bind googleSheetsOAuth2Api credential, select target spreadsheet and Sheet1. In Columns mapping: name → {{ $json.title }}, linkedin_url → {{ $json.link }}, des → {{ $json.pagemap.metatags[0]["og:description"] }}. Ensure the spreadsheet has matching column headers.

4. Configure Loop Split and Gemini Message Writer Node

   The 'Split Out' node splits the HTTP result items array into individual entries; 'Loop Over Items' processes them one by one. For each entry, the 'Writing message' Gemini node (actually configured as gemini-1.5-flash, not gemini-2.5-flash) binds to the same googlePalmApi credential. It reads the entry's name/des and the form-submitted Purpose of Contact to generate a personalized outreach message. Then the 'Update sheet' node updates the message field matched by linkedin_url.

   Execution prompt · Source text。Writing message node, messages.values[].content field

   Copy prompt

   =You are an AI that drafts outreach messages.
   
   # Requirements
   Based on the purpose: {{ $('Form submit').item.json['Purpose of Contact'] }}
   and the company information:  
   name: {{ $json.name }}  
   description: {{ $json.des }}  
   
   Write a suitable and personalized outreach message for that specific company.  
   
   Only return the outreach message, without any explanation or additional text.  
   If some information is missing, use placeholders.

5. Configure Optional Email Notification Node

   If email notification is desired, configure the 'Send email' node: bind SMTP credential, set fromEmail, toEmail, subject (default 'Your auto writing message be completed'), and html body with a link to the sheet. This node is optional; the core flow works without it.

6. Publish Form and Test

   Save and publish the workflow, activating the Form trigger. Submit a test set of keywords and purpose via the public form link. Verify: 1) new rows appear in Sheets; 2) the message column is populated; 3) email is received (if enabled). First test with a small keyword set to confirm hl/gl and CSE configuration.

You are setting up an n8n workflow to automate LinkedIn lead finding and personalized outreach drafting. Please confirm the following prerequisites:
1. n8n instance (cloud or self-hosted)
2. Google Sheets account with a blank spreadsheet, columns: name, linkedin_url, des, message
3. Google Custom Search Engine ('Search the entire web' enabled) API key and cx
4. Gemini API credential (googlePalmApi)
5. SMTP credentials (optional)

Once confirmed, configure the form trigger, both Gemini nodes, HTTP Request, Google Sheets read/write, loop, and optional email nodes in order. Note that the Writing message node is currently gemini-1.5-flash; change manually if a different model is desired.