Connectors

/

Todoist

/

Match Todoist collaborators to BigCommerce customers
Report
Cross-Connector

Find which project collaborators already buy from you

For sales teams who want to know which Todoist collaborators are BigCommerce customers, by asking their AI assistant.

Try PopdockAI free
Get a live demo
Match Todoist collaborators to BigCommerce customers
Which collaborators on my Todoist project Wholesale Pilot are also BigCommerce customers, and when did they last order?
3 of the 9 collaborators on Wholesale Pilot are BigCommerce customers. - Priya Shah, priya@contoso.com: customer 1204, 7 orders, last order 28 Oct - Tom Reyes, tom@fabrikam.com: customer 1388, 2 orders, last order 3 Sep - Dana Whitfield, dana@northwindtraders.com: customer 1415, 1 order, last order 12 Aug - Not matched: 5 collaborators, plus 1 with no email Want the full table with project roles?
Todoist
Sample figures. Your results come from your own account.
todoist-get-projects
todoist-get-collaborators
bigcommerce-get-customer
bigcommerce-get-order

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Todoist

Todoist
Run it on your own Todoist data.

Connect Todoist, pick your AI tool and paste the prompt.

Try PopdockAI free

The problem

Copying emails between two systems, one at a time

To find which project members are also store customers, you paste each Todoist email into BigCommerce and then check their orders. It is slow and a mistyped email gives a wrong answer.

Without PopdockAI

  • Open the Todoist project and list collaborators
  • Search BigCommerce for each email
  • Open each customer to count orders
  • Note the last order date by hand

With PopdockAI

  • Collaborators are read from the project you name
  • Each email is matched exactly, never on name
  • Order count and last order date are shown for each match
  • Several customers on one email are listed, not guessed

The prompt

Use this prompt

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

Prompt
**Objective:** For the Todoist project `{project-name}`, find which collaborators are also BigCommerce customers, by exact email match.

**Step 1: Find the project (Todoist server)**

Call `todoist-get-projects` with `name.contains` set to `{project-name}`. If more than one project matches, list them and stop. If none match, say so and stop. Keep `project-id`.

**Step 2: List collaborators (Todoist server)**

Call `todoist-get-collaborators` with `project-id` set to the project id. Keep `collaborator-id`, `name`, `email` and `project-role`. If there are none, report that and stop.

**Step 3: Look each one up (BigCommerce server)**

For each collaborator email call `bigcommerce-get-customer` with `email` set to it. Compare emails ignoring case. If a customer is found, also call `bigcommerce-get-order` with `customer-id` set to the customer `id` and note the order count and the most recent `date-created`.

**Step 4: Report**

Table: collaborator, email, project role, matched customer id (or "not a customer"), order count, last order date. Add the totals: collaborators checked, matched, not matched.

**Rules & Guidelines:**

* `todoist-get-projects` and `todoist-get-collaborators` are on the Todoist server. `bigcommerce-get-customer` and `bigcommerce-get-order` are on the BigCommerce server.
* Match on email only. Never match on name.
* Do not call any Todoist action tool (`todoist-add-task`, `todoist-update-task`, `todoist-close-task`, `todoist-reopen-task`, `todoist-delete-task`, `todoist-add-task-comment`, `todoist-add-project`, `todoist-add-section` or any other add, update, close, archive or delete tool) and do not call any BigCommerce add, update or delete tool. This prompt only reads.

**Validation:**

* A collaborator with no email is reported as "no email" and skipped.
* If an email returns more than one customer, list the ids and do not pick one.

Who it's for

One answer, three teams that use it

Sales reps

Spot customers among your contacts

See which people on a shared project already buy from your store, and how recently they ordered.

Which collaborators on my Todoist project Contoso Pilot are BigCommerce customers? Show their last order date.

Account managers

Review order history before a call

Check how many orders a project collaborator has placed before you speak to them.

Look up the collaborators on Todoist project Fabrikam Review in BigCommerce and show their order counts.

Sales operations

Link project members to store customers

Get customer ids for the collaborators who match, and a count of those who do not, for your records.

Match the Todoist project Northwind Partners collaborators to BigCommerce customers and give me the totals.

How it works

What PopdockAI does when you ask

You name the project and your AI assistant looks up each collaborator in BigCommerce. It only reads, so no customer or task data is changed.

Ask

You name a Todoist project.

Your AI tool

List

It finds the project and reads its collaborators with their emails and roles.

todoist-get-projects
todoist-get-collaborators
bigcommerce-get-customer
bigcommerce-get-order

Look up

It searches BigCommerce for a customer with each exact email and counts their orders.

No items found.

Report

You get a table of matches with order count and last order date, and totals.

Your AI tool

What PopdockAI provides

The tools behind the answer

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

get-data

todoist-get-projects

Returns projects from Todoist.
get-data

todoist-get-collaborators

Returns project collaborators from Todoist.
get-data

bigcommerce-get-customer

Returns customers from BigCommerce, with filters for the fields that matter on this list. Read-only; needs a BigCommerce connection.
get-data

bigcommerce-get-order

Returns orders from BigCommerce, with filters for the fields that matter on this list. Read-only; needs a BigCommerce connection.
Read only.Nothing in Todoist 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.

How Popdock AI secures your data

The outcome

Know which collaborators already buy from you

Try PopdockAI free
Get a live demo

Related use cases

More ways to put this data to work

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.

Try PopdockAI Free
See Documentation