Fill in what each company sells, and who to
Reads each company in your sheet from its own web page and records what it sells and who to, with the page it read.
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 see which companies are done, then the companies tab for names and any website given.
For each
rowIf
pageUrlis empty- 2SerperSearch webSearches the web for the company's official website when no address is given in the sheet.
- 2
If
pageUrlis empty- 3Google SheetsAppend rowAppends one row per company to the research tab: what it sells, who to, the evidence, source page and a note.
Otherwise
- 4Jina AIRead urlReads the text of the company's own web page, the only material the research is allowed to draw on.
If the length of
pageTextis less than 200- 5Google SheetsAppend row
Otherwise
- 6AnthropicGenerate model responseAsks the AI whether the page sells to businesses, consumers or both, plus the supporting phrase, industry, audience and offer.
- 7Google SheetsAppend row
- 5
- 3
How it works
What happens on each run, in plain English.
Every day, the next few companies in your Google Sheet are taken in turn, each one's own web page is found and read, and what that page says the company sells and who it sells to is recorded on a separate tab. Companies already on the results tab are skipped, so it picks up where it left off and your list itself is never overwritten.
Each result row holds whether the company sells to businesses, consumers or both, the phrase from the page that supports that, the industry, who they serve, what they offer, and the address of the page read. These are observations, not verdicts: nothing comes from what the AI already knows about a company, so if the page does not say something that cell is left empty, and a company with no readable page gets a row with every research column blank and a note saying so.
Before the first run you need a tab named 'Companies' with a 'Company' column and optionally a 'Website' column, and a tab named 'Company research' for the results.
You May Also Be Interested In
Open a cold email on something they actually publishedReads a page each prospect has published and opens their email on a line checked back against that page, or on nothing at all.Find each person's public profile pageTurns a name and a company into that person's profile page address, using only pages a web search actually returned.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.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 "Fill in what each company sells, and who to" to your workspace, connect its apps, and make it yours. No credit card required.
Free plan available · No credit card required