Is it possible for an automation rule in Confluence Cloud to read the Page Properties macro?

Question

Hello!

I'm trying to create an automation rule, and after several attempts on my own, reading posts for insight, reading help topics, watching videos, and consulting AI (Copilot with Confluence Agent, and Claude AI) without a fully successful result, I am wondering if what I'm attempting and failing at is just stupid human error or if it just isn't possible without getting a plug-in.

I am attempting to read the dueDate field in a table within the Page Properties macro to compare that dueDate to the current date (running daily) and then take an action (send email) if that due date falls within the next week.

Before I keep chasing this I thought I'd see if that's even possible. If it is, I'll try again and most likely create a new post requesting assistance with an example of what I've tried. If not, I'll move on.

Thanks!

Laura

Laura · Answer

Thanks @Marc -Devoteam-!  I read the article and think it may help. I'll give some of those suggestions a try. I appreciate your feedback.

Laura

Marc -Devoteam- · Answer

Hi @Laura

You might want to start in your automation using a web request action.

This to get the body of the Confluence page.

See this article; https://community.atlassian.com/forums/Automation-questions/Extracting-content-from-Confluence-Page/qaq-p/2550307

Laura · Answer

Thanks, Marc! I thought maybe someone would know quickly if checking inside a page property macro for a value in the table was even possible. If it was, I planned to provide all the necessary items, but if it wasn't I would just move on.

Thank you!