Update ClassMarker subcategories from Sheet changes
Let one authoritative row keep your assessment taxonomy current.
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
Update Sub-Category
Tool to update an existing sub-category. Use when you need to rename or move a sub-category after confirming its IDs.
Why this helps
Taxonomy changes are recorded in Sheets but applied manually in ClassMarker later.
- Keeps taxonomy consistent
- Reduces delayed admin work
- Makes row changes actionable
Setup
Build it in a few focused steps.
- 1Connect Google Super and ClassMarker once in Notis.
- 2Create an automation describing how to identify the subcategory and apply the approved row change.
- 3Pick the Spreadsheet Row Changed trigger.
- 4Choose the report channel.
- 5Test with one real taxonomy row change.
Questions about this workflow
How is the row located?
Configure the trigger with the lookup range and query value for the target row.
Can it move a subcategory?
Yes. Include the desired parent category and valid identifiers in the instruction.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Super to Classmarker. A trigger fires from one place; an action lands in another.
Google Super triggers
Classmarker actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Create Access List Item
Tool to add one or more access codes to an access list. Use after obtaining a valid access_list_id to grant exam access.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Create a new question category
Tool to create a new question category. Use after confirming the parent category ID.
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.
Create Group
Tool to create a new group. Use when you need to organize users into a specific group after planning your user structure.
Attendee Response Changed
Polling trigger that fires when any attendee's RSVP changes to accepted, declined, or tentative. Returns attendee info and current status.
Create Question
Tool to create a new question with specified text, type, and category. Use after finalizing details. Set verify_only=True to validate without creating.
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.
Create ClassMarker User
Tool to create a new user in ClassMarker. Use after gathering user details to provision accounts. Provide user info and optional group assignments. Returns the complete API response.
Comment Added (Docs/Sheets/Slides)
Triggers when a new comment is added to Google Docs, Sheets, or Slides.
Delete Access List Item
Tool to delete one or more codes from an access list. Use after confirming the list exists.
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.
Delete API Key
Tool to delete an API key by its ID. Use when you need to revoke an API key immediately.
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.
Delete Group
Tool to delete a group by its ID. Use when you need to remove a group from ClassMarker.
Connect any two apps with Notis in the middle.
Google Super and Classmarker, 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 Classmarker.