AutomationMart
Home/Browse/Personalized outreach for lawyers with LinkedIn scraping, GPT-4o, Google Sheets
n8n

Personalized outreach for lawyers with LinkedIn scraping, GPT-4o, Google Sheets

n8nn8n11 modulesv1.0
HubSpotAirtableGoogle SheetsOpenAILinkedInPerplexity

This template uses only official n8n nodes. No community nodes required. 🧑‍💼 Who is this for? This workflow is designed for: - Legal tech founders - Marketing freelancers or consultants - Agencies supporting lawyers and small law firms - Anyone doing outbound outreach in the legal niche ❓ What problem is this solving? LinkedIn is a goldmine for targeting legal professionals — but scraping and personalizing outreach is tedious and expen

At a glance

Personalized outreach for lawyers with LinkedIn scraping, GPT-4o, Google Sheets is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects HubSpot, Airtable, Google Sheets, OpenAI. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
HubSpot, Airtable, Google Sheets, OpenAI, LinkedIn, Perplexity
Modules
11
Price
Free
Version
v1.0
Personalized outreach for lawyers with LinkedIn scraping, GPT-4o, Google Sheets workflow diagram

About this workflow

This template uses only official n8n nodes. No community nodes required. 🧑‍💼 Who is this for? This workflow is designed for: - Legal tech founders - Marketing freelancers or consultants - Agencies supporting lawyers and small law firms - Anyone doing outbound outreach in the legal niche ❓ What problem is this solving? LinkedIn is a goldmine for targeting legal professionals — but scraping and personalizing outreach is tedious and expensive. Most tools either: - Require paid LinkedIn Sales Navigator - Can’t personalize at scale - Violate LinkedIn’s TOS This workflow solves that by using free Google Search, OpenRouter AI, and GPT-4o to find, enrich, and message up to 1,000 solo lawyers per day — without using browser automation or scrapers. --- ⚙️ What this workflow does 1. Uses Google Programmable Search to find solo lawyers and small firm founders on LinkedIn 2. Parses each profile’s name, title, profile URL, and snippet 3. Saves raw lead data to Google Sheets 4. Uses OpenRouter Sonar Pro to enrich each profile with external content 5. Generates a personalized, 1-line message using GPT-4o 6. Appends the final message into Google Sheets for outreach --- 🛠️ Setup Estimated time: 15–20 minutes ✅ Google Programmable Search - Enable the Custom Search API on Google Cloud - Create a programmable search engine set to search the full web - Copy your API key and CX ID ✅ Google Sheets - Create a sheet with columns: Name, Title, Profile URL, Outreach Message - Share the sheet with your OAuth-connected Google account ✅ OpenRouter - Sign up at openrouter.ai - Fund with at least $5 and generate your API key - Use the model perplexity/sonar-pro for real-time research ✅ GPT-4o (optional) - You can use your OpenAI key or route GPT-4o via OpenRouter All setup-specific values are marked clearly in sticky notes and placeholders. --- 🛠️ How to customize this workflow to your needs - Change the Google search query to match your industry (e.g., "founder" AND "therapist" site:linkedin.com/in) - Modify the AI prompt to match your tone (formal, casual, humorous) - Connect the final output to your CRM (like HubSpot, Airtable, etc.) - Add a second outreach message variant to A/B test performance --- 📌 Sticky Notes & Annotations - All nodes are clearly renamed for understandability (e.g., Find Lawyer Profiles, Parse LinkedIn Search Results) - Color-coded sticky notes explain: - Setup instructions - Required credentials - Use case --- 🗂 Category - AI - Sales - Marketing

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 5

    Click Execute Workflow to test, then activate.

Setup guide

Setup guide included

Purchase to unlock the full step-by-step guide

Related N8n workflows

Set Persona based on Job Title in Pipedrive with ChatGPT

This template is part of the [How to automate & maximize lead generation](https://www.youtube.com/watch?v=-9oX7XEISLs&ab_channel=Make) webinar. Improve your Pipedrive experience by setting persona according to job titles using ChatGPT, a clever solution to personalize and enhance CRM interactions.

Free

Automate YouTube thumbnail creation & social publishing with Templated.io & Blotato

Automate YouTube thumbnail creation from video links (with templated.io) Who is this for? This workflow is designed for content creators, YouTubers, and automation enthusiasts who want to automatically generate stunning YouTube thumbnails and streamline their publishing workflow — all within n8n. If you regularly post videos and spend hours designing thumbnails manually, this automation is built for you. -

Free

Automate cryptocurrency funding fee tracking with Binance API and Airtable

Video Guide I prepared a detailed guide that showed the whole process of integrating the Binance API and storing data in Airtable to manage funding statements associated with tokens in a wallet. []( Youtube Link Who is this for? This workflow is ideal for developers, financial analysts, and cryptocurrency enthusiasts who want to automate the process of managing funding statements and token prices. It’s particularly useful for those who need a systematic approach to track and report funding fees

Free

Sync Facebook Ads data to Google Sheets

Simplify your marketing analytics workflow with our automated solution that transfers your Facebook Ads data to Google Sheets daily. Gain a consolidated view of your campaigns' performance and budget allocations every morning at 8:00 AM, using the previous day's data. Customizable scheduling is available to fit your reporting routine—adjust the time settings in the first module with a click.

Free

Create a Shopify product with your Canva design and manage on Google Sheets

Design in Canva for Shopify products and automatically post. Manage images through Google Sheets for streamlined product listings.

Free

Google Maps leads (names,emails,phones...) Apify + Airtable + custom emails

Who is it for? This workflow is perfect for anyone who wants to: - Automatically collect contacts from Google Maps: emails, phone numbers, websites, social media (LinkedIn, Facebook), city, ratings, and reviews. - Organize everything neatly in Airtable, without dealing with messy CSV exports that cause headaches. - Send a personalized email to each lead, without writing it or hitting "send" yourself. 👉 In short, it's the perfect tool for marketing agencies, freelancers in prospecting, or sales t

Free

Automate lead qualification & personalized outreach with Jotform, GPT & Gmail

Automatically qualify inbound demo requests, scrape prospect websites, and send AI-personalized outreach emails—all on autopilot. What This Workflow Does This end-to-end lead automation workflow helps SaaS companies qualify and nurture inbound leads with zero manual work until human approval. Key Features ✅ Smart Email Filtering - Automatically flags personal emails (Gmail, Yahoo, etc.) and routes them to a polite regret message ✅ Website Intelligence - Scrapes prospect websites and extracts bu

Free

Resume screening & evaluation system with Gemini AI, Google Sheets & Drive for HR

AI Resume Screener (n8n Workflow Template) An AI-powered resume screening system that automatically evaluates applicants from a simple web form and gives you clear, job-specific scoring — no manual filtering needed. ⚡ What the workflow does 📄 Accepts CV uploads via a web form (PDF) 🧠 Extracts key info using AI (education, skills, job history, city, birthdate, phone) 🎯 Dynamically matches the candidate to job role criteria stored in Google Sheets 📝 Generates an HR-style evalua

Free

Reviews

No reviews yet

Be the first to buy and share your experience.

Leave a review

Sign in to share your experience with this workflow.

Log in to review
Free
No ratings yet

Create a free account to purchase workflows.

  • JSON blueprint — instant download
  • Setup guide PDF included
  • 5 downloads · valid 30 days
  • Works with n8n

Need help setting this up?

Book a 3-hour live setup session with an Agility consultant.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free