ManualTrigger Automate

ManualTrigger Automate streamlines the process of extracting and scoring LinkedIn profile data. By integrating Airtop and Google Sheets, it allows users to manually trigger a workflow that retrieves essential information such as job title, employer, and AI interest level, calculates an ICP score, and updates the corresponding Google Sheets row. This enhances data accuracy and efficiency, enabling better decision-making based on comprehensive profile insights.

7/8/2025
5 nodes
Medium
manualmediumairtopgooglesheets
Categories:
Manual TriggeredData Processing & AnalysisMedium Workflow
Integrations:
AirtopGoogleSheets

Target Audience

Target Audience


- Recruiters looking to assess candidates' profiles efficiently.
- Sales Teams aiming to identify potential clients based on LinkedIn profiles.
- Marketing Professionals interested in understanding audience demographics and interests.
- Data Analysts who need to extract and analyze LinkedIn data for strategic insights.

Problem Solved

Problem Solved


This workflow automates the extraction of key information from LinkedIn profiles, addressing the challenge of manually gathering data for candidate evaluation or lead generation. It provides a structured approach to assess individuals based on their AI interest, technical depth, and seniority level, ultimately calculating an ICP Score that helps prioritize outreach efforts.

Workflow Steps

Workflow Steps


1. Manual Trigger: The workflow begins when the user clicks ‘Test workflow’ to initiate the process.
2. Get Person Data: It retrieves LinkedIn profile URLs and associated data from a Google Sheets document.
3. Calculate ICP Person Scoring: The workflow uses the Airtop integration to extract detailed information from each LinkedIn profile, including:
- Full Name
- Current Job Title
- Current Employer
- Location
- Connections and Followers
- About Section Text
- AI Interest Level, Seniority Level, and Technical Depth
- Finally, it calculates an ICP Score based on predefined criteria.
4. Format Response: The extracted data is formatted to include the row number, LinkedIn URL, and ICP Score for easy identification.
5. Update Row in Google Sheets: The final step updates the corresponding row in the Google Sheets document with the new ICP Score and any other relevant information.

Customization Guide

Customization Guide


- Modify Extraction Criteria: Users can adjust the extraction prompt in the Calculate ICP Person Scoring node to include or exclude specific data points based on their needs.
- Change Google Sheets Document: Update the documentId and sheetName parameters in the Get person and Update row nodes to connect to different Google Sheets.
- Adjust Scoring Criteria: Users can redefine the scoring criteria in the prompt section to reflect their unique assessment needs for AI interest, technical depth, and seniority.
- Add Additional Nodes: Users can expand the workflow by integrating additional nodes to further process or analyze the data after it has been extracted.