← all playbooks

Add the LinkedIn profile URL to a list of names and companies

Your list with a LinkedIn profile URL on each row where one person clearly matched, marked with how the match was made. Rows where several people could be the match come back as ambiguous with the profiles listed, not with a guess filled in.

use when
your rows have a name and an employer, or only an email, and no LinkedIn profile link to match them on
starts from
A list

The prompt

Paste it into Claude Code or the Claude desktop app with Hyreflow connected. The first line tells your agent to use Hyreflow, so it reads the play, asks before it spends anything, and hands the work back to you.

paste this into Claude
Use hyreflow and find the LinkedIn profile URL for each person on this list.

The list is <FILE_PATH_OR_PASTED_ROWS>. Most rows have <NAME_AND_EMPLOYER>
and some have only <AN_EMAIL_ADDRESS>. I want one column added: the LinkedIn
profile URL. No emails, no phone numbers.

How I want it run:
- Skip any row that already has a profile URL.
- Before you spend anything, tell me which lookup you will use for which
  rows, in what order, and which of them charge when they find nothing.
- Use <TITLE_OR_CITY_COLUMN> to tell people with the same name apart.
- Only fill in a URL when one person clearly matches the name and the
  employer. If two or more people could be the match, do not pick one.
  Mark the row ambiguous and list the profiles you found.
- Mark how each URL was matched: on an email, on name and employer, or by
  web search.

Run five rows first and tell me what the full run costs before you do the
rest. Wait for my go-ahead.

Give me back my list with the URL column and a status on every row. Do not
contact anyone and do not load it anywhere.

Replace every <PLACEHOLDER> with your own detail. Everything else can stay as written.

What you need first

  • The list as a CSV or spreadsheet export, with first name, last name and employer, or an email address, on each row
  • Anything that tells two people with one name apart: job title, city, or the company's web domain
  • A Hyreflow workspace with credits, or your own provider keys connected

Tools it can reach for

The agent picks per step from what your workspace has. Nothing here is required by name.

What happens when you run it

Free steps are marked free. Anything that spends credits is marked, and the agent asks before the first paid run of any size.

  1. 1

    Read the list and sort rows by what they hold

    free

    The agent counts three groups: rows with an email, rows with a name and an employer, and rows with neither. Rows that already carry a profile URL are skipped, and rows with neither are marked as unmatchable before anything is spent.

  2. 2

    State which lookup each group gets

    free

    There is no single chain for this job, so the agent picks the lookup by what the row holds and tells you the plan: which providers, in what order, and which of them charge when they find nothing.

  3. 3

    Pilot five rows and price the run

    credits

    Five rows run end to end, chosen across the groups, so you see real matches and real cost. The agent then states the most the full list could cost and waits for your go-ahead.

  4. 4

    Resolve the rows that carry an email

    credits

    An email address points at one person, so these are the strongest matches. Three providers can turn an address into a profile. Two of them bill only when a profile is found and one bills for the lookup either way, so the agent says which it will use.

  5. 5

    Resolve the rows with a name and an employer

    credits

    The person is looked up by name and employer, or name and company domain. The answer carries the profile URL together with their current title and employer, and a lookup that finds nobody is not charged.

  6. 6

    Search the web for the ones still missing

    credits

    A search of public profiles for the quoted name, the employer and the role. Each search is charged whether or not it finds anything, and a bare name with no employer is not searched at all, because it matches the wrong person too often.

  7. 7

    Accept clear matches and report the rest

    free

    A URL is filled in only when the profile's name and employer agree with the row. Several possible people, or a profile at a different employer, come back as ambiguous or as a weak match with the profiles listed. Nothing is picked for you.

  8. 8

    Hand the list back

    free

    A copy of your list with the URL column, how each URL was matched and what each row cost. Your original is left untouched and nothing is written to any other system.

What a run costs

Credits are spent per record the play actually works, and a lookup that finds nothing usually costs nothing. The two figures are the run where the first provider answers and the run where every lookup walks its full chain.

recordsif the first provider answersif every lookup walks the chain
25$4.747 credits$14140 credits
100$18180 credits$50500 credits
500$90900 credits$2422420 credits
1,000$1801800 credits$4824820 credits

Free before anything is charged

  • Read the list and sort rows by what they hold
  • State which lookup each group gets
  • Accept clear matches and report the rest
  • Hand the list back

What moves the number

  • How many records survive the free filters. Everything dropped before the paid steps costs nothing.
  • Providers you connect with your own key. Those calls bill your account, not your credits.

An estimate, not a quote, priced at the volume credit rate. Your agent sizes the run against your own workspace and tells you what it will cost before it spends anything.

The profile URL is what turns a name into one person

A name and an employer describe a person. They do not identify one. Large companies have several people with the same name, employers get spelled three ways in one sheet, and every lookup you run on a row like that inherits the doubt. A LinkedIn profile URL ends it. It points at one person, and it is the key that email, mobile and work-history lookups all match best on.

That makes this worth doing as its own job, before you buy any contact data. It also sets the rule. A wrong URL is worse than a missing one, because everything you look up afterwards belongs to somebody else and nothing on the sheet tells you. So a URL is filled in only when one person clearly matches. When two could, you get both, and the agent does not choose.

There is no single chain for this. The agent picks the lookup by what the row holds. An email goes to a provider that resolves an address to a profile. A name and an employer go to a person lookup. What is left goes to a web search of public profiles: quoted name, employer and role.

What you get back

Your list with a profile URL column and a match column beside it: matched on email, matched on name and employer, found by web search, weak match, ambiguous, or not found. Ambiguous rows list the profiles that could be the person, with what the result says about each, so settling one takes a single look.

Nothing is written to your CRM and nobody is contacted.

Variations worth knowing

Keep the work history. The name and employer lookup returns dated work history in the same answer. Say up front if you want it kept. Asking later is a second charge for the same person.

Records in your CRM. Clean and refresh your database runs this on a segment of your own records, pairs up duplicates and writes back what you approve.

Then get the contact details. With URLs on the rows, get emails and mobiles for a list you already have has the strongest identifier it can be given.

Where this goes wrong

Common names. A common name at a large employer, with no title or city on the row, often comes back ambiguous. Add the column that tells them apart, or accept the empty cells.

An employer they have left. The match looks for the person at the company on your row. If they moved on, the lookup may find nobody, or find them shown at a different employer. That is reported as a weak match for you to confirm, not filled in.

Trusting a search hit. A web search result is a lead. It is accepted only when the name, employer and role on the result agree with the row, and it is marked so you can check those rows first.

Questions

Why does the profile URL matter if what I want is an email or a mobile?

Because it is the key those lookups match best on. A name and an employer can describe several people, and employers get spelled three ways in one sheet. A profile URL points at one person. Some lookups accept nothing else: the first provider in the personal-email chain works from a profile URL only, and so do most of the providers that return dated work history. Putting the URL on the row first makes everything you buy afterwards more likely to be about the right person.

What happens with a common name?

It is reported, not guessed. If the search turns up two people with that name at that employer, the row comes back as ambiguous with both profiles and what the results say about each, and the URL cell stays empty. If a lookup returns one person whose employer or title does not fit your row, that comes back as a weak match for you to confirm. A job title or a city on your row usually settles it, which is why the agent asks for that column. A wrong URL is worse than an empty cell, because every later lookup on that row then returns a stranger's details.

Do I pay for the rows that are not found?

It depends on the lookup. The name and employer lookup bills only when it finds the person, and so do two of the three email lookups. The third email lookup and the web searches bill per lookup, found or not. The agent tells you which is which before the run, and the five-row pilot shows what each kind of row was really charged.

Can it work from a personal email address?

Yes, for some rows. Two of the email lookups accept a personal address as well as a work one. A work address usually resolves better, because it ties the person to an employer. An address from a job the person left long ago may resolve to nobody, or to the right person shown at the old employer, and that comes back marked as a weak match.

Does the lookup return anything else I should keep?

The name and employer lookup returns the person's current title and dated work history in the same answer, and for client contacts it can return a work email as well. Say at the start if you want either kept. Asking for it later on the same person is charged as a second lookup. On a candidate list the work email is never kept, because a candidate's work email is not a channel you should use.