The Scenario
You've been managing client work in TickTick for eight months. At some point the project count crossed 30, names started overlapping, and a few got created by different team members with inconsistent naming conventions. Before you can reorganize anything, you need to know what's actually there — every project name, its ID, its view mode, its color — in a form you can sort and annotate.
You open TickTick and start scrolling the left sidebar.
The bad version:
- You manually copy project names into a new Google Sheet, right-clicking each one to find the project ID buried in the settings panel.
- The sidebar only shows names, so you have to click into each project's settings separately to see the view mode and color — another modal per project.
- By the time you've recorded 18 projects you realize you've been capturing the hex colors but you needed the color names, and several of them look identical on screen anyway.
Thirty projects. Thirty settings modals. Ninety minutes to generate a list you could have asked for in three words.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It fetches every TickTick project you have access to — names, IDs, view modes, colors — and writes the full inventory into your sheet in one operation.
Fetch all TickTick projects and write each project's name, ID, view mode, and color into the 'Project Inventory' sheet starting at row 2 with a header row.
What You Get
- Every project in your TickTick account appears as a row in the 'Project Inventory' sheet.
- Column A: project name. Column B: project ID. Column C: view mode. Column D: color value.
- A header row is written in row 1.
- The list reflects your current account state — any projects created or deleted since your last pull won't be there until you run it again.
What If the Data Is Not Quite Ready
You want to flag projects with non-standard naming
Your naming convention requires a client code prefix. You want to identify which projects are missing it.
Fetch all TickTick projects and write name (A), ID (B), view mode (C), and color (D) into the 'Project Inventory' sheet. In column E, write 'NO PREFIX' for any project name that doesn't start with a two-to-four letter uppercase code followed by a dash.
You want to count open tasks per project alongside the inventory
The reorganization decision depends partly on how active each project is.
Fetch all TickTick projects and for each one, also fetch the count of incomplete tasks. Write project name (A), ID (B), view mode (C), color (D), and open task count (E) into the 'Project Inventory' sheet.
You want to group projects by view mode
Kanban projects need different handling during the reorg than list-view projects.
Fetch all TickTick projects and write name (A), ID (B), and color (C) into the 'Project Inventory' sheet. Sort by view mode so all kanban projects appear first, then list projects.
Full kill chain: fetch, annotate, and flag duplicates in one shot
Fetch all TickTick projects and write name (A), ID (B), view mode (C), and color (D) into the 'Project Inventory' sheet. In column E, flag any project name that appears more than once with 'DUPLICATE'. In column F, flag any project with zero characters in the name with 'UNNAMED'. Sort by project name ascending. Add a header row and clear existing content first.
Pull, annotate, and surface problems all in one pass — so the reorganization starts with complete information.
Try It
Get the 7-day free trial of SheetXAI and open a blank Google Sheet, then ask it to pull your full TickTick project inventory before you start any reorganization. Also see: creating multiple new projects from a planning sheet or pulling all tasks from a specific project — or return to the TickTick integration overview.