Turn a changed expense metric into a Clientary record
Keep an eye on a total in Sheets and let Notis create an expense record when the change meets your rule.
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
Create Expense
Tool to create a new expense record in Clientary to track expenditures within your account. Use when you need to record expenses, optionally assigning them to specific clients or projects. Requires an amount field.
Why this helps
A meaningful shift in a tracked total can go unnoticed until someone manually reviews the spreadsheet.
- Watch a meaningful aggregate without manual checking.
- Apply a stated condition to the changed result.
- Create a Clientary record with the amount and context provided.
Setup
Build it in a few focused steps.
- 1Connect Google Sheets and Clientary once in the Notis portal.
- 2Create an automation in Automations, New Automation, and name it.
- 3Tell Notis: When the monitored aggregate changes and meets my stated condition, create a Clientary expense using the amount and context I provide, and report missing details.
- 4Pick Aggregate Metric Changed, configure the aggregate to monitor, and choose a report channel.
- 5Test with one real metric change and expense example.
Questions about this workflow
Does the trigger support thresholds?
The trigger fires when the selected aggregate calculation changes. State any threshold or decision rule in your automation instruction.
Where does the expense amount come from?
Provide the expense amount or an explicit rule for deriving it from the available metric. The create expense action requires an amount.
Can it monitor just part of the data?
The trigger can optionally filter by a search column and value. Use that to focus the aggregate on relevant rows.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Sheets to Clientary. A trigger fires from one place; an action lands in another.
Google Sheets triggers
Clientary actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Create Client
Tool to create a new client record in Clientary. Use when you need to add a new client to the system with company details and contact information.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Create Contact
Tool to create a new contact within a specified client. Use when you need to add a contact to a client account with name and email as required fields.
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 Expense
Tool to create a new expense record in Clientary to track expenditures within your account. Use when you need to record expenses, optionally assigning them to specific clients or projects. Requires an amount field.
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 Lead
Tool to create a new lead record in Clientary. Use when you need to add a new lead to the system with company details and contact information.
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.
Create Project
Tool to create a new project in Clientary with name and rate. Use when you need to set up a new project for tracking time, expenses, or managing client work.
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.
Create Task
Tool to create a new task in Clientary. Use when you need to create a task with a title, optionally associating it with a project and assignee.
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.
Delete Client
Tool to remove a client and all associated projects, invoices, estimates, and contacts. Use when you need to permanently delete a client from Clientary. WARNING: Deletions are permanent and not reversible.
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.
Delete Lead
Tool to permanently delete a lead and all associated Estimates and Contacts. Use when you need to remove a lead that is no longer needed. Warning: This action is irreversible.
Connect any two apps with Notis in the middle.
Google Sheets and Clientary, 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 Clientary.