Personalised marketing emails from customer data
Reads each customer's purchases and feedback, lets AI decide who earns a coupon, and sends a tailored email from Gmail.
Apps it connects
Authenticate each one once and the workflow is ready to run.
What it does
Each integration step this workflow runs, in the order it first runs them, and what it is for.
- 1Google SheetsCreate tabCreates the 'Emails sent' tab beside your customers on the first run, and reuses it on every run after that.
- 2Google SheetsAppend rowWrites the header on a new tab, then appends one row per email sent with address, product, sentiment, the coupon decision and why, and the subject.
- 3Google SheetsRead columnReads the first column of the 'Emails sent' tab to find which customer and product pairs have already been emailed.
- 4Google SheetsRead rowsReads your customers tab in full, taking the name, email, product, purchase history, feedback and segment from each row.
- 5AnthropicGenerate model responseAsks the AI to read the customer's purchases and feedback, judge the sentiment and decide on the coupon, then to write the subject and body in your tone.
- 6GmailSendSends each customer their personalised email from your own account, with the coupon included when the AI decided they should have one.
How it works
What happens on each run, in plain English.
Once a day, your sheet of customers is read - what each one bought, how much they spend, how recently they ordered and any feedback they left - and the AI reads the whole customer before writing a word. It judges whether the feedback is positive, neutral or negative, then decides whether this customer should be offered your coupon, following the coupon policy you write in plain language: a frustrated customer or a lapsed regular gets the code, a happy customer who ordered last week gets a thank-you and a reason to come back.
Each subject line and body is then written fresh for that customer, in your tone and towards the goal you set, and sent from your own Gmail account. Your sheet is never changed; a separate 'Emails sent' tab records one line per email with the address, product, sentiment, the coupon decision and why, and the subject. That tab is checked before every send, so nobody is emailed twice about the same purchase, and if it cannot be written after a send the run stops at once. Each run sends a capped number of emails.
Your sheet needs Name, Email and Product columns; Order total, Previous orders, Last order date, Feedback and Segment columns are used when present.
You May Also Be Interested In
Send sentiment-aware emails with couponsEmails each customer about their purchase in your tone, reads their feedback first, and adds a coupon when the feedback is negative.LinkedIn content idea generatorEvery morning, turns the news logged in your sheet into LinkedIn post ideas for your area of interest, emails them, and clears the sheet.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.
What your YouTube viewers are sayingSorts the comments on your latest videos into asks, praise and complaints, and emails the counts with real quotes.
Start from a workflow that already works.
Add "Personalised marketing emails from customer data" to your workspace, connect its apps, and make it yours. No credit card required.
Free plan available · No credit card required