Find each person's public profile page

Give it a sheet of people with a name and a company each, and run it to look up the next batch. Each person gets one web search restricted to the profile site you name, the AI picks the result that is genuinely their own page, and what was found is written to a separate results tab.

Each row holds the profile address, whether it was found, the exact search used, a note and the date. No address is ever built or guessed. The only value that can reach the 'Profile URL' column is one the search itself returned, and it must match a result exactly and sit on the site you named. When nothing can be confirmed the cell is left empty and the note says why. Nobody is looked up twice: anyone already on the results tab is skipped, rows are only ever appended, and a row missing a name or company is reported and skipped.

Before the first run you need a tab with 'Name' and 'Company' columns and an empty tab for the results, which gets its header row on the first run.

Set spreadsheetUrl to blank.Set spreadsheetUrl to blank.

Set peopleSheetName to blank.Set peopleSheetName to blank.

Set resultsSheetName to blank.Set resultsSheetName to blank.

Set profileSite to blank.Set profileSite to blank.

Set maxPeople to 10.Set maxPeople to 10.

Make profileSite lowercase and save it as siteHostRaw.Make profileSite lowercase and save it as siteHostRaw.

Get the first item of the last item of siteHostRaw split by :// split by / and save it as siteHost.Get the first item of the last item of siteHostRaw split by :// split by / and save it as siteHost.

If siteHost is emptyIf siteHost is empty

Yes

Stop and report a problem: 'profileSite' does not look like a web address. Write just the site, for example linkedin.com.Stop and report a problem: 'profileSite' does not look like a web address. Write just the site, for example linkedin.com.

No

No steps

Google SheetsRead the rows of spreadsheetUrl. Save it as record.Read the rows of spreadsheetUrl. Save it as record.

Set recordHeaders to record.headers.Set recordHeaders to record.headers.

Set recordRows to record.rows.Set recordRows to record.rows.

If recordHeaders is emptyIf recordHeaders is empty

Yes

Google SheetsAdd a row to resultsSheetName in spreadsheetUrl.Add a row to resultsSheetName in spreadsheetUrl.

No

No steps

Set alreadyLookedUp to an empty list.Set alreadyLookedUp to an empty list.

For each recordRow in recordRows:For each recordRow in recordRows:

If a step below fails, save the error as recordErrorIf a step below fails, save the error as recordError

Try

Set recordKey to recordRow.Name in lowercase @ recordRow.Company in lowercase.Set recordKey to recordRow.Name in lowercase @ recordRow.Company in lowercase.

Add recordKey to the end of alreadyLookedUp and save it as alreadyLookedUp.Add recordKey to the end of alreadyLookedUp and save it as alreadyLookedUp.

On error

Show in the output: Ignored a row already on the record that has no Name and Company: recordError as text.Show in the output: Ignored a row already on the record that has no Name and Company: recordError as text.

Google SheetsRead the rows of spreadsheetUrl. Save it as people.Read the rows of spreadsheetUrl. Save it as people.

Set peopleRows to people.rows.Set peopleRows to people.rows.

Set checkedCount to 0.Set checkedCount to 0.

Set foundCount to 0.Set foundCount to 0.

For each person in peopleRows:For each person in peopleRows:

If checkedCount multiplied by 1 is greater than or equal to maxPeople multiplied…If checkedCount multiplied by 1 is greater than or equal to maxPeople multiplied…

Yes

Stop repeating.Stop repeating.

No

No steps

If a step below fails, save the error as personErrorIf a step below fails, save the error as personError

Try

Trim person.Name and save it as personName.Trim person.Name and save it as personName.

Trim person.Company and save it as personCompany.Trim person.Company and save it as personCompany.

Set personKey to personName in lowercase @ personCompany in lowercase.Set personKey to personName in lowercase @ personCompany in lowercase.

If personName is empty or personCompany is emptyIf personName is empty or personCompany is empty

Yes

Show in the output: Skipped a row that does not have both a Name and a Company..Show in the output: Skipped a row that does not have both a Name and a Company..

Else if @alreadyLookedUp contains @personKey

Show in the output: Already on the record, so not looked up again: personKey.Show in the output: Already on the record, so not looked up again: personKey.

Otherwise

Set searchUsed to @personName @personCompany site:siteHost.Set searchUsed to @personName @personCompany site:siteHost.

SerperSearch Google for searchUsed. Save it as searchResult.Search Google for searchUsed. Save it as searchResult.

Set hits to searchResult.results.Set hits to searchResult.results.

Set linkList to an empty list.Set linkList to an empty list.

Set optionsText to blank.Set optionsText to blank.

For each hit in hits:For each hit in hits:

If a step below fails, save the error as hitError If a step below fails, save the error as hitError

Try

Trim hit.link and save it as hitLink.Trim hit.link and save it as hitLink.

If hitLink is nullIf hitLink is null

Yes

Change hitLink to blank.Change hitLink to blank.

No

No steps

Trim hit.title and save it as hitTitle.Trim hit.title and save it as hitTitle.

If hitTitle is nullIf hitTitle is null

Yes

Change hitTitle to blank.Change hitTitle to blank.

No

No steps

Trim hit.snippet and save it as hitSnippet.Trim hit.snippet and save it as hitSnippet.

If hitSnippet is nullIf hitSnippet is null

Yes

Change hitSnippet to blank.Change hitSnippet to blank.

No

No steps

Set hitText to hitTitle hitSnippet.Set hitText to hitTitle hitSnippet.

If hitLink isn't empty and hitText contains personName (ignoring case)If hitLink isn't empty and hitText contains personName (ignoring case)

Yes

Add hitLink to the end of linkList and save it as linkList.Add hitLink to the end of linkList and save it as linkList.

Change optionsText to optionsText@hitLink - hitTitleChange optionsText to optionsText@hitLink - hitTitle .

No

No steps

On error

Show in the output: Skipped a search result that could not be read: hitError as text.Show in the output: Skipped a search result that could not be read: hitError as text.

Set profileUrl to blank.Set profileUrl to blank.

Set lookupNote to No page in the search results could be confirmed as this person's own profile, so the Profile URL was left empty..Set lookupNote to No page in the search results could be confirmed as this person's own profile, so the Profile URL was left empty..

If linkList isn't emptyIf linkList isn't empty

Yes

Set promptIntro to You are matching one person to their own public profile page.Set promptIntro to You are matching one person to their own public profile page. Person: personName Company: personCompany .

ClaudeAsk Claude: '@promptIntroBelow are the pages a web search returned, one per line, each with its title.Ask Claude: '@promptIntroBelow are the pages a web search returned, one per line, each with its title. Reply with EXACTLY one address, copied character for character from that list, and only if that page is this person's own profile page at that company. If none of them is, or you cannot tell, reply with the single word NONE. Never write an address that is not in the list. Never guess, complete, shorten or tidy an address. Never build one out of the person's name. Answering NONE is always better than answering with a page that might belong to somebody else. Search results: optionsText'. Save it as verdict. Maximum response length: 200

Trim verdict.response_text and save it as candidate.Trim verdict.response_text and save it as candidate.

Make candidate lowercase and save it as candidateLower.Make candidate lowercase and save it as candidateLower.

Check whether linkList includes candidate and save it as cameFromResults.Check whether linkList includes candidate and save it as cameFromResults.

Get the first item of the last item of candidateLower split by :// split by / and save it as candidateHost.Get the first item of the last item of candidateLower split by :// split by / and save it as candidateHost.

Set hostMatches to candidateHost is siteHost or candidateHost ends with .@siteHost.Set hostMatches to candidateHost is siteHost or candidateHost ends with .@siteHost.

Set schemeOk to candidateLower starts with https:// or candidateLower starts with http://.Set schemeOk to candidateLower starts with https:// or candidateLower starts with http://.

If cameFromResults is yes and schemeOk is yes and hostMatches is yesIf cameFromResults is yes and schemeOk is yes and hostMatches is yes

Yes

Change profileUrl to candidate.Change profileUrl to candidate.

Change lookupNote to Matched to a page this search returned..Change lookupNote to Matched to a page this search returned..

No

No steps

No

Change lookupNote to The search returned no page on siteHost that mentions this person by name.Change lookupNote to The search returned no page on siteHost that mentions this person by name.

Set foundFlag to no.Set foundFlag to no.

If profileUrl isn't emptyIf profileUrl isn't empty

Yes

Change foundFlag to yes.Change foundFlag to yes.

Add 1 to foundCount.Add 1 to foundCount.

No

No steps

Google SheetsAdd a row to resultsSheetName in spreadsheetUrl.Add a row to resultsSheetName in spreadsheetUrl.

Add personKey to the end of alreadyLookedUp and save it as alreadyLookedUp.Add personKey to the end of alreadyLookedUp and save it as alreadyLookedUp.

Add 1 to checkedCount.Add 1 to checkedCount.

On error

Show in the output: Skipped a row that could not be read: personError as text.Show in the output: Skipped a row that could not be read: personError as text.

Show in the output: Looked up checkedCount as text people and found a profile page for foundCount as text. Every result is on the '@resultsSheetName' tab.Show in the output: Looked up checkedCount as text people and found a profile page for foundCount as text. Every result is on the '@resultsSheetName' tab.