Set automatic reminders 1 week before birthday, from Google Sheets into Google Calendar

[Pepijn]

What are you trying to achieve?

Set automatic reminders 1 week before birthday, from Google Sheets into Google Calendar

Screenshots: scenario setup, module configuration, errors

[CharlieF]

Hi Pepijn!

You’ve made a good start there, from here I would recommended:

1. Add a field in your google sheets where your Month can be a numeric value (used for the date filter) - Would recommend format MM-DD
2. Construct the date filter. (What we are trying to do here is confirm with google sheets if the birthday is 1 week before birthday):

Your filter should be something like:

Your birthday column format (12-30)

Date time equal to:

addDays(formatDate({{now}};MM-DD);7)

We are asking Google sheets if the birthday is 7 days from now. The scenario should run daily.

If so, it should return a row which contains a birthday 7 days from now.

Once you have that working, we can move on to the google calendar step.

Any issues let me know!

[Pepijn]

Thanks Charlie!

I’ve updated the sheet and scenario per your suggestion:

/Pepijn