How can I create an automation that checks for a specific date in a page and sends an email?

[Sophie Davy]

I want to create an automation that checks my pages once a week for the "Expiry Date" and if it is equal to or greater than the current date, will send an email to me notifying me of the expiry. 

(Bonus: If the expiry date is within 30 days, sends reminder email also)

[Thiago P _Atlassian Support_]

Hey there @Sophie Davy ,

Not sure if it's possible to parse a specific date on a page.

Using Tasks, a Due Date can be defined and accessed via the {{task.dueDate}} Smart Value.

Then, it can be compared using a Task Branch with a Due Date criteria. Specific details about the page where the task is added to can be found using the {{page}} Smart Value within the branch.

It looks like you're entitled to a Premium plan, so make sure to open a Support ticket and we can help you create a rule that suits your needs.

Hope this helps!  =]

[Mia Tamm - Simple Table for Confluence]

Hi @Sophie Davy,

This isn’t something you can do directly in Confluence out-of-the-box, but there are a few approaches depending on how flexible you want it to be:

1. Using Confluence Automation (Cloud Premium/Enterprise)
   • You can set up a scheduled rule (e.g., run weekly).
   • Use the “CQL condition” to search for pages with a label or metadata field that contains your “Expiry Date.”
   • Then add a branch to compare that date with the current date.
   • If the condition is met, use the “Send email” action to notify yourself (or a group).
2. Page Properties + CQL
   • If you store expiry dates in a Page Properties macro, you can query those with CQL in automation rules.
   • That way, your automation can filter only pages where the expiry date is ≤ today.
3. Marketplace Apps
   • Apps like Better Content Archiving or ScriptRunner for Confluence can handle expiry dates, notifications, and reminders more easily. These are especially useful if you want the bonus feature of sending a reminder 30 days before.

For the bonus (30-day reminder), you’d need either:

• Two conditions in your automation rule (expiry = today OR expiry within 30 days), or
• Use an app that supports “expiry + reminders” natively.

If you’re on Confluence Cloud Premium, I’d recommend starting with automation rules first. Otherwise, a marketplace app will save you time and give you more flexibility.

Hope this points you in the right direction!

— Mia Tamm from Simpleasyty