Create DeskTime projects from new Google Sheets requests
Capture a project request once in Sheets and let Notis set up its DeskTime project for you.
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 Project with Optional Task
Tool to create a new project with an optional initial task. use when you need to set up a new desktime project programmatically.
Why this helps
Project requests can sit in a spreadsheet while someone has to remember to recreate them in DeskTime.
- Move new project requests into DeskTime without retyping them.
- Include an initial task when the request provides one.
- Keep a run report in the channel you choose.
Setup
Build it in a few focused steps.
- 1Connect Google Sheets and DeskTime once in the Notis portal.
- 2Create an automation in Automations, New Automation, and give it a name and prompt.
- 3In one instruction, ask Notis to create a DeskTime project from each new intake row and include an optional initial task when present.
- 4Pick New Rows in Google Sheet as the trigger and choose where run reports go.
- 5Test with one real intake row.
Questions about this workflow
What should the intake row contain?
Include the project details DeskTime needs, such as a project name, and an initial task if you want Notis to create one. Tell Notis how to interpret the row in your prompt.
Does this copy every row into DeskTime?
The prompt describes the outcome. You can ask Notis to create a project for each new intake row, using the details in that row.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Sheets to Desktime. A trigger fires from one place; an action lands in another.
Google Sheets triggers
Desktime actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Create Project with Optional Task
Tool to create a new project with an optional initial task. use when you need to set up a new desktime project programmatically.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Get Account Details
Tool to retrieve detailed information about the authenticated user's company account. use after confirming the api key is valid to fetch company name, work settings, account timezone, and timestamp.
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.
Get All Company Employees
Tool to list all employees in the company, including their roles and statuses. use after confirming valid credentials to fetch the organization’s roster.
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.
Get Employee Data
Tool to fetch data for all employees within the company. use after verifying the api key is valid.
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.
Get Employee Projects
Tool to retrieve information about projects assigned to employees, including project names, durations, and statuses. use when you need to fetch per-employee project tracking data for a specific date.
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.
Get Employee Projects and Apps
Tool to retrieve an employee's tracked projects and application usage. use when you need combined project/app time data for a given employee and date (defaults to current user and today). example: "get projects and apps for employee 711867 on 2025-07-28."
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.
Get Projects List
Tool to retrieve all active projects for the company, including related tasks. use when you need projects overview after authentication.
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.
Ping DeskTime API
Tool to check the api's availability and confirm the service is operational. use when you need to verify that the desktime api is reachable and responsive.
Connect any two apps with Notis in the middle.
Google Sheets and Desktime, 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 Desktime.