Open a cold email on something they actually published
Reads a page each prospect has published and opens their email on a line checked back against that page, or on nothing at all.
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 SheetsCreate tabCreates the sent log tab in your sheet on the first run, so later runs can see who has already been emailed.
If
sentLogIsNew- 2Google SheetsAppend rowWrites the log headings when the tab is new, then records each recipient, opening line and evidence before the email goes out.
- 2
- 3Google SheetsRead columnReads the addresses already on the sent log so anyone recorded there is skipped rather than emailed twice.
- 4Google SheetsRead rowsReads your prospect tab and skips any row without a valid email address, a company or an https page link.
For each
row- 5Jina AIRead urlFetches the text of the page each prospect published, so the opening line can be written and checked against it.
If the length of
pageTextis at least 400- 6AnthropicGenerate model responseAsks the AI for an opening line and the page passage behind it, then for a short first email around that line.
- 6
- 7AnthropicGenerate model response
- 8Google SheetsAppend row
- 9GmailSendSends each checked draft to its prospect with your sign-off and opt-out line appended, only after the send is logged.
- 5
How it works
What happens on each run, in plain English.
Give it a sheet of prospects, each with a link to something they have published, and run it by hand. Each page is read, the AI writes an opening line about something that page actually says and a short first email around it, and the email goes out from Gmail with your sign-off and opt-out line added.
Every opening line has to come with the exact passage of the page it rests on, and that passage is matched back against the page. If it is not there, or the line uses a figure the page never mentions, the email opens on a plain sentence that claims nothing. A draft that implies you have spoken before, or states a figure found neither on the page nor in your own words, is discarded rather than sent. Each send is logged before it goes out and every address is checked against that log first, so nobody is emailed twice.
Your prospect tab needs 'Email', 'Name', 'Company' and 'Page URL' columns. Sending commercial email, and the consent behind it, remains your responsibility.
You May Also Be Interested In
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.Nurture leads with a personalised articleEach day, picks an article for every lead due one, by their interests and stage, writes a personal note around it and emails it.Sales call transcript analyzerEvery hour, has Claude analyze new sales call transcripts in a Google Sheet and emails you the call breakdown and action plan.
Start from a workflow that already works.
Add "Open a cold email on something they actually published" to your workspace, connect its apps, and make it yours. No credit card required.
Free plan available · No credit card required