Question

Collecting events in Google calendar and send mail or text message day before to remind

  • 26 April 2022
  • 1 reply
  • 21 views

I want to send my employers every day at 5pm an email with all the appointments that are in Google Calendar for the next day.

I have tried a lot but can't find a solution that fits me. 

Can anybody send me in the right direction? 

 

 


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 +14

Hi @LuchthavenExpresss 

Good question.

Try this:

2 Zaps.

Zap 1: Use the GCal - Event Start trigger (e.g. 24 hours before) to log all your GCal events into a GSheet with the Create Row option.

Zap 2: Use a Schedule trigger (5 pm) and GSheet Find Row(s) action to search by Date, format the returned data, then send an email.