Write a tailored first email for every row of your list
Writes a different first-contact email for each row of your sheet from that row's own facts, records it, then sends it.
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, name, company and subject 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, taking each row's name, company, role and notes, and skips rows without a valid address, name or company.
For each
row- 5AnthropicGenerate model responseAsks the AI to write one short first email from that row's facts alone, never implying you have met or spoken before.
- 6Google SheetsAppend row
- 7GmailSendSends 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 and run it when you are ready. This is not a mail merge: the name, company, role and your own notes on each row go to the AI, which writes that person's first email from scratch, and the email goes out from Gmail with your sign-off and opt-out line added.
The AI is told to use only the facts on that row, with no invented funding rounds or news, and any draft that implies you have already spoken is thrown away rather than sent, because on a first email that is never true. Each send is logged before it goes out and every address is checked against that log first, so nobody is emailed twice even if they appear on your sheet more than once. Emails per run are capped, so your first run can be a single test.
Your prospect tab needs 'Email', 'Name' and 'Company' columns, with 'Role' and 'Notes' optional; rows missing any of the three are skipped and counted. 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 "Write a tailored first email for every row of your list" to your workspace, connect its apps, and make it yours. No credit card required.
Free plan available · No credit card required