LinkedIn Lead Finder (from Sheet)

Automatically find and capture LinkedIn profiles based on target companies and job titles
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
Slack logo
Send message
5
repeat
Loop over a list
6
Google Sheets logo
Add row to sheet

Automate your lead generation by finding LinkedIn profiles for specific roles at target companies. Here's how it works:

  • The workflow starts when you add a new company row to your target companies sheet
  • It searches LinkedIn for people at that company with the specified job titles
  • An AI assistant formats the found profiles into a Slack message and sends it to you
  • Each profile is automatically saved to a leads sheet for future reference
1
Google Sheets logo
New row added

Monitors a Google Sheets spreadsheet for new rows containing target company information. Each new row triggers the workflow to process that company's data.

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

Searches LinkedIn to find people working at the specified company who match the job titles provided. Returns up to 10 profiles that meet the search criteria.

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

Uses AI to create a formatted Slack message listing all the found LinkedIn profiles with their names, titles, and profile URLs. The message includes the company information and removes any duplicate profiles.

Prompt used
Given a set of LinkedIn profiles, please write a nicely formatted Slack message that for each profile includes: - Name - Title - Profile URL (Linkify linkedin profile URL) Please remove any duplicates. At the top of the Slack message, include: "🌱 Connect with these profiles: [List of profiles] Company information: [data] [data]"
Relay.app screenshot of: Write with AI
4
Slack logo
Send message

Sends the formatted message containing the LinkedIn profiles as a direct message in Slack. The destination user should be configured when setting up the workflow.

Relay.app screenshot of: Send message
5
repeat
Loop over a list

Loops through each LinkedIn profile that was found in the search results. For each profile, it executes the steps within the loop to process and store the lead information.

Relay.app screenshot of: Loop over a list
Iterator steps
6
Google Sheets logo
Add row to sheet

Creates a new row in your leads spreadsheet with the profile's details including company name, person's name, job title, and LinkedIn URL. This builds your database of potential leads for outreach.

Relay.app screenshot of: Add row to sheet