Search LinkedIn companies, Score with AI and add them to Google Sheet CRM

For LinkedIn, this automated workflow efficiently searches for target companies, evaluates their potential interest using AI scoring, and seamlessly adds them to your Google Sheet CRM. It processes up to 1000 companies per search, ensuring you capture valuable leads while maintaining data accuracy. By filtering for valid companies based on follower count and website presence, it enhances your outreach strategy, allowing for targeted engagement with qualified prospects.

7/8/2025
18 nodes
Complex
manualcomplexsplitinbatchessplitoutgooglesheetslangchainsticky notewaitadvancedapiintegrationlogicconditional
Categories:
Complex WorkflowManual TriggeredData Processing & Analysis
Integrations:
SplitInBatchesSplitOutGoogleSheetsLangChainSticky NoteWait

Target Audience

This workflow is designed for:
- Sales and Marketing Teams: Professionals looking to identify potential leads by analyzing companies on LinkedIn.
- Business Development Managers: Individuals responsible for expanding business opportunities through targeted outreach.
- Entrepreneurs and Startups: Founders seeking to connect with companies that may benefit from their products or services.
- Data Analysts: Those who want to automate the process of gathering and scoring company information for strategic insights.

Problem Solved

This workflow addresses the challenge of efficiently identifying and scoring potential leads from LinkedIn based on specific criteria. It automates the process of:
- Searching for companies that fit a desired profile (e.g., industry, size, location).
- Gathering detailed company information.
- Filtering out companies that do not meet certain thresholds (e.g., follower count).
- Scoring companies based on their likelihood of needing the user's products or services, thus enabling more effective targeting.

Workflow Steps

  • Trigger the Workflow: The process is initiated manually by the user.
    2. Set Variables: Users define parameters such as target keywords, company size, and location.
    3. Search Companies: The workflow queries the Ghost Genius API to find companies matching the specified criteria, retrieving up to 1000 companies per search.
    4. Extract Company Data: The workflow processes the response to isolate relevant company data.
    5. Get Company Info: For each company, detailed information is fetched using their LinkedIn URL.
    6. Filter Valid Companies: Companies are filtered based on criteria like having a website and a minimum follower count of 200.
    7. Check If Company Exists: The workflow checks against a Google Sheet to avoid duplicates.
    8. AI Company Scoring: Valid companies are scored on a scale of 0 to 10 based on their fit for the user's offerings.
    9. Add Company to CRM: Finally, the companies, along with their scores and details, are appended to a Google Sheet for further action.

    • Customization Guide

    Users can customize the workflow by:
    - Modifying Search Criteria: Change the target keywords, company size, and location in the "Set Variables" node to align with specific market needs.
    - Adjusting Filters: Update the follower count threshold or other filtering conditions in the "Filter Valid Companies" node to refine the selection process.
    - Personalizing AI Scoring: Edit the scoring criteria in the "AI Company Scoring" node to reflect the unique value proposition of their products or services.
    - Updating Google Sheet Structure: Adjust the fields in the "Add Company to CRM" node to match the desired data structure in their Google Sheet.