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

[Laura]

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

[Marc - Devoteam]

Hi @Laura 

Whenever you ask for help with an Automation Rule it will help us to help you if you provide:

1. images that show your complete rule.

2. images showing the details of any relevant actions/conditions/branches.

3. images showing the Audit Log details for the rule execution.

4. Explain where the issue is.

These questions are not for not willing to help, but to have community members understand on how automation works.

[Laura]

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!

[Marc - Devoteam]

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]

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