Each day, emails customers whose birthday it is a greeting with your discount code.
Uses
Gmail
Google 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.
sheetUrl to blank.offerCode to blank.sheetUrl. Save it as birthdays.Google Sheetscustomer in birthdays.rows:For each customer in birthdays.rows: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