Automated LinkedIn Email Finder

This workflow is ideal for:

• Marketing Professionals: who want to enrich their leads with LinkedIn contact information efficiently.
• Data Analysts: looking to automate data gathering from various sources and update Google Sheets seamlessly.
• Recruiters: aiming to find and manage candidate information from LinkedIn profiles easily.
• Business Owners: who wish to maintain an updated contact list for outreach and networking purposes.

This workflow addresses the challenge of manually gathering and updating contact information from LinkedIn profiles. It automates the process by:

• Utilizing the Prospeo.io LinkedIn Email Finder API to obtain email addresses and other relevant data from LinkedIn URLs stored in a Google Sheet.
• Ensuring that only profiles with available LinkedIn URLs are processed, thus increasing efficiency and accuracy in data collection.

The workflow operates through the following steps:

1. Schedule Trigger: The workflow initiates based on a defined schedule (every few minutes).
2. Get links from Google Sheet: It retrieves LinkedIn URLs from a specified Google Sheet document.
3. Conditional Check: The workflow checks if the necessary fields (Name, Gender, Job Title, Summary) are empty while ensuring that the LinkedIn URL is present.
4. HTTP Request: If the conditions are met, it sends a POST request to the Prospeo.io LinkedIn Email Finder API with the LinkedIn URL and ID to fetch detailed profile information.
5. Data Merge: The response data is merged with the existing data structure.
6. Field Editing: The necessary fields are populated with the retrieved data (e.g., Name, Email, Gender, etc.).
7. Update the sheet with information: Finally, it updates the Google Sheet with the new information, ensuring that the contact list is current and comprehensive.