LinkedIn Profile ICP Scoring Automation
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.
View Large Image
Workflow Overview
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.
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.
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.
- Manual Trigger: The workflow begins when the user clicks the ‘Test workflow’ button.
- Get Companies: It retrieves a list of companies from a specified Google Sheets document, including their LinkedIn URLs.
- 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.
- Format Response: The extracted data is formatted to include the row number, LinkedIn URL, and calculated ICP score.
- 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.