Enrich Linkedin profile URLs stored in a Google Sheet

Template Information

Who is this template for? This template is for users looking to retrieve email information from LinkedIn profiles and update Google Sheets with the collected data.

- [ 🎥 quick set up video](https://www.canva.com/design/DAF9aUBxWY/xSSlSUzRdxCPtfgx9RzGSg/watch?utmcontent=DAF9aUBxWY&utmcampaign=designshare&utmmedium=link&utmsource=editor)

- How it works - The template utilizes a series of nodes to fetch email information from LinkedIn profiles. It starts with a Schedule Trigger node that sets the interval for the workflow. The Conditional Check node verifies if certain fields like Name, Gender, Job Title, Summary, and LinkedIn URL are not empty. The HTTP Request node sends a POST request to the specified URL with API key and profile information. The Data Merge node merges the data collected. The Field Editing node modifies the fields as needed. Finally, the Google Sheets Update node updates the Google Sheets with the gathered information.

Set Up Instructions

1. Make sure to have the necessary credentials and permissions for accessing LinkedIn and Google Sheets. 2. Set up the API key required for the HTTP Request node. 3. Configure the Google Sheets Update node with the appropriate document ID and sheet name. 4. Check and adjust field mappings in the Field Editing node according to your needs. 5. Run the workflow and monitor the updates in your Google Sheets document.

Overview:

The workflow is designed to find contact information for LinkedIn profile URLs stored in a Google Sheet. It involves various nodes for different operations such as making HTTP requests, scheduling triggers, reading from and updating Google Sheets, field editing, data merging, and conditional checks. A video demonstrating the workflow process can be accessed [here](https://www.canva.com/design/DAF9aUBxWY/xSSlSUzRdxCPtfgx9RzGSg/watch?success=true&continueinbrowser=true).