Refresh transcription options when your query changes
When your queried workload changes, get the available Castingwords services and pricing for a timely review.
Trigger
Table Query Result Changed
Triggers when the result set of a saved table query changes in Google Sheets. Detects rows added, removed, or updated in the query output. This trigger monitors the result of a SQL query against a Google Sheets table and fires when changes are detected.
Action
List Available SKUs
Tool to retrieve list of available skus. use when you need to know available services and pricing before placing an order.
Why this helps
A changed workload can make old assumptions about transcription services and pricing harder to trust.
- Retrieve current available services and pricing
- Tie a service review to a meaningful query change
- Avoid relying on an old SKU list
Setup
Build it in a few focused steps.
- 1Connect Google Sheets and Castingwords once in the Notis portal.
- 2Create an automation in the portal or tell Notis from any channel what outcome you want.
- 3Ask Notis in one instruction to retrieve available SKUs when the saved query result changes.
- 4Pick Table Query Result Changed as the trigger and choose where run reports go.
- 5Test with a real change to the saved query result.
Questions about this workflow
Does this workflow choose or order a SKU?
No. It retrieves the available SKU list and pricing for review.
What does the trigger watch?
It watches a saved SQL table query result for rows added, removed, or updated.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Sheets to Castingwords. A trigger fires from one place; an action lands in another.
Google Sheets triggers
Castingwords actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Cancel and Refund Audio File
Tool to cancel an ordered audio file and issue a refund if applicable. use when no transcription work has been done on the file (pre-processing, audio processing, error states).
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Get Prepay Balance
Tool to retrieve the current prepay balance for the account. use when you need to check available funds before placing new transcription orders.
Aggregate Metric Changed
Triggers when an aggregate metric (SUM/COUNT/AVG/MIN/MAX) changes in a Google Sheets spreadsheet. This trigger monitors an aggregate calculation on a target column (optionally filtered by a search column/value) and fires when the calculated result changes.
Get registered webhook URL
Tool to retrieve the currently registered webhook url for account notifications. use when you need to verify your webhook setup.
Cell Range Values Changed
Triggers when values in a specified A1 range change in Google Sheets. This trigger monitors a specific cell or range of cells and fires when any values change.
Order Transcript
Tool to create a new transcription order for audio/video at a url. use when you have an accessible media url and need to initiate transcription.
Conditional Format Rule Changed
Triggers when conditional formatting rules change in a Google Spreadsheet. Detects when rules are added, updated, or removed. Uses snapshot-based diffing to detect changes between polls.
Order Upgrades
Tool to order an upgrade for a specific audio file. use after transcription is complete to add items like timestamps or extra editing. example: 'order timestamps for file 12345'.
Data Validation Rule Changed
Triggers when data validation rules change (added/updated/removed) in a Google Spreadsheet. Uses snapshot-based diffing to detect changes between polls.
Register Webhook
Tool to register a webhook url to receive transcript completion notifications. use when you want castingwords to post transcript-complete events to your service endpoint.
Developer Metadata Changed
Triggers when developer metadata entries change (new/updated/removed) in a Google Spreadsheet. Uses snapshot-based diffing to detect changes between polls.
List Available SKUs
Tool to retrieve list of available skus. use when you need to know available services and pricing before placing an order.
Filtered Range Values Changed
Polling trigger that monitors Google Sheets filtered ranges for value changes. Uses snapshot-based diffing to detect when values matching a data filter change. Emits the matched values when changes are detected.
Test Webhook Call
Tool to request a test webhook call for a specific event type. use after registering a webhook url to ensure webhook notifications are functioning properly.
Connect any two apps with Notis in the middle.
Google Sheets and Castingwords, or any other combination from 1,000+ integrations.
When this happens · Trigger
Do this · Action
Save your first hour today.
7-day trial of any paid plan, with 20$ of usage included.
No card. Works with personal or business Castingwords.