LinkedIn Lead Finder (from Sheet)

Automatically find LinkedIn profiles based on company and job title data from Google Sheets
Created by
Relay.app logoRelay.app Team
Relay.app screenshot of: LinkedIn Lead Finder (from Sheet)

Steps in this workflow

1
Google Sheets logo
New row added
2
Relay.app logo
Find people based on company and role
3
Relay.app logo
Write with AI
4
Google Sheets logo
Update row
5
Slack logo
Send message

Automate your lead generation by finding relevant LinkedIn profiles based on company and job title data. Here's how it works:

  • The workflow activates when a new row is added to your Google Sheets
  • It searches for LinkedIn profiles matching the company name and job title from that row
  • AI formats the found profiles into a clean message with names, titles, and profile URLs
  • The original sheet row is updated with the formatted leads
  • A Slack direct message is sent with the formatted profile information
1
Google Sheets logo
New row added

Monitors a Google Sheet for new rows and triggers the workflow when one is detected. The trigger automatically reads the company name and job title data from the new row.

Relay.app screenshot of: New row added
2
Relay.app logo
Find people based on company and role

Searches LinkedIn to find profiles of people working at the specified company with the given job title. Returns up to 10 matching profiles with their professional information.

Relay.app screenshot of: Find people based on company and role
3
Write with AI

Uses AI to format the found LinkedIn profiles into a clean, readable message. The AI creates a formatted list including each person's name, job title, and profile URL while removing any duplicates.

Prompt used
Given a set of LinkedIn profiles, please write a nicely formatted Slack message that for each profile includes: - Name - Title - Profile URL Please remove any duplicates.
Relay.app screenshot of: Write with AI
4
Google Sheets logo
Update row

Updates the original row in Google Sheets with the formatted lead information. This allows you to keep track of which leads have been found for each company and job title combination.

Relay.app screenshot of: Update row
5
Slack logo
Send message

Sends the formatted lead information as a direct message in Slack. The message includes all the found profiles with their details, making it easy to review and connect with potential leads.

Relay.app screenshot of: Send message