🎣 Enrich Linkedin profile URLs stored in a Google Sheet
⚡ 6,714 views · 🎣 Lead Generation & Enrichment
💡 Pro Tip — If you’re pulling LinkedIn data through HTTP requests or dealing with API restrictions, there’s a community node called ScraperNode that handles this natively. It has dedicated scrapers for profiles, companies, jobs, and people search — you just pass a URL and get structured data back.
Description
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.
-
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
- Make sure to have the necessary credentials and permissions for accessing LinkedIn and Google Sheets.
- Set up the API key required for the HTTP Request node.
- Configure the Google Sheets Update node with the appropriate document ID and sheet name.
- Check and adjust field mappings in the Field Editing node according to your needs.
- 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.
Copy this template to get started :
Using Prospeo.io LinkedIn Email Finder API with cURL
To use the API endpoint “https://api.prospeo.io/linkedin-email-finder” with cURL, follow these steps:
- Use the cURL command with the following parameters:
curl -X POST \
-H "Content-Type: application/json" \
-H "X-KEY: your_api_key" \
-d '{
"url": "https://www.linkedin.com/in/john-doe/"
}' \
"https://api.prospeo.io/linkedin-email-finder"- Replace “your_api_key” with your actual API key.
- Update the “url” field in the JSON data with the LinkedIn profile URL for which you want to find the email address.
To get access to this API and obtain your API key, you need to sign up on the Prospeo platform and subscribe to their LinkedIn email finder service. Once you have subscribed, you will receive an API key that you can use to authenticate your requests to the API endpoint.
Description:
-
Schedule Trigger:
- Triggers the workflow based on a defined schedule interval, in this case, based on minutes.
- Schedule Trigger Node Documentation
-
Google Sheets Read:
- Reads data from a Google Sheets document and sheet based on the provided document ID and sheet name.
- Google Sheets Node Documentation
-
Conditional Check:
- Checks multiple conditions based on the input data and performs actions accordingly.
- Conditional Node Documentation
-
HTTP Request:
- Sends an HTTP POST request to a specified URL with headers and body parameters.
- HTTP Request Node Documentation
-
No Operation, do nothing:
- Placeholder node that does not perform any operation.
-
Data Merge:
- Merges data based on specified mode and combination settings.
- Merge Node Documentation
-
Field Editing:
- Edits fields by setting specific values for each field based on input data.
- Set Node Documentation
-
Google Sheets Update:
- Updates data in a Google Sheets document and sheet based on specified columns and values.
- Google Sheets Node Documentation
🔗 Nodes Used
Google Sheets, HTTP Request, Schedule Trigger
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File