This workflow automates lead generation for B2B legal audiences by finding solo practitioners and small law firm founders on LinkedIn, enriching their profile data, generating personalized outreach messages using AI, and storing everything in Google Sheets — fully automated and scheduled.
## Who it´s for
- Marketers in law firms looking for clients via LinkedIn
- Legaltech startups automating lead generation
- Freelancers selling services to lawyers through personalized outreach
- Agencies scaling cold outreach with minimal manual effort
## What the automation does
- Runs on a cron schedule
- Searches for solo practitioners and small law firm founders on LinkedIn using Google Custom Search API
- Enriches profile data using a LangChain research agent
- Generates personalized outreach messages via GPT-4o (through OpenRouter)
- Stores all profiles, enriched data, and message drafts in Google Sheets
## What´s included
- Ready-to-use n8n workflow
- Cron trigger logic and result processing
- Integrations with Google Search API, Google Sheets, OpenRouter (GPT-4o), and LangChain
- Basic textual guide for launch and adaptation
## Requirements for setup
- n8n account with external API access
- Google Custom Search API key and configured Search Engine ID
- Google Sheets account with editing permissions
- OpenRouter API key with access to GPT-4o
- Basic understanding of LangChain agents in n8n
## Benefits and outcomes
- Reduces lead research and prep time by up to 90%
- Increases outreach relevance and response rates through personalization
- Delivers a steady stream of qualified leads without manual search
- Centralizes all lead data in Google Sheets
- Enables scalable cold outreach without hiring extra staff
## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via Telegram: @gleb923.
find lawyers on LinkedIn
personalized outreach messages
lead generation automation
LinkedIn profile scraping
cold outreach for lawyers
Google Sheets integration
n8n workflow
LangChain research agent
Google Custom Search API
automated lead enrichment
GPT-4o message generation
LinkedIn data extraction
scheduled lead sourcing
B2B outreach automation
legal tech automation
No feedback yet