LinkedIn company ICP scoring automation with Airtop & Google Sheets

About The ICP Company 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 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 Company score Company ICP Scoring Workflow Our company-focused workflow analyzes company LinkedIn profiles with a comprehensive set of criteria: - Company Identity Extraction - Company Scale Assessment - Business Classification - Technical Sophistication Assessment - Investment Profile To then calculate the ICP Scoring, it will focus on: - AI Implementation Level: Low-5 pts, Medium-10 pts, High-25 pts - Technical Sophistication: Basic-5 pts, Intermediate-15 pts, Advanced-25 pts, Expert-35 pts - Employee Count: 0-9 employees-5 pts, 10-150 employees-25 pts, 150+ employees-30 pts - Automation Agency Status: True-20 pts, False-0 pts - Geography: US/Europe Based-10 pts, Other-0 pts Setting Up Your Automation We've created ready-to-use templates for both person and company ICP scoring. 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 LinkedinURLCompany and ICPScoreCompany 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 company 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 refi