Time tracker uses Jira’s worklog structure to store worklogs, and all data is stored in the Jira database.
When creating an automation, you will be limited to what can be configured in Jira. (JQL, Jira Cloud REST APIs, etc.)
For additional assistance, please reach out to Atlassian Support.