create_workflow
Create scheduled or manual workflows that run SQL queries and trigger email or webhook actions, including alerts when conditions are met.
Instructions
Create a workflow: SQL steps + EMAIL/WEBHOOK actions, run manually or on a cron schedule. To make an alert, write a step query that only returns rows when the condition fires and set stopIfEmpty=true — actions then run only when rows come back. Step results are auto-appended to the email/webhook payload. Point a WEBHOOK at a Slack incoming-webhook URL for Slack alerts. Free plan allows 3 workflows.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| name | Yes | Workflow name | |
| steps | No | SQL steps, run in order | |
| actions | No | Actions fired after steps complete | |
| description | No | Optional description | |
| triggerType | Yes | MANUAL (run on demand) or SCHEDULE (cron) | |
| connectionId | No | Connection id the step queries run against | |
| triggerConfig | No | For SCHEDULE: JSON string with a cron expression, e.g. {"cron": "0 9 * * *"} |