Amirul Hakimi
Workflows by Amirul Hakimi
Enrich CRM Leads with LinkedIn Company Data using GPT-4 and Airtable
## 🚀 Enrich CRM Leads with LinkedIn Company Data Using AI ### **Who's it for** Sales teams, marketers, and business development professionals who need to automatically enrich their CRM records with detailed company information from LinkedIn profiles. Perfect for anyone doing B2B outreach who wants to personalize their messaging at scale. ### **What it does** This workflow transforms bare-bones lead records into rich, personalized prospect profiles by: - Automatically scraping LinkedIn company profiles - Using AI (GPT-4) to extract key business intelligence - Generating 15+ email-ready personalization variables - Updating your CRM with structured, actionable data The workflow pulls company overviews, products/services, funding information, recent posts, and converts everything into natural-language variables that can be dropped directly into your outreach templates. ### **How it works** 1. **Trigger**: Workflow starts when a new lead is added to Airtable (or on schedule) 2. **Fetch**: Retrieves the lead record containing the LinkedIn company URL 3. **Scrape**: Pulls the raw HTML from the company's LinkedIn profile 4. **Clean**: Strips HTML tags and formats content for AI processing 5. **Analyze**: GPT-4 extracts structured company intelligence (overview, products, market presence, recent posts) 6. **Transform**: Converts analysis into 15+ email-ready variables with natural phrasing 7. **Update**: Writes enriched data back to your CRM ### **Setup Requirements** - **Airtable account** (free tier works fine) - **OpenAI API key** (GPT-4o-mini recommended for cost-effectiveness) - **LinkedIn company URLs** stored in your CRM - **5 minutes** for initial configuration ### **How to set up** 1. **Configure Airtable Connection** - Replace `YOUR_AIRTABLE_BASE_ID` with your base ID - Replace `YOUR_TABLE_ID` with your leads table ID - Ensure your table has a "LinkedIn Organization URL" field - Add your Airtable API credentials 2. **Add OpenAI Credentials** - Click on both OpenAI nodes - Add your OpenAI API key - GPT-4o-mini is recommended (cost-effective and fast) 3. **Set Up Trigger** - Add a trigger node (Schedule, Webhook, or Airtable trigger) - Configure to run when new leads are added or on a daily schedule 4. **Test the Workflow** - Add a test lead with a LinkedIn company URL - Execute
LinkedIn Lead Enrichment & Personalized Cold Outreach with Hunter.io, GPT-4 & Sheets
Supercharge your sales and marketing efforts with this powerful automation that transforms a list of LinkedIn profiles into a fully enriched, personalized outreach campaign. This workflow is designed for sales teams, growth marketers, and business development professionals looking to scale their lead generation without sacrificing personalization. It seamlessly integrates LinkedIn scraping, email enrichment with Hunter.io, AI-powered message generation with OpenAI, and data organization in Google Sheets. ## How It Works Start with Leads: The workflow begins with a list of target LinkedIn profile URLs. Scrape Profile Data: It automatically scrapes each LinkedIn profile to extract key professional information such as name, title, company, and location. A built-in delay helps manage rate limits. Find Verified Emails: Using the scraped company and name, the workflow queries ==Hunter.io to find a verified work email address== for the lead. AI-Powered Personalization: If an email is found, the lead's data is sent to OpenAI (GPT-4), which generates a highly personalized, conversational outreach message based on their role, company, and your value proposition. Sync to CRM/Sheet: Finally, all the enriched data—including the custom AI message—is neatly organized and saved as a new row in your designated Google Sheet. ~~Stop wasting hours on manual lead research and generic outreach~~. Implement this automated workflow to focus on building relationships and closing deals.
Personalize cold emails with LinkedIn data, GPT-4 & Airtable-Instantly
# Advanced AI Lead Enrichment & Cold Email Personalization with n8n, Airtable, Apify, and LLMs ## Automated B2B Lead Nurturing: Hyper-Personalization for High-Converting Cold Email Campaigns This powerful n8n **automation workflow** is designed to execute advanced **B2B lead enrichment** and **hyper-personalization** **for cold email outreach**. By orchestrating a complex chain of data scraping, **AI analysis** (via **LLMs/GPT-4.1**), and CRM synchronization (using **Airtable**), this workflow ensures every lead receives a highly tailored and relevant outreach message, maximizing **conversion rates** and minimizing manual effort. ## Workflow Execution & Key Features 1. ### Airtable Trigger & Lead Qualification: - The workflow is triggered by an **Airtable webhook**, pulling a new lead record (including name, email, and company URLs). - **Email Validation** is performed using **NeverBounce** to filter out invalid contacts. - Initial **Lead Filtering** screens for key demographic criteria (e.g., **US: Yes or No**? and target **Headcount: >5, <30?**). Only qualified B2B leads proceed, ensuring optimal resource allocation. 2. ### Deep Web & Social Scraping (Apify Integration): - **LinkedIn Company Scraper** and a **LinkedIn Profile Scraper** (via **Apify**) extract raw data from the lead's company and personal profiles. - **Company Homepage Scraper** pulls the main website content for analysis. - **Scrape Personal LinkedIn Posts** node retrieves recent activity for the ultimate personalization hook. 3. ### AI-Powered Data Synthesis & Variable Determination: - Multiple **OpenAI (GPT-4.1-mini/4.1)** nodes analyze and structure the raw, cleaned text (**Remove HTML** nodes ensure clean inputs). - **Determine Valuable URLs** uses an LLM to smartly categorize and select key company pages (e.g., ==/about==, ==/solutions==, ==/case-studies==) for deeper scraping. - **Analyze Company/Mission, Analyze Offerings & Positioning, Analyze Process & Differentiation**, and **Analyze Proof of Success** nodes create factual, structured business summaries for the ultimate **ICP research**. - **Determine Variables** nodes create **pre-written, personalized cold email variables** (==company_specialty==, ==ICPofLead==, ==PainPointLeadSolves==, etc.) for different outreach strategies. 4. ### LinkedIn Post Personalization: - An **LLM (Craft Opening Line - Posts)** analyzes recent LinkedIn activity to generate a hyper-specific, conversation-starting opener (e.g., "Saw your LinkedIn post about..."). - Conditional logic (**Posts Available?**) determines whether to use the post-based opener or fall back to the standard, company-based personalization. 5. ### CRM Update & Campaign Launch (Instantly.ai): - Finalized, **enriched lead data** and the crafted **personalization variables** are synchronized back to the **Airtable CRM** for record-keeping and lead status updates **(Update Lead W/ Enrichment)**. - The lead is then seamlessly pushed to the **Instantly.ai** outbound platform, injecting the **AI-generated custom variables** directly into the cold email sequence for mass deployment. This blueprint automates the tedious, high-effort task of **prospect research** and personalization, providing a **scalable lead generation** solution that increases both outreach quality and sales velocity. **Stop sending generic emails**—start leveraging **AI automation** today.