Find each person's public profile page

You have a list of people - a name and the company they work at - and you want the address of each one's public profile page. This works down that list, runs one site-restricted web search per person, and writes what it found onto a separate record tab.

It never builds an address. The only value that can ever reach the 'Profile URL' column is one the search itself returned: the candidates are collected from the results, only results that mention the person by name are offered, and the chosen address has to match one of them character for character and sit on the site you named before it is written. Guessing a profile from somebody's name is wrong for real people, so when nothing can be confirmed the cell is left empty and the Note column says why.

Nobody is looked up twice. Before searching it reads the record tab and skips any name-and-company pair already there, so you can leave it on a schedule and it walks steadily down a long list. Rows are only ever appended - nothing in your sheet is overwritten. A person whose page was not found stays on the record as 'Found: no'; delete that row if you want it tried again.

Setup: 1. Connect Google Sheets, Serper and Anthropic. 2. Put your people on one tab with the exact column headers Name and Company. Column names cannot be configured from a workflow, so they have to match. 3. Fill in 'spreadsheetUrl', 'peopleSheetName' (the tab your people are on), 'resultsSheetName' (the tab results go to) and 'profileSite' (the site to search, for example linkedin.com). 4. 'maxPeople' is how many people one run may look up; 10 by default.

The workflow writes its own header row - Name, Company, Profile URL, Found, Search used, Note, Checked - into an empty results tab, and reads back the Name and Company columns by those names.