Best answer

Sending a Daily Email with GoogleSheets

  • 12 April 2020
  • 1 reply
  • 45 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

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.

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.