Check your Clockify client list when a sheet metric changes
A meaningful shift in a client-related sheet metric can prompt a quick Clockify client review, without relying on a reminder you might miss.
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
Get Clients
Tool to list clients in a workspace. use after obtaining a workspace id.
Why this helps
Changes in client counts or totals can signal work to review, but the signal is easy to lose among spreadsheet updates.
- Use an aggregate change as a review cue
- Bring the Clockify client list into the workflow
- Reduce the effort of remembering to check client records
Setup
Build it in a few focused steps.
- 1Connect Google Sheets and Clockify once in the Notis portal.
- 2Create an automation in Automations, then choose a name and report channel.
- 3Tell Notis to retrieve Clockify clients when the monitored sheet metric changes and summarize the metric and client list for review.
- 4Pick the Aggregate Metric Changed trigger and select the spreadsheet calculation to monitor.
- 5Choose where run reports go, then test with one real example.
Questions about this workflow
Which spreadsheet calculations can trigger this?
The trigger monitors an aggregate calculation such as SUM, COUNT, AVG, MIN, or MAX on a target column, optionally filtered by a search column and value.
Does Clockify provide client revenue or time totals here?
No. This workflow retrieves the Clockify client list. Any metric details must come from the Google Sheets trigger data.
Can the workflow create or update clients?
No. Its Clockify action lists clients for review; it does not alter them.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Sheets to Clockify. A trigger fires from one place; an action lands in another.
Google Sheets triggers
Clockify actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Create Client
Tool to add a new client to a workspace. use when you need to create a client in a specific workspace.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Create Webhook
Tool to create a new webhook in a workspace. use when you want to subscribe to workspace events by registering a callback url.
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.
Delete Client
Tool to delete a client from a workspace. use after archiving the client and confirming no associated data exists.
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 Webhook
Tool to delete a webhook from a workspace. use when you need to remove an existing webhook by its 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.
Filter Workspace Users
Tool to filter users in a workspace by advanced criteria. use when you need a paginated, sortable list of workspace users matching multiple filters.
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.
Find All Users On Workspace
Tool to list all users in a workspace. use when you need to retrieve workspace members after confirming the workspace id. example: "find all users on workspace 64a687e29ae1f428e7ebe303."
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.
Find User's Team Managers
Tool to get managers of a user in a workspace. use after confirming workspace and user ids are correct.
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.
Generate New Webhook Token
Tool to generate a new webhook token. use after confirming workspace and webhook ids.
Connect any two apps with Notis in the middle.
Google Sheets and Clockify, 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 Clockify.