Skip to main content

Hi everyone,
I’m new here and recently started using Notion at my workplace.

To keep things organized, I created a Notion task tracker database with a calendar view so I can stay on top of everything. The database includes fields for task name, assignee, due date, client, and description.

What I’d like to do is set up a Zap that sends me a daily email to my work account with all the tasks I have scheduled for that day.

For example, tomorrow (09/03) I’d like to receive an email that says:
“Hello, these are your tasks for today:”
…followed by a list of tasks for September 3rd.

Ideally, I’d like this to run every weekday (Monday through Friday).

I’ve tried setting up the trigger and action, but I can’t figure out what I’m doing wrong. So far, AI hasn’t been very helpful.

Can anyone shed some light on how to make this work?

Thanks in advance!

Hey ​@fabiospina 👋

Could you share more details on which step is not working as expected? You can share a screenshot of your configuration (and blur any sensitive data before sharing).

My initial suggestion would be:

  1. Schedule by Zapier - Every Day trigger (you can mark the option to trigger on weekends as No)
  2. Notion - Find Database Items. The search can be set up using the Date field in your database, and map the date value returned by the trigger, since you want to retrieve the tasks due for the same day
  3. An email app (Gmail, Outlook, Email by Zapier, etc) - Send Email. Send yourself an email listing the items found in step 2

Hi ​@Marge 

Thanks for your help.
Here is where I’m having troubles.  When I test the second step, it doesn’t show any tasks.

I’m adding screen shots of the 2nd step configuration and the tasks on my notion database

 


Hey ​@fabiospina,

You can debug this like this. First try running the Find Database items action step without any filter to see if this is working properly. Now coming to filtering I think the issue maybe the format of the date is not matching that of of Notion so that can be one of the reasons that it’s not working. If that’s the issue, you can solve this by adding the Formatter by Zapier step. Here is the article about it- https://help.zapier.com/hc/en-us/articles/8496257974029-Modify-date-and-time-formats-in-Zaps#h_01HF6R8YN0S090W3YNNYCA1V0S

PS: If you need any professional help and want to leverage AI agents and automations for your business, I can help as I am a Zapier Official Silver Solution Partner and you can contact me through my solution page here or just send a DM from my profile :)


Hi ​@Sparsh from Automation Jinn 

Thanks for your help!

I tried what you said but same error mesagge 

 

Also, thanks a lot for your offer. I’ll keep it in mind :) 


Hey ​@fabiospina,

Did you try running the Find Database action without any filters? Did it fetch all the task items then?


Hi ​@Sparsh from Automation Jinn 

Yes I tried. Same

 


Hey ​@fabiospina,

You need to select some search value to execute the Find database items action. Maybe first you can put it to Due Date Filter is not empty to see if it fetches all the task items. 

Now coming to data filter in notion see this article which can be helpful- https://help.zapier.com/hc/en-us/articles/8496040151821-Common-problems-with-Notion-on-Zapier#h_01HCMPY23X6S4PT0KY0SZBE0MX

So for this Find by Database item action Due date filter expect this format YYYY-MM-DDT00:00-0000 to search only by the date as Notion accepts ISO8601 format. For example- 2025-09-03T00:00-0000. Hope it helps!

PS: If you still need any professional help, I can help as I am a Zapier Official Silver Solution Partner and you can contact me through my solution page here or just send a DM from my profile :)


Reply