Find each person's public profile page
Turns a name and a company into that person's profile page address, using only pages a web search actually returned.
Apps it connects
Authenticate each one once and the workflow is ready to run.
What it does
Each integration step this workflow runs, in order, what it is for, and the conditions and loops that decide when it runs.
- 1Google SheetsRead rowsReads the results tab to skip anyone already looked up, then reads the people tab for names and companies.
If
recordHeadersis empty- 2Google SheetsAppend rowWrites the header row into an empty results tab, then appends one row per person with the address, outcome and note.
- 2
For each
personIf
personNameis not empty,personCompanyis not empty andalreadyLookedUpdoes not includepersonKey- 3SerperSearch webRuns one web search per person for their name and company, restricted to the profile site you named.
If
linkListis not empty- 4AnthropicGenerate model responseAsks the AI to pick the one result that is this person's own profile page, or to answer that none is.
- 4
- 5Google SheetsAppend row
- 3
How it works
What happens on each run, in plain English.
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.
You May Also Be Interested In
Fill in what each company sells, and who toReads each company in your sheet from its own web page and records what it sells and who to, with the page it read.
Extract purchase orders from GmailReads each new purchase order email, looks its items up in your product list, and logs every line with name and price.
Parse emailed CVs into a talent sheetReads each job application that lands in Gmail, adds the candidate's details as a row in your Google Sheet and tells your team in Slack.Drip helpful articles to your leadsEvery day, emails the next few leads in your sheet a random article with a short AI note, and comes back to each after a set gap.
Start from a workflow that already works.
Add "Find each person's public profile page" to your workspace, connect its apps, and make it yours. No credit card required.
Free plan available · No credit card required