Report

Cross-Connector

One overdue list from Capsule CRM and TickTick

For managers who want all of a person's overdue work in one table, just by asking their AI assistant to read Capsule CRM and TickTick.

Overdue Capsule CRM and TickTick work

Show me everything overdue for Sam Patel across Capsule CRM and TickTick, with the customer and who owns them.

Sam has 7 overdue items, 4 in Capsule CRM and 3 in TickTick. - Oldest: Send contract to Contoso, Capsule CRM, 21 days overdue - Customer owner: Contoso is owned by Lee Chen, last contacted 3 Sep - TickTick: Update Fabrikam proposal, 9 days overdue - Skipped: one TickTick task matched two customers, so no enrichment Want the full table sorted by days overdue?

Capsule CRM

Sample figures. Your results come from your own account.

capsule-crm-get-task

ticktick-get-tasks

capsule-crm-get-party

On this page

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Capsule CRM

Run it on your own Capsule CRM data.

Connect Capsule CRM, pick your AI tool and paste the prompt.

The problem

Overdue work is split across two lists

Overdue work is split between Capsule CRM tasks and a TickTick list, so nobody sees a person's full backlog. Working out which customer each late item belongs to, and who owns that customer, means more manual lookups.

Without PopdockAI

Filter Capsule CRM for overdue tasks
Check TickTick for overdue items separately
Look up the customer behind each item
Never see the full backlog in one place

With PopdockAI

Overdue tasks are read from both tools
Customers named in TickTick get owner and last contact added
One table sorted by days overdue, with a summary per source
Rows merge only when they truly match, nothing changed

The prompt

Use this prompt

Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.

Prompt

**Objective:** Produce one combined list of overdue work for {owner-name}: overdue Capsule CRM tasks plus overdue TickTick tasks, with the customer context for each.

**Step 1: Capsule (Capsule CRM server)**

Call `capsule-crm-get-task` with `owner-name` {owner-name}, open status and `due-date.to` yesterday. Keep description, party-name, opportunity-name, case-name, due-date.

**Step 2: TickTick (TickTick server)**

Call `ticktick-get-tasks` with open status and `due-date.to` yesterday, with `assignee` {assignee} when it is provided. Keep title, project-name, due-date, priority.

**Step 3: Enrich**

For each TickTick task whose title or tags name a Capsule party, call `capsule-crm-get-party` with `name.contains` set to that name and add the party's owner-name and last-contacted-date. Skip enrichment when the match is ambiguous.

**Step 4: Report**

One table sorted by days overdue, with columns Source (Capsule or TickTick), Item, Customer, Due date, Days overdue. Add a one-line summary per source.

**Rules & Guidelines:**

* `ticktick-*` tools belong to the TickTick MCP server; `capsule-crm-*` tools belong to the Capsule CRM MCP server. Both servers must be connected.
* This is read-only. Do NOT call any `ticktick-add-task`, `ticktick-update-task`, `ticktick-complete-task`, `ticktick-delete-task`, `ticktick-add-comment`, `capsule-crm-add-note`, `capsule-crm-add-task`, `capsule-crm-update-task` or any other add/update/delete/complete tool.

**Validation:**

* If a source returns nothing, say there is no overdue work there and continue.
* Never merge two items into one row unless they share a title and a due date.

Who it's for

One answer, three teams that use it

Sales directors

See a rep's full backlog

Review everything overdue for a person across both tools in one table.

Show me everything overdue for Priya Shah across Capsule CRM and TickTick.

Account managers

Catch up after a busy week

See all your late items with the customer and owner beside each.

What is overdue for me in Capsule CRM and TickTick? I am Jo Lee.

Operations managers

Find customers being let down

See which customers have overdue work and when they were last contacted.

List Tom Reyes's overdue work across both tools with each customer's last contact date.

How it works

What PopdockAI does when you ask

You name a person and your AI assistant combines their overdue Capsule CRM and TickTick work. It skips ambiguous matches and changes nothing.

Ask

You name the person whose overdue work you want.

Your AI tool

Read

It reads overdue Capsule CRM tasks and overdue TickTick tasks.

capsule-crm-get-task

ticktick-get-tasks

Enrich

It adds customer owner and last contacted date, skipping ambiguous matches.

capsule-crm-get-party

Report

It shows one table by days overdue with a summary per source.

Your AI tool

What PopdockAI provides

The tools behind the answer

Ready made tools for Capsule CRM and one secure connection to your AI tool. No code, no exports.

get-data

capsule-crm-get-task

Returns Capsule CRM tasks with due date, status, owner, category and the linked party, opportunity or project. Filter by status, due date range, owner, category, party or description.

get-data

ticktick-get-tasks

Returns open TickTick tasks with their project, due date, priority, status, assignee and tags. Filter by project, due date range or status.

get-data

capsule-crm-get-party

Returns people and organizations from Capsule CRM with email, phone, job title, organization, location, owner and last contacted date. Filter by name, email, type, organization, owner, city, state or country.

Read only.Nothing in Capsule CRM Changes

This report is built from Get data tools only. PopdockAI applies the row, field and parameter rules your admin sets, and every query is written to the audit trail.

The outcome

One overdue list with customer context

Related use cases

More ways to put this data to work

Capsule CRM customer activity and TickTick focus time

Ask your AI to show a Capsule CRM customer timeline beside the TickTick tasks and focus minutes spent on that customer. Read-only.

Learn More

Reconcile Capsule CRM and TickTick tasks

Ask your AI to reconcile Capsule CRM and TickTick tasks and it lists the ones missing or mismatched on each side. Read-only.

Learn More

Capsule CRM account brief

Ask your AI for a Capsule CRM account brief and it pulls open and recently closed deals, projects, open tasks and recent contact, with up to three watch-outs.

Learn More

Create Capsule CRM tasks for GoTo Webinar no-shows

Ask your AI to follow up webinar no-shows and it finds who registered but missed it, matches them to Capsule CRM by email, and creates owner tasks after you confirm.

Learn More

Create Capsule CRM tasks for hot Drip leads

Ask your AI to follow up hot Drip leads and it matches high-scoring active subscribers to Capsule CRM by email, skips anyone already being chased, and creates tasks after you confirm.

Learn More

One prompt template with infinite possibilities.

‍

Your AI assistant adapts its approach, tone, and capabilities to match each unique context while you maintain a single, manageable workflow.

Join forward-thinking companies that are transforming their operations with intelligent, secure AI automation.