LinkedIn Lead Enrichment

LinkedIn Lead Enrichment Workflow Overview This workflow automates the process of enriching a list of LinkedIn profile URLs with comprehensive professional data. It's designed for sales, marketing, and recruiting professionals who need to quickly gather detailed information on leads or candidates. The automation transforms a simple list of profile links in a Google Sheet into a rich dataset, saving countless hours of manual data entry and research. Technologies Used - n8n: The core automation platform coordinating the entire process. - Google Sheets: Used as a simple database to store the initial list of LinkedIn profiles and to be updated with the enriched data. - RapidAPI: A third-party API marketplace used to access the "Fresh LinkedIn Profile Data" API, which scrapes and provides the detailed profile information. Node-by-Node Analysis This workflow executes a logical sequence to efficiently fetch, process, and store data. H3: Start: Manual Trigger - Node: When clicking ‘Test workflow’ - Function: This is a manual trigger, meaning the workflow is initiated on-demand by the user. This is perfect for batch-processing a list of leads whenever the user decides it's necessary. It can easily be swapped with a scheduled trigger (e.g., "Run daily") for continuous enrichment. H3: 1. Pull Leads from Google Sheets - Node: Pull linkedin profiles - Function: The workflow begins by reading all rows from a specified Google Sheet. It's configured to pull from a sheet named "Linkedin contact info," which is expected to contain at least one column with the header linkedin_url. This node effectively imports the list of leads that need to be processed. H3: 2. Filter for Unenriched Leads - Node: Filter already enriched - Function: This node provides a critical efficiency boost. It checks each lead from the Google Sheet against two conditions: 1. The about column is empty. 2. The linkedin_url column is _not_ empty. - Value: This ensures the workflow only processes profiles that haven't been enriched yet.