Alert on a changed donation total
Notice when a tracked giving metric shifts, without repeatedly checking a spreadsheet.
Trigger
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.
Action
ChMeetings: Send Notification
Tool to attempt sending a notification.
Why this helps
A meaningful change in donation totals can pass unnoticed when someone has to check the spreadsheet manually.
- Bring changes in a giving metric to attention.
- Reduce manual checking of a recurring report.
- Create a prompt notification path for significant movement.
Setup
Build it in a few focused steps.
- 1Connect Google Sheets and ChMeetings once in the Notis portal.
- 2Create an automation in Automations, New Automation, and name it for donation metric alerts.
- 3Tell Notis what metric change should prompt a notification and what context to include.
- 4Pick the Google Sheets Aggregate Metric Changed trigger for the intended calculation and choose where run reports should go.
- 5Test with one real metric change and review the notification result.
Questions about this workflow
What calculations can the trigger monitor?
The trigger supports SUM, COUNT, AVG, MIN, and MAX on a target column, optionally filtered by a search column and value.
Does this track individual donations in ChMeetings?
No. The trigger monitors a Google Sheets aggregate, and the selected action attempts to send a notification. It does not create or update donation records.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Sheets to Chmeetings. A trigger fires from one place; an action lands in another.
Google Sheets triggers
Chmeetings actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Invite Meeting Attendee
Tool to invite a new attendee to a specified meeting. Use when you need to add attendees before the meeting begins.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Get Attendee Details
Tool to retrieve details for a specific attendee. Use when you have an attendee_id and need the attendee's full profile.
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.
ChMeetings: Create Meeting
Tool to create a new meeting in ChMeetings. Use when you have all meeting details and need to schedule it via the ChMeetings API.
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.
ChMeetings: Create Organization
Tool to create a new organization.
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.
ChMeetings: Create Reminder
Tool to create/schedule a reminder for a meeting in ChMeetings.
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 Meeting Attendee
Tool to remove an attendee from a meeting. Use after confirming attendee details.
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 Meeting Attendees
Tool to list attendees of a meeting. Use when you need to retrieve attendees for a specific meeting.
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.
ChMeetings: Delete Meeting
Tool to delete an existing meeting. Use when you have confirmed the meeting ID to permanently remove the meeting.
Connect any two apps with Notis in the middle.
Google Sheets and Chmeetings, 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 Chmeetings.