Hi @basdebruin, taking a look to all the avaliable standard triggers on Monday Apps, i think that reporting multiple items needs a trigger that not depends on one item due date or status value (in common sense). So i think that could be a scheduled or recurring trigger.
every time period (trigger) report ALL items (action)
every time period (trigger) report ALL items (action) with THIS status (modifier)
every time period (trigger) report ALL items (action) with THIS text/number value (modifier)
every time period (trigger) report ALL items (action) with THIS DueDate passed.
every time period (trigger) report ALL items (action) in THIS GROUP (another useful modifier)
i think most effective notification is a combination in system/email because the result of this action would be a list of all items (item names and desired columns similar to excel reports), if this could be done of course.