Best answer

Sending a Daily Email with GoogleSheets

  • 12 April 2020
  • 1 reply
  • 57 views

Hi all,

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?

Thanks,
James

 

 

icon

Best answer by AndrewJDavison_Luhhu 12 April 2020, 11:45

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Userlevel 7
Badge +10

Hi @james18 

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.