Transitioning a specific JIRA Story issue status when a related Test Cycle has finished executed

Hi, I am a user of JIRA Data Center that installed with Zephyr Scale as the testing solutions.

I want to find a solution on how to automatically transition a Story status when the test execution (a Test Cycle which has a traceability to this Story) is completed.

For example,

I have a Story-123 that is linked to a Zephyr SIT-TestCycle-123 through its Traceability field.

The workflow of Story-123 is : READY FOR SIT -> IN PROGRESS SIT -> READY FOR UAT -> IN PROGRESS UAT -> DONE.

1. I want whenever the SIT-TestCycle-123 status is changed from NOT EXECUTED to to IN PROGRESS, it will update the status of Story-123 from READY FOR SIT to IN PROGRESS SIT.

2. I want whenever SIT-TestCycle-123 status is changed like this:

Status : changed from IN PROGRESS -> DONE, and
All of the Test Cases statuses under this SIT-TestCycle-123 are in (PASSED, or INVALID),

then change the Story-123 status to READY FOR UAT.

and so on and so forth for the UAT Cycle until the story status is finished to Done.

My question, is it something that can be done with JIRA and Zephyr Scale? if it is possible, I am going to discuss it further with my company's JIRA global administrator.

Thank you very much.