Personalized Lawyer Outreach: LinkedIn Search, GPT-4o, Google Sheets

This n8n workflow automates lead generation for the legal niche by using Google Programmable Search to discover solo lawyers and small firm founders on LinkedIn without violating TOS or needing Sales Navigator. It parses search results for names, titles, profile URLs, and snippets, then saves raw data to Google Sheets.

Next, it enriches each profile using OpenRouter's Sonar Pro model to pull external content, followed by GPT-4o to craft a hyper-personalized one-line outreach message tailored to the lawyer's background. The final enriched data and message are appended to the same Google Sheets for easy copy-paste into email, LinkedIn DMs, or CRM tools.

Benefits include scaling to 1,000 leads per day at low cost, full compliance with official APIs, and no browser automation required. Ideal for legal tech founders, marketing agencies, or freelancers targeting lawyers—saving hours of manual scraping and personalization while boosting response rates through relevance.

Setup takes 15-20 minutes: configure Google Custom Search API, Sheets OAuth, and OpenRouter keys. No community nodes needed, purely official n8n integrations for reliable, production-ready automation.