Review the Clockify client behind a changed sheet row
When a client record changes in your sheet, bring the matching Clockify details into view so you can quickly spot whether follow-up is needed.
Trigger
Spreadsheet Row Changed
Triggers when a looked-up spreadsheet row changes. This trigger monitors a specific row (located by searching for a query value within a user-specified range) and fires when the row's values change, when the row appears, or when the row disappears.
Action
Get Client By ID
Tool to get details of a client by id. use after confirming workspace and client ids.
Why this helps
Client details can drift between a planning sheet and Clockify, and it is easy to miss a change when work is spread across tools.
- Surface Clockify client details after a sheet row changes
- Reduce manual searching across tools
- Make client record reviews easier to follow up
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 use the changed row's client identifier to look up the corresponding Clockify client and summarize the result.
- 4Pick the Spreadsheet Row Changed trigger and specify the lookup range and query value in the trigger setup.
- 5Choose where run reports go, then test with one real example.
Questions about this workflow
What does the trigger watch?
It watches a row located by searching for a query value within a user-specified range, and fires when that row changes, appears, or disappears.
What does the Clockify action return?
Get Client By ID retrieves details for a specific client after the workspace and client IDs are known.
Does this change the Clockify client?
No. The available action reads the client details and Notis can summarize them in the run report.
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.