Matthieu
Templates by Matthieu
Search LinkedIn companies, score with AI and add them to Google Sheet CRM
Search LinkedIn companies, Score with AI and add them to Google Sheet CRM Setup Video: https://youtube.com/watch?v=m904RNxtF0w&t Who is this for? This template is ideal for sales teams, business development professionals, and marketers looking to build a targeted prospect database with automatic qualification. Perfect for agencies, consultants, and B2B companies wanting to identify and prioritize the most promising potential clients. What problem does this workflow solve? Manually researching companies on LinkedIn, evaluating their fit for your services, and tracking them in your CRM is time-consuming and subjective. This automation streamlines lead generation by automatically finding, scoring, and importing qualified prospects into your database. What this workflow does This workflow automatically searches for companies on LinkedIn based on your criteria, retrieves detailed information about each company, filters them based on quality indicators, uses AI to score how well they match your ideal customer profile, and adds them to your Google Sheet CRM while preventing duplicates. Setup Create a Ghost Genius API account and get your API key Configure HTTP Request nodes with Header Auth credentials Create a copy of the provided Google Sheet template Set up your Google Sheet and OpenAI credentials following n8n documentation Customize the "Set Variables" node to match your target audience and scoring criteria How to customize this workflow Modify search parameters to target different industries, locations, or company sizes Adjust the follower count threshold based on your qualification criteria Customize the AI scoring system to align with your specific product or service offering Add notification nodes to alert you when high-scoring companies are identified
By MatthieuAI-powered lead generation system with email personalization and LinkedIn
🔧 AI-Powered B2B Prospecting Automation This automation is a complete end-to-end system designed to find, qualify, and contact B2B leads — fully automated and powered by AI. Lead Discovery & Scoring Searches for target companies on LinkedIn via Ghost Genius API, using filters like location, and company size. Enriches each company with details like website, description, and follower count. Uses OpenAI to score each company (0 to 10) based on fit with your product. Filters out irrelevant companies and stores only qualified ones (score ≥ 7) into a Google Sheet CRM. Decision-Maker Enrichment & Outreach Finds key decision-makers at each qualified company via LinkedIn Sales Navigator. Retrieves their job titles, descriptions, and LinkedIn summaries. Generates a fully personalized 3-email cold outreach sequence using OpenAI. Retrieves verified email addresses using a waterfall enrichment system. Stores all contact data and email content in your CRM and updates lead status. Key Features Fully automated: runs daily with no manual input required. Smart targeting: all filters and parameters managed in Google Sheets. AI-enhanced: leverages OpenAI for scoring, personalization, and copywriting. Compliant & safe: uses Ghost Genius API (cookieless scraping). --- Ideal for B2B startups, agencies, or growth teams looking to scale outbound without manual effort.
By MatthieuAI-powered cold call machine with LinkedIn, OpenAI & Sales Navigator
🔧 AI-Powered Cold Call Machine 🎯 Purpose The AI-Powered Cold Call Machine is a fully automated workflow designed to generate qualified leads from LinkedIn, evaluate them using AI-based scoring, identify key decision-makers, and generate personalized cold call scripts. All results are saved to a Google Sheet-based CRM. --- ⚙️ How It Works Initialization Triggered either manually or via schedule. Pulls configuration from a Google Sheet’s Settings tab (e.g., target product, keywords, company size, API key). Company Search on LinkedIn Uses the Ghost Genius API to search for companies based on cleaned, relevant keywords extracted by OpenAI. Handles pagination, up to 1000 companies per batch. Company Filtering Each company goes through: Data enrichment via Ghost Genius (website, size, followers, etc.). Filtering: Must have a LinkedIn page with a website. Must have 200+ followers. Deduplication: checks if the company already exists in the CRM. AI-Based Company Scoring A specialized AI model scores each company from 0 to 10 based on: Industry fit. Size/location alignment. Potential pain points that match your offering. If the company is new and relevant (score ≥ 7), it is saved in the Companies sheet. Decision Maker Identification Uses Sales Navigator API (via Ghost Genius) to find employees with targeted job titles. For each matching profile: Enriches contact data (title, bio, etc.). Retrieves phone number (if available). Generates a 20-second personalized cold call script using OpenAI, based on company and profile data. Saves all information in the Leads tab of the CRM. If no decision maker is found, the company status is marked accordingly. --- 📈 Outcome A fully enriched, qualified lead database. Custom cold call scripts ready to be used by SDRs or founders. Zero manual work – from search to lead generation, everything is automated. --- 💡 Use Case Perfect for SDRs, founders, or growth marketers looking to scale cold outreach without sacrificing personalization or running into LinkedIn scraping limits. ---
By MatthieuSearch LinkedIn companies and add them to Airtable CRM
Search LinkedIn companies and add them to Airtable CRM Who is this for? This template is ideal for sales teams, business development professionals, and marketers looking to build a robust prospect database without manual LinkedIn research. Perfect for agencies, consultants, and B2B companies targeting specific business profiles. What problem does this workflow solve? Manually researching companies on LinkedIn and adding them to your CRM is time-consuming and error-prone. This automation eliminates the tedious process of finding, qualifying, and importing prospects into your database. What this workflow does This workflow automatically searches for companies on LinkedIn based on your criteria (keywords, size, location), retrieves detailed information about each company, filters them based on quality indicators (follower count and website availability), and adds new companies to your Airtable CRM while preventing duplicates. Setup Create a Ghost Genius API account and get your API key Configure HTTP Request nodes with Header Auth credentials (Name: "Authorization", Value: "Bearer yourapikey") Create an Airtable base named "CRM" with columns: name, website, LinkedIn, id, etc. Set up your Airtable credentials following n8n documentation Add your company search selection criteria to the “Set Variables” node. How to customize this workflow Modify search parameters in the "Set Variables" node to target different industries, locations, or company sizes Adjust the follower count threshold in the "Filter Valid Companies" node based on your qualification criteria Customize the Airtable fields mapping in the "Add Company to CRM" node to match your database structure Add notification nodes (Slack, Email) to alert you when new companies are added
By MatthieuEnrich LinkedIn profiles with Ghost Genius and Google Sheets (no account needed)
LinkedIn Profile Enrichment Automation Who is this for? This template is perfect for sales teams, recruiters, marketing professionals, and business development specialists who need to gather comprehensive LinkedIn profile data at scale. Ideal for lead generation teams building prospect databases, recruiters sourcing candidate information, sales professionals researching prospects, and marketing teams creating targeted outreach campaigns. What problem does this workflow solve? Manually collecting detailed information from LinkedIn profiles is incredibly time-consuming and prone to inconsistency. Visiting each profile individually to extract names, job titles, experience, education, skills, and contact details can take hours for even small prospect lists. This automation eliminates the tedious manual data entry while ensuring consistent, comprehensive profile enrichment. What this workflow does This workflow automatically enriches a list of LinkedIn profile URLs by extracting comprehensive professional data including: Personal details (first name, last name, headline, location) Professional status (hiring status, open to work indicators) Network metrics (connections, followers count) Work experience (up to 5 most recent positions with company details, dates, and roles) Education background (up to 3 educational institutions with degrees and dates) Skills and languages (complete skill sets and language proficiencies) Professional summary (profile description and bio) The enriched data is automatically organized and updated in your Google Sheets database with structured formatting for easy analysis and outreach. Setup Create a Ghost Genius API account and obtain your API key for cookieless LinkedIn profile scraping Configure HTTP Request credentials with Header Auth using your Ghost Genius API key Set up your Google Sheets database using the provided template with columns: URL, Firstname, Lastname, Tagline, Location Connections, Followers, Hiring?, Open to work? Summary, Languages, Skills Experience 1-5, Education 1-3 Configure Google Sheets OAuth2 credentials following n8n's authentication setup guide Add LinkedIn profile URLs to the first column of your Google Sheet to begin enrichment Test the workflow with a small batch before processing larger lists How to customize this workflow Adjust batch processing settings to handle larger volumes by modifying the batch size and interval timing Add data validation rules to filter out incomplete or invalid profiles before processing Integrate with CRM systems like HubSpot or Salesforce to automatically sync enriched data Set up automated scheduling to regularly re-enrich profiles and capture profile updates Add email notifications to alert when enrichment batches are completed or encounter errors Customize data mapping to include additional profile fields or reorganize the output structure Add duplicate detection to prevent re-processing the same profiles multiple times
By Matthieu