LinkedIn person ICP scoring automation with Airtop & Google Sheets

About The ICP Person Scoring Automation Sorting through lists of potential leads manually to determine who's truly worth your sales team's time isn't just tedious, it's incredibly inefficient. Without proper qualification, your team might spend hours pursuing prospects who aren't the right fit for your product, while ideal customers slip through the cracks. How to Automate Identifying Your Ideal Customers With this automation, you'll learn how to automatically score and prioritize leads using data extracted directly from LinkedIn profiles via Airtop's built-in integration with n8n. By the end, you'll have a fully automated workflow that analyzes prospects and calculates an Ideal Customer Profile (ICP) score, helping your sales team focus on high-potential opportunities. What You'll Need - A free Airtop API key - A copy of this Google Sheets Understanding the Process This automation transforms how you qualify and prioritize leads by extracting real-time, accurate information directly from LinkedIn profiles. Unlike static databases that quickly become outdated, this workflow taps into the most current professional information available. The workflow in this template: - Uses Airtop to extract comprehensive LinkedIn profile data - Analyzes the data to calculate an ICP score based on AI interest, technical depth, and seniority - Updates your Google Sheet with the enriched data and the ICP score Person ICP Scoring Workflow Our person-focused workflow evaluates individual LinkedIn profiles to determine how well they match your ideal customer profile by: - Extracting data for each individual - Analyzing their profile to determine seniority and technical depth The system then automatically calculates an ICP score based on the following criteria: - AI Interest: beginner-5 pts, intermediate-10 pts, advanced-25 pts, expert-35 pts - Technical Depth: basic-5 pts, intermediate-15 pts, advanced-25 pts, expert-35 pts - Seniority Level: junior-5 pts, mid-level-15 pts, senior-25 pts, executive-30 pts Setting Up Your Automation Here's how to get started: Configure your connections - Connect your Google Sheets account - Add your Airtop API key (obtain from the Airtop dashboard) Set up your Google Sheet - Ensure your Google Sheet has the necessary columns for input data and result fields - Ensure that columns LinkedinURLPerson and ICPScorePerson exist at least Configure the Airtop module - Set up the Airtop module to use the appropriate LinkedIn extraction prompt - Use our provided prompt that extracts individual profile data Customization Options While our templates work out of the box, you might want to customize them for your specific needs: - Modify the ICP scoring criteria: Adjust the point values or add additional criteria specific to your business - Add notification triggers: Set up Slack or email notifications for high-value leads that exceed a certain ICP threshold - Implement batch processing: Modify the workflow to process leads in batches to optimize performance - Add conditional logic: Create different scoring models for different industries or product lines - Integrate with your CRM: Integrate this automation with your preferred CRM to get the details added automatically for you Real-World Applications Here's how businesses are using this automation: AI Sales Platform: A B2B AI company could implement this workflow to process their trade show lead list of contacts. Within hours, they can identify the top 50 prospects based on ICP score. SaaS Analytics Tool: A SaaS company could implement LinkedIn enrichment to identify which companies fit best. The automation processes weekly leads and categorizes them into high, medium, and low priority tiers, allowing their sales team to focus on the most promising opportunities first. Best Practices To get the most out of this automation: - Review and refine your ICP criteria quarterly: What constitutes an ideal customer may evolve as your product and market develop - Create tiered follow-up processes: Develop different outreach strategies based on ICP score ranges - Perform regular data validation: Periodically check the accuracy of the automated scoring against your actual sales results What's Next? Now that you've automated your ICP scoring with LinkedIn data, you might be interested in: - Setting up automated outreach sequences based on ICP score thresholds - Creating custom reporting dashboards to track conversion rates by ICP segment - Expanding your scoring model to include additional data sources - Implementing lead assignment automation based on ICP scores Happy automating!