Each day, emails customers whose birthday it is a greeting with your discount code.

UsesGmailGoogle Sheets

Email customers a birthday offer

A birthday message with a small gift brings customers back. Every day at 9:00 this reads your customers sheet and emails each person whose birthday is today a happy-birthday note with the discount code you choose.

The sheet needs the columns First name, Email and Birthday. Nothing is sent on a day with no birthdays.

ScheduleRun every day at 09:00.Run every day at 09:00.
ValuesCustomers sheetSet sheetUrl to blank.
ValuesBirthday offer codeSet offerCode to blank.
Google SheetsCustomers with a birthday todayRead the rows of sheetUrl. Save it as birthdays.Google Sheets
Decisions & LoopsFor each customer in birthdays.rows:For each customer in birthdays.rows:
GmailWish 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