Each day, emails customers whose birthday it is a greeting with your discount code.
Uses
Gmail
Google Sheets
Email customers a birthday offer
Run every day at 09:00.Run every day at 09:00.
Customers sheetSet sheetUrl to blank.Birthday offer codeSet offerCode to blank.Customers with a birthday todayRead the rows of sheetUrl. Save it as birthdays.Google Sheets
For each customer in birthdays.rows:For each customer in birthdays.rows:Wish the customer a happy birthdaySend an email to customer.Email. Save it as greeting.
Subject: Happy birthday from us!Happy birthday, customer["First name"]!
To say thank you for being a customer, here is a birthday gift: use the code offerCode on your next order.
Have a wonderful day!Gmail