Create Clockify clients from new Google Sheets rows
Add a client to your sheet and let Notis create the matching Clockify client, so intake does not become another task to remember.
Trigger
New Rows in Google Sheet
Simple polling trigger that monitors Google Sheets for new rows. Detects when new rows are added and returns the complete row data. Perfect for triggering any workflow based on new sheet entries.
Action
Create Client
Tool to add a new client to a workspace. use when you need to create a client in a specific workspace.
Why this helps
Copying client details from an intake sheet into Clockify creates busywork and leaves new work waiting to be tracked.
- Create clients from newly added intake rows
- Reduce copy and paste between tools
- Keep new client setup moving
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 create a Clockify client for each new sheet row that contains the client details and workspace information.
- 4Pick the New Rows in Google Sheet trigger for the intake spreadsheet.
- 5Choose where run reports go, then test with one real example.
Questions about this workflow
What should the sheet row include?
Include the client details needed to create the Clockify client, such as its name, and the workspace to use. Notis can only act on information available in the row or supplied in your instruction.
Will it create a client for every new row?
It can create a client when a new row contains enough information to identify the intended Clockify client and workspace.
Can this update an existing Clockify client?
This workflow uses Clockify's Create Client action. It does not update existing client records.
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.