The Scenario
The project operations manager has had a nagging suspicion for months: the Timely label taxonomy has grown out of control. Two years of different project managers creating labels ad hoc means there are probably duplicates ("Client Work" and "client-work" and "Client work"), orphaned labels nobody uses, and inconsistent naming conventions. Before she can standardize anything, she needs to see what's actually there.
The bad version:
- Open Timely, navigate to the labels section, scroll through the list
- Try to copy the label names into a sheet manually, one by one
- Discover there's no export option — or find an export that gives you names but not IDs or parent labels
The audit can't happen until the data is in a sheet. And the data can't get into a sheet through any fast path in the current UI.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads your sheet and through its built-in Timely integration it can pull the complete label list — with IDs, names, colors, and parent labels — into your sheet in one pass.
List all labels in my Timely account and write them to my Label Audit tab with columns for label ID, name, color, and parent label if any
What You Get
- One row per Timely label, written into the Label Audit tab
- Columns: label ID, name, color (hex or named), parent label name (blank if top-level)
- The full label inventory in one view so you can sort, filter, and identify duplicates without clicking through the UI
What If the Data Is Not Quite Ready
You want to flag likely duplicates immediately
Pull all Timely labels into my Label Audit tab with ID, name, and color — then add a column E that flags any label name that appears more than once after trimming whitespace and lowercasing
You only want top-level labels
List all Timely labels that have no parent label and write them to my Label Audit tab with label ID and name
You want to see how many time entries use each label
Pull all Timely labels into my Label Audit tab with ID and name — then for each label, count the number of time entries that use it and write the count into column C so I can identify unused labels
Full label audit in one pass
Pull all Timely labels into my Label Audit tab with ID, name, color, and parent — flag potential duplicates in column E (same name ignoring case and spacing), flag labels with zero usage in column F, and sort the sheet by name so duplicates are adjacent
The pattern: pull the label data and run the duplicate detection together so the audit sheet is actionable without a second pass.
Try It
Get the 7-day free trial of SheetXAI and open your label audit sheet, then ask it to pull the full Timely label list. For creating a new standardized set of labels after the cleanup, see the spoke on bulk-creating Timely labels.