The Scenario
Your virtual assistant asked for a weekly status snapshot by noon. It's 11:40. You have 60 open TickTick tasks distributed across 8 projects — design, engineering, admin, client work, operations — and you need a sorted, shareable list with task name, project, due date, and priority, ready to drop into an email.
You open TickTick on your laptop and start reading off tasks. Project by project. Window by window.
The bad version:
- You switch between eight different TickTick project views, copying task names and due dates into a fresh Google Sheet row by row — remembering to tag the project name manually each time.
- You sort by due date and realize the sort broke because some dates were entered as text and some as actual date values, so they're in the wrong order.
- You send the sheet and three minutes later your VA replies: which ones are overdue? You go back, eyeball the dates against today's date, highlight them by hand, and send an update.
Twenty minutes for a task that should have taken one. And next week you'll do it again.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It connects to TickTick, reads all your open tasks across every project, and writes the results into your sheet — sorted, flagged, and ready to share — in response to a single instruction.
Pull all incomplete TickTick tasks and write them to the 'Open Tasks' sheet with columns: Task Title, Project, Due Date, Priority — flag overdue tasks in column E with 'OVERDUE'.
What You Get
- All open tasks from every TickTick project appear in the 'Open Tasks' sheet.
- Columns A through D contain task title, project name, due date, and priority level.
- Tasks with due dates before today's date have 'OVERDUE' written into column E.
- The list is sorted by due date ascending so the most urgent items are at the top.
- Completed tasks are excluded — only open items appear.
What If the Data Is Not Quite Ready
You only want tasks from certain projects
You have personal tasks in TickTick alongside work tasks and don't want them mixed together.
Pull all incomplete TickTick tasks from the projects named 'Client Work', 'Engineering', and 'Operations' only, and write title, project, due date, and priority into columns A through D of the 'Open Tasks' sheet, sorted by due date ascending.
You want high-priority tasks highlighted separately
Your VA needs to know immediately which items are both overdue and high priority.
Fetch all open TickTick tasks and write them to the 'Open Tasks' sheet with title in A, project in B, due date in C, priority in D. In column E, write 'OVERDUE-HIGH' for tasks that are overdue and high priority, 'OVERDUE' for all other overdue tasks, and leave blank for on-time items.
You want a per-project summary tab as well
After the full list, you need a count by project so your VA can see where the work is concentrated.
Pull all open TickTick tasks into the 'Open Tasks' sheet (title in A, project in B, due date in C, priority in D, overdue flag in E), then create a second tab called 'Project Summary' that lists each project name and the count of its open tasks.
Full kill chain: pull, flag, summarize, and format in one shot
Fetch all incomplete TickTick tasks across all projects. Write them to the 'Open Tasks' sheet with columns: Task Title (A), Project (B), Due Date (C, formatted as MM/DD/YYYY), Priority (D), Status (E — 'OVERDUE' if past due, 'DUE TODAY' if due today, blank otherwise). Sort by due date ascending. Then in the 'Project Summary' tab, write each project name and its open task count. Clear both sheets before writing.
One instruction, both outputs, no manual follow-up — that's the pattern worth building around.
Try It
Get the 7-day free trial of SheetXAI and open a blank Google Sheet, then ask it to pull your entire open TickTick task list sorted by due date. Also see how to bulk-create tasks from a project plan or pull all tasks from a single project — or return to the TickTick integration hub.