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

Question

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_ · Answer

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 _Simpleasyty_ · Answer

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:

* 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).

* 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.

* 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