Notify teams of spreadsheet changes automatically
Sheet title changed? Timezone updated? Notis drafts a notification. Team stays in sync on structural updates.
Trigger
Spreadsheet Properties Changed
Polling trigger that detects when a Google Spreadsheet's top-level properties change. Monitors properties such as title, locale, timeZone, and autoRecalc settings.
Action
Create email draft
Creates a gmail email draft, supporting to/cc/bcc, subject, plain/html body (ensure `is html=true` for html), attachments, and threading.
Why this helps
Spreadsheet setting changes (title, timezone, recalc mode) often go unnoticed. Teams use stale settings or get confused by name changes.
- Automatic notification when sheet properties change
- Team aware of title, timezone, or settings updates
- Draft stays in Gmail for review before sending
- Prevents confusion from structural changes
Setup
Build it in a few focused steps.
- 1Connect Google Sheets and Gmail to Notis.
- 2Create an automation: 'When my spreadsheet properties change, draft an email to the team describing what changed.'
- 3Set the trigger to 'Spreadsheet Properties Changed' and select the sheet to monitor.
- 4Describe which properties to highlight in the email (title, timezone, autoRecalc setting, etc.).
- 5Test by changing a property and confirming the draft appears in Gmail.
Questions about this workflow
Which properties can trigger this?
Title, locale, timezone, autoRecalc setting, and any other top-level spreadsheet property that changes.
Do I want notifications for every tiny change?
Set a filter: 'only notify if the title or timezone changes' to focus on important updates and reduce noise.
Can I suggest the wording for the email?
Yes. Describe your preferred tone in your automation prompt and Notis will draft accordingly.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Sheets to Gmail. A trigger fires from one place; an action lands in another.
Google Sheets triggers
Gmail actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Modify email labels
Adds and/or removes specified gmail labels for a message; ensure `message id` and all `label ids` are valid (use 'listlabels' for custom label ids).
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Create email draft
Creates a gmail email draft, supporting to/cc/bcc, subject, plain/html body (ensure `is html=true` for html), attachments, and threading.
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 label
Creates a new label with a unique name in the specified user's gmail account.
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.
Delete Draft
Permanently deletes a specific gmail draft using its id; ensure the draft exists and the user has necessary permissions for the given `user id`.
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 message
Permanently deletes a specific email message by its id from a gmail mailbox; for `user id`, use 'me' for the authenticated user or an email address to which the authenticated user has delegated access.
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.
Fetch emails
Fetches a list of email messages from a gmail account, supporting filtering, pagination, and optional full content retrieval.
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.
Fetch message by message ID
Fetches a specific email message by its id, provided the `message id` exists and is accessible to the authenticated `user id`.
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.
Fetch Message by Thread ID
Retrieves messages from a gmail thread using its `thread id`, where the thread must be accessible by the specified `user id`.
Connect any two apps with Notis in the middle.
Google Sheets and Gmail, 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 Gmail.