Check the Track Settings Behind a Changed Tracker Row
When a tracked video or language entry changes, get the corresponding Amara subtitle language details for a quick review.
Trigger
Spreadsheet Row Changed
Triggers when a looked-up spreadsheet row changes. This trigger monitors a specific row (located by searching for a query value within a user-specified range) and fires when the row's values change, when the row appears, or when the row disappears.
Action
Get Subtitle Language Details
Tool to retrieve details for a single subtitle language. use when you have video id and language code and need metadata about that language track.
Why this helps
A changed language or video reference can leave reviewers unsure whether they are looking at the intended track and its current settings.
- Retrieve details for the video and language identified in the changed row.
- Make current track metadata easier to review.
- Catch incorrect or unexpected tracker references sooner.
Setup
Build it in a few focused steps.
- 1Connect Google Sheets and Amara once in the Notis portal.
- 2Create an automation and name it for subtitle track checks.
- 3Tell Notis to retrieve and summarize the subtitle language details for the video id and language code in the changed row.
- 4Choose the Spreadsheet Row Changed trigger and select where run reports should go.
- 5Test with one real row that identifies an existing Amara video and language track.
Questions about this workflow
What does the row changed trigger monitor?
It monitors a row located by searching for a query value within a user-specified range and fires when the row changes, appears, or disappears.
Can this action update completeness settings?
No. Get Subtitle Language Details retrieves metadata. Updating settings requires a different Amara action and a review of the existing track.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Sheets to Amara. A trigger fires from one place; an action lands in another.
Google Sheets triggers
Amara actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Add Subtitle Note
Tool to add a note to a subtitle set. use after retrieving the notes uri of the subtitle set.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Create Subtitle Language
Tool to create a new subtitle language for a video. use when you need to add a language track (iso 639-1 code) before uploading subtitles.
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.
Fetch Subtitles Data
Tool to fetch subtitle data for a video in a specific language. use when you need to retrieve subtitle segments after confirming video id and language code.
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.
Get Subtitle Language Details
Tool to retrieve details for a single subtitle language. use when you have video id and language code and need metadata about that language track.
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.
Get Team Details
Tool to get details on a specific team by slug. use when you need metadata for a single team.
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.
Get User Data
Tool to get user data by username or id. use when you need to fetch account details for a user.
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.
Get Video URL Details
Tool to get details for a specific video url. use when you have a public or embeddable video url and need its amara metadata (id, title, duration, thumbnails, etc.).
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.
List Available Languages
Tool to get a list of all supported languages. use when you need to know available language options from amara.
Connect any two apps with Notis in the middle.
Google Sheets and Amara, 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 Amara.