Stop hunting for emails by hand. This flow reads LinkedIn profile links stored in a Google Sheet, finds contact details using an email finder service, and writes the results back into the sheet. Great for sales teams building clean prospect lists for outreach.

A scheduled trigger runs every few minutes. It pulls rows from Google Sheets, checks which records still need enrichment, then calls the Prospeo email finder with the LinkedIn URL and the row ID. The response is merged with the original row and mapped into clear fields like name, gender, email, skills, picture, and a success flag. Rows that do not match the rule are skipped through a no operation path, so you avoid double work and keep the data tidy.

Setup is simple. Connect your Google account, add your Prospeo API key, and match your column names to the fields used here. Expect faster list building, fewer errors, and better reply rates once valid emails replace missing data. Useful for SDR teams, recruiters, and small agencies that manage prospects in Google Sheets and need steady enrichment on a schedule.

• Scheduled checks run every few minutes to process new or incomplete rows.
• Reads prospect rows from Google Sheets and writes results back to the same sheet.
• Conditional check only processes rows that still need an email and have a LinkedIn URL.
• HTTP POST to Prospeo email finder sends the LinkedIn URL and row ID with an API key header.
• Merge step combines the API response with the original row to preserve context.
• Field mapping sets name, gender, email, skills, picture, and a success flag.
• No operation path safely skips records that do not meet the rules.

• Reduce manual work from 2 hours to 10 minutes per 100 profiles
• Streamline list enrichment by 80 percent with scheduled runs
• Improve data quality by 30 percent with structured fields
• Handle thousands of rows without extra effort
• Connect Google Sheets and Prospeo in one flow

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with Google Sheets and Prospeo. See the Tools Required section above for links to create accounts with these services.
3. In the n8n credentials manager, connect Google Sheets: double click the Google Sheets nodes, open the Credential to connect with menu, click Create new credential, then follow the on screen steps to sign in and grant access.
4. Open the Google Sheets Read node and select your spreadsheet and the correct sheet tab. Make sure the sheet contains columns for ID and LinkedIn URL that match your data.
5. Open the HTTP Request node and add your Prospeo API key: in Headers, set X-KEY to your key from the Prospeo account API page.
6. Confirm the body fields match your sheet: the url parameter should reference the LinkedIn URL column and the id parameter should reference the ID column. Rename columns in your sheet or adjust the expressions if needed.
7. Open the If node and set the rule so only rows with a LinkedIn URL and no email are processed. This avoids calling the API for records already enriched.
8. Check the Set node mappings for Name, Gender, Email, Skills, Picture, and Success. Adjust field names to match the response fields from your Prospeo plan if they differ.
9. Open the Google Sheets Update node and confirm the spreadsheet, tab, and column mappings. Use the update operation keyed by ID so the correct row is updated.
10. Set the Schedule Trigger to a safe interval based on your API limits. Start with every 5 to 15 minutes during business hours.
11. Test with a few rows: add 3 to 5 LinkedIn URLs with empty email cells, run the workflow once, and confirm that values appear in the sheet. If you see errors, check the API key, sheet permissions, column names, and that the Merge node has one input from the HTTP Request and one from the If node.