Gemini + Google Sheets: LinkedIn leads ready to send
LinkedIn prospecting falls apart in the same place every time. You start with “quick research,” then you’re buried in tabs, half-baked search strings, and copy-paste outreach that never quite fits.
Gemini lead outreach hits hardest for sales teams chasing pipeline, but recruiters and founders feel it too. You need a repeatable way to find up to 20 relevant profiles fast, log them somewhere sane, and draft messages you can actually send without rewriting from scratch.
This n8n workflow turns a simple form submission into a LinkedIn-ready lead list inside Google Sheets, plus personalized outreach drafts for each lead. You’ll see exactly what it automates, what results you get, and what you need to run it.
How This Automation Works
The full n8n workflow, from trigger to final output:
n8n Workflow Template: Gemini + Google Sheets: LinkedIn leads ready to send
flowchart LR
subgraph sg0["Form submit Flow"]
direction LR
n0@{ icon: "mdi:swap-vertical", form: "rounded", label: "Split Out", pos: "b", h: 48 }
n1@{ icon: "mdi:swap-vertical", form: "rounded", label: "Loop Over Items", pos: "b", h: 48 }
n2["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/form.svg' width='40' height='40' /></div><br/>Form submit"]
n3@{ icon: "mdi:robot", form: "rounded", label: "Create boolean search strings", pos: "b", h: 48 }
n4["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/httprequest.dark.svg' width='40' height='40' /></div><br/>Get Linkedin Company"]
n5@{ icon: "mdi:robot", form: "rounded", label: "Writing message", pos: "b", h: 48 }
n6@{ icon: "mdi:database", form: "rounded", label: "Update sheet", pos: "b", h: 48 }
n7@{ icon: "mdi:message-outline", form: "rounded", label: "Send email", pos: "b", h: 48 }
n8@{ icon: "mdi:database", form: "rounded", label: "Append row in sheet", pos: "b", h: 48 }
n0 --> n1
n2 --> n3
n6 --> n1
n1 --> n7
n1 --> n8
n5 --> n6
n8 --> n5
n4 --> n0
n3 --> n4
end
%% Styling
classDef trigger fill:#e8f5e9,stroke:#388e3c,stroke-width:2px
classDef ai fill:#e3f2fd,stroke:#1976d2,stroke-width:2px
classDef aiModel fill:#e8eaf6,stroke:#3f51b5,stroke-width:2px
classDef decision fill:#fff8e1,stroke:#f9a825,stroke-width:2px
classDef database fill:#fce4ec,stroke:#c2185b,stroke-width:2px
classDef api fill:#fff3e0,stroke:#e65100,stroke-width:2px
classDef code fill:#f3e5f5,stroke:#7b1fa2,stroke-width:2px
classDef disabled stroke-dasharray: 5 5,opacity: 0.5
class n2 trigger
class n3,n5 ai
class n6,n8 database
class n4 api
classDef customIcon fill:none,stroke:none
class n2,n4 customIcon
The Problem: LinkedIn Prospecting Takes Forever to Do Well
Manual LinkedIn prospecting is slow in a way that’s hard to measure, because it’s not one big task. It’s a hundred tiny ones. You brainstorm keywords, guess at Boolean operators, test searches, tweak filters, open profiles, copy links, paste notes, then try to write a message that sounds personal even though you’re on your tenth one. Miss one detail and you send something awkward. Miss a step and you lose the lead entirely. After a week, you have “some leads” scattered across browser history, DMs, and random spreadsheets.
None of these alone is the problem. Together, they are.
- You spend about 10 minutes just getting to a decent Boolean search, then repeat it next week because you didn’t save the logic.
- Copying names, URLs, and snippets into a sheet invites typos and duplicates, which means follow-ups get messy fast.
- Outreach copy becomes generic when you’re rushing, and “generic” is basically invisible on LinkedIn.
- There’s no clean handoff from “found a lead” to “message drafted,” so momentum dies between steps.
The Solution: Gemini-Generated Searches + Sheet-Based Outreach Drafts
This workflow starts with a simple form where you enter your keywords and the purpose of contact (for example: “SaaS founders in HR tech” + “partnership intro”). Gemini takes that input and generates a LinkedIn-specific Boolean query designed for searching the public web (it formats it like a proper site:linkedin.com query, not a vague prompt). Next, n8n uses the Google Custom Search API to pull up to 20 matching results, then appends each one to a Google Sheet with the details you care about: name/title snippet, LinkedIn URL, and description. After that, the workflow loops through the new rows one by one and asks Gemini to draft a personalized outreach message using your stated purpose plus whatever context exists in the listing snippet. Finally, it updates the same sheet row with the draft message and can email you a link when the run is done.
The workflow begins when someone submits the form. It turns keywords into a stronger search query, collects up to 20 LinkedIn listings, then drafts outreach for each and writes everything back to Google Sheets. If you enable it, you also get an email alert so you don’t have to keep checking.
What You Get: Automation vs. Results
| What This Workflow Automates | Results You’ll Get |
|---|---|
|
|
Example: What This Looks Like
Say you build a list of 20 LinkedIn prospects every Monday. Manually, you might spend about 5 minutes refining a Boolean search, then maybe 3 minutes per lead to open results, copy the URL, paste details into a sheet, and start a first message. That’s roughly 1 hour of busywork (often more). With this workflow, you submit the form in about 2 minutes, wait a few minutes for search + drafting, then review the sheet. You get most of that hour back, and the output is already organized.
What You’ll Need
- n8n instance (try n8n Cloud free)
- Self-hosting option if you prefer (Hostinger works well)
- Google Sheets for storing leads and message drafts
- Google Custom Search API to fetch LinkedIn results at scale
- Gemini API access (get it from Google AI Studio / Gemini API credentials)
Skill level: Intermediate. You’ll connect accounts, paste API credentials, and map a few fields into the right sheet columns.
Don’t want to set this up yourself? Talk to an automation expert (free 15-minute consultation).
How It Works
A form submission kicks things off. You enter keywords and a purpose (who you want, and why you’re contacting them). This keeps the workflow simple for your team because nobody has to open n8n to run it.
Gemini turns intent into a real search query. Instead of guessing at Boolean syntax, Gemini generates a LinkedIn-specific query that works well with web search, so you start from a stronger baseline.
Google Custom Search finds up to 20 LinkedIn listings. n8n requests results through the HTTP step, then splits them into individual items so each lead can be processed cleanly.
Google Sheets becomes your system of record. The workflow appends each lead (name/snippet, URL, description) to your sheet, drafts outreach with Gemini for each row, then updates the same row with the finished message. Optionally, it sends an email to tell you the run is complete.
You can easily modify the “purpose” input to generate different tones (friendly, direct, recruiter-style) based on your needs. See the full implementation guide below for customization options.
Step-by-Step Implementation Guide
Step 1: Configure the Form Trigger
Set up the workflow to start when a user submits the outreach request form.
- Add the Incoming Form Trigger node to your canvas.
- Set the Form Title to
1.0 S_LG_Find LinkedIn Accounts by keywords and Write personal message for contact. - Add form fields for Keywords to find Company / Professional and Purpose of Contact.
Step 2: Connect Google Sheets
Store LinkedIn profiles and outreach messages in your spreadsheet.
- Open Append Sheet Entry and set the Operation to
appendOrUpdate. - Set the Document ID to
=[YOUR_ID]and the Sheet Name toSheet1. - Map columns in Append Sheet Entry with expressions: des to
{{ $json.pagemap.metatags[0]["og:description"] }}, name to{{ $json.title }}, and linkedin_url to{{ $json.link }}. - Open Modify Sheet Row and set the Operation to
update. - Set matching columns to linkedin_url and map message to
{{ $json.content.parts[0].text }}and linkedin_url to{{ $('Append Sheet Entry').item.json.linkedin_url }}. - Credential Required: Connect your googleSheetsOAuth2Api credentials in both Append Sheet Entry and Modify Sheet Row.
Step 3: Set Up AI Processing Nodes
Use Gemini to generate search queries and personalized outreach messages.
- Open Generate Search Queries and confirm the model is set to
models/gemini-2.5-flash. - Ensure the prompt references the form fields with
{{ $json['Keywords to find Company / Professional'] }}and{{ $json['Purpose of Contact'] }}. - Open Compose Outreach Text and confirm the model is set to
models/gemini-1.5-flash. - Verify the prompt references the trigger and listing data with
{{ $('Incoming Form Trigger').item.json['Purpose of Contact'] }},{{ $json.name }}, and{{ $json.des }}. - Credential Required: Connect your googlePalmApi credentials in both Generate Search Queries and Compose Outreach Text.
Step 4: Configure LinkedIn Search, Splitting, and Email Output
Fetch LinkedIn listings, split results, and send completion alerts.
- In Request LinkedIn Listings, set the URL to
https://www.googleapis.com/customsearch/v1and enable Send Query. - Set query parameters: key to
[CONFIGURE_YOUR_API_KEY], cx to[YOUR_ID], q to{{ $json.content.parts[0].text }}, num to20, hl tovi, and gl tovn. - Configure Separate Items with Field To Split Out set to
items. - Keep Iterate Records as the batch controller for processing one item at a time.
- Set Dispatch Email Alert fields: Subject to
Your auto writing message be completed, To Email to[YOUR_EMAIL], From Email to[YOUR_EMAIL], and HTML to[Link to sheet]. - Credential Required: Connect your smtp credentials in Dispatch Email Alert.
Iterate Records outputs to both Dispatch Email Alert and Append Sheet Entry in parallel.
⚠️ Common Pitfall: The Google Custom Search API in Request LinkedIn Listings will fail if [CONFIGURE_YOUR_API_KEY] or [YOUR_ID] are left as placeholders.
Step 5: Test and Activate Your Workflow
Validate the full execution from form submission to email alert.
- Click Execute Workflow and submit the form in Incoming Form Trigger with sample keywords and purpose.
- Confirm Generate Search Queries produces a boolean search string containing
site:linkedin.com. - Verify Request LinkedIn Listings returns items, then Separate Items and Iterate Records process them.
- Check your Google Sheet to see rows inserted by Append Sheet Entry and updated messages by Modify Sheet Row.
- Confirm you receive the completion email from Dispatch Email Alert.
- Toggle the workflow to Active for production use.
Common Gotchas
- Google Custom Search API credentials can expire or be restricted. If things break, check your Google Cloud API key permissions and your CSE “cx” setting first.
- If you’re using Wait nodes or external rendering, processing times vary. Bump up the wait duration if downstream nodes fail on empty responses.
- Default prompts in AI nodes are generic. Add your brand voice early or you’ll be editing outputs forever.
Frequently Asked Questions
About 30 minutes once your APIs are ready.
No coding required. You’ll connect accounts, paste keys, and map sheet columns.
Yes. n8n has a free self-hosted option and a free trial on n8n Cloud. Cloud plans start at $20/month for higher volume. You’ll also need to factor in Gemini API usage and Google Custom Search API costs based on how often you run it.
Two options: n8n Cloud (managed, easiest setup) or self-hosting on a VPS. For self-hosting, Hostinger VPS is affordable and handles n8n well. Self-hosting gives you unlimited executions but requires basic server management.
Yes, and it’s mostly prompt tweaks. Keep the same search stage, then adjust the Gemini “Compose Outreach Text” prompt to reference role, tech stack, location, and a clear candidate value proposition. Many teams also add a “tone” field to the form (direct, friendly, formal) and pass it into Gemini so every draft matches your style.
Usually it’s permissions or the wrong spreadsheet selection. Reconnect Google Sheets in n8n, confirm the account has edit access to that specific file, and double-check that the node is pointing at the right sheet tab. If the workflow appends rows but fails on updates, the column mapping often changed after someone edited the header row.
This version pulls up to 20 results per run.
Sometimes. If you want tight control over looping through up to 20 leads, updating the same Google Sheets row, and customizing Gemini prompts without fighting platform limits, n8n is usually the smoother choice. The self-hosted option also matters if you’re running prospecting daily and don’t want to watch task counts. Zapier or Make can be simpler for quick two-step flows, but this one benefits from branching and batch processing. If you want help choosing, Talk to an automation expert.
Once this is running, LinkedIn prospecting stops being a “project” and becomes a quick form submission plus a short review. The workflow handles the repetitive parts so you can focus on the conversations that actually move deals forward.
Need Help Setting This Up?
Our automation experts can build and customize this workflow for your specific needs. Free 15-minute consultation—no commitment required.
