ICP Company Scoring

For Google Sheets, this automated workflow scores companies based on their LinkedIn profiles, providing a structured ICP score that evaluates their automation agency status, AI implementation level, and technical sophistication. It streamlines data extraction and updates scores directly in your spreadsheet, enhancing decision-making and targeting for business development.

7/4/2025
5 nodes
Medium
a8b9vqj0vnlxckvqmanualmediumgooglesheetsairtop
Categories:
Data Processing & AnalysisManual TriggeredMedium Workflow
Integrations:
GoogleSheetsAirtop

Target Audience

This workflow is designed for:
- Marketing Teams: Who need to analyze and score companies based on their LinkedIn profiles for targeted outreach.
- Sales Professionals: Looking for qualified leads by assessing company capabilities and potential fit.
- Business Analysts: Interested in gathering structured data from LinkedIn for market research and competitive analysis.
- Automation Enthusiasts: Who want to streamline the process of data extraction and scoring to save time and improve accuracy.

Problem Solved

This workflow addresses the challenge of manually extracting and analyzing company information from LinkedIn, which can be time-consuming and error-prone. By automating this process, it enables users to:
- Quickly gather essential company data in a structured format.
- Evaluate companies based on specific criteria, leading to better-informed business decisions.
- Save time and resources, allowing teams to focus on higher-value tasks.

Workflow Steps

  • Manual Trigger: The workflow begins when the user clicks the ‘Test workflow’ button.
    2. Get Companies: It retrieves a list of companies from a specified Google Sheets document, including their LinkedIn URLs.
    3. Calculate ICP Scoring: For each company, it sends a request to Airtop to analyze their LinkedIn page and extract relevant data points, such as:
    - Company identity
    - Scale (employee count)
    - Business classification (automation agency status, AI implementation level)
    - Funding profile
    - Ideal Customer Profile (ICP) score.
    4. Format Response: The extracted data is formatted to include the row number, LinkedIn URL, and calculated ICP score.
    5. Update Row: Finally, the workflow updates the original Google Sheets document with the new ICP score for each company, ensuring all data is current and accessible.

    • Customization Guide

    Users can customize this workflow by:
    - Modifying the Google Sheets Document: Change the document ID or sheet name to pull data from a different spreadsheet.
    - Adjusting the Airtop Query: Edit the prompt used in the ‘Calculate ICP Scoring’ node to include or exclude specific data points based on business needs.
    - Changing Scoring Criteria: Update the scoring logic in the Airtop prompt to reflect different weightings or categories relevant to the user's goals.
    - Adding Additional Nodes: Incorporate more nodes for further processing, such as sending notifications or integrating with other tools like CRM systems.