Creating automation to send news letter for specific pages published last month

Question

I am trying to create a newsletter that will be sent for specific content that was published in Confluence pages in the past month and will be sent at the beginning of each month with last month's materials. 
I tried to write the cql according to the documentation and I am getting an error when running the cql although when I press the validation it seems ok and it even found 3 contents.

type = page AND label = trend_report_compliance AND created > startOfMonth("-1M") AND created < startOfMonth()
I received an error message after running the automation

No CQL-compatible content found in the rule context; there is nothing to check against the CQL query. The CQL condition component can only follow components that involve CQL-compatible content, such as the blog post published trigger, the publish new page action, or the related entities branch.
Can anyone assist?
Thanks,
Tami

Tami Dubi_uyf9bl · Answer

Hi @Bill Sheboy 
Actually, I found a workaround. I am creating an automated page publication based on a template that will include a macro of "Filter by label" for the specific content that was published in the past month. the automation of the page publication will occur once-a-month and will also trigger an email update. 
Yes it's a waste of more Confluence pages that could have been saved, but it doesn't require Rest API or Marketplace third-party apps. 
 Thanks again for your assistance
Best,

Tami

Bill Sheboy · Answer

Confluence rules are quite new compared to the Jira automation features, and so they [Atlassian] are likely still identifying candidate usage scenarios to improve the features.  Additionally, rules rely upon the REST API, which at least allows customers to try to close gaps in what is currently available using the Send Web Request action.

In the mean time, you could investigate the Atlassian Marketplace for addon apps which may provide the type of reporting you need: https://marketplace.atlassian.com/

Tami Dubi_uyf9bl · Answer

Hi @Bill Sheboy ,
Thanks, the rest API isn't an option that we can currently use. 
 The whole point in automation is the ability to create - no-code- solutions in Confluence.

Thanks for the effort.

If someone have any idea on how to implement it in the automation rules limitations please let me know
Best,
Tami