Trigger
Schedule — a CRON expression runs the workflow weekly (e.g.0 9 * * 1 for every Monday at 9 AM).
Workflow
Query expiring contracts
An API Request step with the Royaltyport API preset queries contracts with term end dates in the next 90 days.
Filter already-notified contracts
A Database step reads the
notified_contracts table in an automation database to get a list of contract IDs that have already been processed. A Code step filters the expiring contracts list, removing any that already have a record in the table.Generate renewal briefs
A Loop step iterates over the remaining contracts. Inside each iteration, a Transformer step generates a renewal brief summarizing the parties, current royalty rates, territory scope, and revenue performance.
Create a ticket
An API Request step creates a ticket in a project management tool (Monday, Jira, Asana, or similar) with the renewal brief, contract details, and a link back to the contract in Royaltyport.
Notify the team
A Notification step emails the A&R or business affairs contact with the renewal brief and a link to the created ticket.
Mark as notified
A Database step inserts the contract ID, notification date, and ticket URL into the
notified_contracts table so the contract is skipped on future runs.Key Features Used
- Schedule trigger for weekly automated runs
- Automation database for deduplication tracking
- Transformer for AI-generated renewal briefs
- Code step for filtering already-processed contracts
- External API integration with project management tools
Related Documentation
Triggers
Configure schedule triggers with CRON expressions.
Transformer
Use AI to generate structured output from workflow data.
Databases
Create automation databases for tracking state across runs.
More Examples
Browse all example workflows.