I have a Google Sheet set up with a column containing unique email bodies I’d like emailed to me on specific days - one email per day. I already have the email bodies ready for the next year, and I don’t open this Google Sheet every day. How would you recommend I set this up with Zapier?
Best answer by AndrewJDavison_Luhhu
You’ll want to trigger the zap with a “Schedule by Zapier” step.
Next, you’ll want a “Formatter->Date->Format Date” step to take today’s date as an input and turn it into the same format as you have on the sheet.
Then, search the step for a row matching that date.
Then add your email step, mapping date from the sheet.
Try that and let us know if you get stuck.