Sending notification to slack when the event date is today in Notion DB

[Bery]

Hi,

I have Notion DB with calendar where I have events added with dates.

I have following scenario in Make.com:

• Watch Notion (by updated time)
• Iterator, Aggregator, Text aggregator (for one of the arrays to show properly)
• Send notification to Slack.

I have a filter that checks the date and compares it to today’s date and if the date is same, I want notification to be sent in the Slack.

Scenario works perfectly when I test it with “Run Once” if the event was previously updated.

My issue is following: My scenario runs every morning 6 AM. If I have an event added in Notion with todays date and the scenario run yesterday and the filter didn’t go through (because the date was today), then it can’t find the database item today as it wasn’t updated after yesterday.

How I can make it run and check DB items in Notion even if they weren’t updated?

[Simo]

Hi Luka,
Instead of the “Watch database items” module, it sounds like you could use the “Search objects” module with a filter for date is today

[Bery]

Hi Simo, thanks for the answer.

I tried using Search Objects and added, but I don’t get any property values. Am i missing something?

[Simo]

Do you want to look for pages whose “Time” equals “today” (i.e., not including time), or “now” (i.e., the current time)?

If generic today, you may use formatDate({{now}};YYYY-MM-DD).
Else, your current filter setup is ok and it means there are no pages in Notion whose Time property value equals the current time of the scenario run

[Bery]

i tried using formatDate({{now}};YYYY-MM-DD) but I got the error.

I just need it to compare generic day, time is not important.

I have this test event added which has today’s date. But I think my filtering is not correct with only using “now”.

If I put just “now” it works but it doesnt see properties, but if I put it with formatDate then it gives error

[Simo]

Select “formatDate” from the date functions - it should look like this
Apologies I could have specified this in the previous message

[Bery]

Thank you Simo, it worked now!