Review table schema changes in Dart
A new, renamed, or removed column can be a useful prompt to check work that depends on the table.
Trigger
Table Schema Changed
Polling trigger that detects when a table's schema changes in Google Sheets. Monitors columns added/removed/renamed and inferred type/format changes. Uses snapshot-based diffing to compare schemas between polls.
Action
Create Task
Tool to create a new task in DART with title and optional metadata. Use when you need to add a task to a workspace.
Why this helps
Schema changes can affect reports or routines, but the people responsible may not hear about them.
- Prompt a review when table structure changes.
- Keep follow-up visible in Dart.
- Help teams notice column and inferred type changes.
Setup
Build it in a few focused steps.
- 1Connect Google Sheets and Dart once in the Notis portal.
- 2Create an automation in Automations, New Automation, and give it a name.
- 3Tell Notis which schema changes deserve a Dart review task and what to check.
- 4Choose the Table Schema Changed trigger and a report channel.
- 5Test with one real schema change.
Questions about this workflow
What schema changes can trigger this?
The trigger detects columns added, removed, or renamed, as well as inferred type or format changes.
Can the task name a downstream report?
Yes, if you identify the relevant report or process in your instruction.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Sheets to Dart. A trigger fires from one place; an action lands in another.
Google Sheets triggers
Dart actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Add Task Comment
Tool to create a new comment on a DART task. Use when you need to add feedback, notes, or discussion to a specific task. Supports markdown formatting and threaded replies via parentId.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Add Task Time Tracking
Tool to add a time tracking entry to a DART task. Use when you need to record time spent on a specific task. The finishedAt timestamp must be after startedAt.
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 Doc
Tool to create a new doc in Dart. Use when you need to record a new document that the user intends to write down. By default, the created doc will be in the Docs folder unless a specific folder is specified.
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 Task
Tool to create a new task in DART with title and optional metadata. Use when you need to add a task to a workspace.
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 Doc
Tool to move an existing doc to the trash where it can be recovered if needed. Use when you need to delete a doc without permanently removing it.
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 Task
Tool to delete an existing task in Dart by moving it to trash. Use when a task needs to be removed but can be recovered later.
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 User Space Configuration
Tool to retrieve workspace configuration including dartboards, folders, types, statuses, and more. Use when you need to understand available options in the workspace.
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.
Get Doc
Tool to retrieve an existing doc with metadata and content. Use when you need to access a specific document's details including title, folder, and text content.
Connect any two apps with Notis in the middle.
Google Sheets and Dart, 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 Dart.