n8n templatesn8n templates

Automated LinkedIn Contact Information Collection and Update Workflow

This workflow automates the collection and updating of LinkedIn contact information. It is triggered on a schedule to read personal profile URLs from Google Sheets, utilizes the Prospeo.io API to query detailed information (such as name, email, position, etc.), and writes the data back to Google Sheets. This process effectively addresses the tediousness of manually searching for contact information, enhances data completeness and accuracy, and simplifies data maintenance. It is suitable for scenarios where sales, business development, and recruitment teams need to quickly obtain contact information.

Workflow Diagram
Automated LinkedIn Contact Information Collection and Update Workflow Workflow diagram

Workflow Name

Automated LinkedIn Contact Information Collection and Update Workflow

Key Features and Highlights

This workflow is triggered on a scheduled basis to read LinkedIn profile URLs stored in Google Sheets. It leverages the Prospeo.io LinkedIn Email Finder API to automatically retrieve detailed contact information—including name, gender, email, job title, education background, skills, personal summary, location, and profile photo—and writes this enriched data back into the same Google Sheets spreadsheet. This enables automatic data completion and precise updates.

Core Problems Addressed

  • Eliminates the time-consuming and labor-intensive process of manually searching for LinkedIn contacts’ emails and related personal information
  • Significantly improves the completeness and accuracy of contact data
  • Simplifies data maintenance workflows, preventing communication barriers caused by missing information

Use Cases

  • Sales and business development teams needing efficient access to potential clients’ contact emails and detailed profiles
  • Recruitment teams aiming to quickly enrich candidate information databases
  • Data analysis and CRM systems requiring regular data updates and maintenance
  • Any scenario relying on LinkedIn contact information for business communication or client management

Main Process Steps

  1. Scheduled Trigger: Periodically initiates the workflow to ensure regular data updates
  2. Read LinkedIn URL List from Google Sheets
  3. Conditional Filtering: Select records that have LinkedIn URLs but lack key fields (e.g., name, gender, job title, summary)
  4. Call Prospeo.io LinkedIn Email Finder API: Send HTTP POST requests to retrieve detailed contact information
  5. Data Merging and Field Formatting: Integrate API response data and format it to match the spreadsheet’s required fields
  6. Update Google Sheets: Write the completed contact information back to the corresponding rows, achieving synchronized data updates
  7. No-Operation Node: Used for workflow branching control without performing any action

Systems and Services Involved

  • Google Sheets: For storing and managing LinkedIn URLs and contact information
  • Prospeo.io LinkedIn Email Finder API: Core data source for querying contact emails and detailed profiles
  • n8n Workflow Automation Platform: Used to build and execute the entire automated process

Target Users and Value

  • Business development, marketing, recruitment, and customer relationship management professionals
  • Teams requiring bulk, rapid acquisition and maintenance of LinkedIn contact data
  • Organizations seeking to automate information workflows, reduce manual repetitive work, and improve operational efficiency
  • Technical personnel aiming to build no-code or low-code automation workflows to optimize data management

This workflow greatly simplifies the collection and maintenance of contact information, enabling enterprises to stay updated on potential clients and candidates promptly, thereby enhancing communication efficiency and data quality.