What This Workflow Does
This automation solves the challenge of manually evaluating hundreds of LinkedIn company profiles to identify your best potential customers. By automatically scoring companies against your ideal customer profile (ICP) criteria, your sales team can focus outreach on prospects with the highest conversion potential.
The workflow extracts key signals from LinkedIn company pages - including employee growth, tech stack mentions, funding status, and hiring trends - then applies your custom scoring model in Google Sheets via Airtop. Companies are ranked based on their fit, with color-coded visualizations highlighting your hottest leads.
How It Works
Step 1: LinkedIn Data Extraction
The workflow starts by pulling structured data from LinkedIn company profiles, including firmographics, growth metrics, and technology indicators that correlate with buying intent in your market.
Step 2: Google Sheets Integration
Company data flows into a centralized Google Sheet where your ICP scoring model lives. The sheet maintains historical data to track how companies' scores change over time.
Step 3: Airtop Scoring Engine
Airtop applies your weighted scoring rules to each company, calculating an overall ICP match score. You can adjust weights for different attributes (e.g., 2x points for using a competing product).
Step 4: Prioritization Dashboard
The final output is a prioritized list of companies with their complete scoring breakdown, enabling your team to tailor outreach based on each prospect's specific strengths as an ICP match.
Pro tip: Create separate scoring models for different product lines or customer segments. The workflow can run multiple scoring algorithms in parallel.
Who This Is For
This automation delivers the most value for B2B companies where:
- Your ideal customers have identifiable characteristics on LinkedIn
- You're evaluating hundreds of potential accounts
- Different company attributes indicate varying levels of fit
- Your team wastes time manually researching prospects
What You'll Need
- Airtop account (free tier available)
- Google Sheets (part of Google Workspace)
- LinkedIn Sales Navigator (recommended) or basic LinkedIn access
- Zapier account to connect the services
Quick Setup Guide
- Download the template JSON file
- Import into your Airtop account
- Connect your LinkedIn and Google Sheets accounts
- Customize the scoring weights in the Google Sheet
- Add your target company URLs or search criteria
- Run the workflow and review scored leads
Key Benefits
Focus on best-fit prospects first by automatically ranking companies based on your specific ICP criteria rather than gut feeling or superficial signals.
Reduce research time by 80% - what used to take hours of manual LinkedIn browsing now happens automatically with consistent scoring applied to every prospect.
Continuous prioritization as the workflow updates scores whenever new data appears on company profiles, ensuring your outreach list stays current.
Data-driven outreach with insights into why each company scored well, allowing personalized messaging that references their specific ICP match points.