/
/
Find users who exist in Chorus or Harvest but not both
For IT and integration teams who want licensed Chorus users matched to Harvest users by email, by asking their AI assistant.
On this page
Connector
Connect Chorus, pick your AI tool and paste the prompt.
The problem
User lists drift apart as people come and go
Licenses in Chorus and accounts in Harvest change as people join and leave, and the two lists are compared by hand. Matching on names risks pairing the wrong people.
Without PopdockAI
- Export users from Chorus and from Harvest
- Compare the two lists side by side
- Match people by name and hope
- Miss who has hours but no license
With PopdockAI
- Active users are read from both systems
- Matching uses email address only
- Users with no email are listed apart
- One-sided users are shown with Harvest hours, no rates
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Compare the people licensed in Chorus with the people set up in Harvest, and for the period `{period-start}` to `{period-end}` (default: last 30 days) show who is active in one but not the other.
**Step 1: Chorus users**
Call `chorus-get-users` with `active` set to true. Record `name`, `email`, `license-type`, `role` and `primary-team` for each.
**Step 2: Harvest users**
Call `harvest-get-users` with `active` set to true. Record `first-name`, `last-name`, `email`, `contractor` and `weekly-capacity`. Then call `harvest-get-time-reports-team` with `period-start` and `period-end` to get each person's `total-hours`, joined to the user by `user-id` or `user-name`.
**Step 3: Match on email**
Match the two lists on email address, ignoring case. Do not match on name. Collect: people in Chorus only, people in Harvest only, and people in both.
**Step 4: Report**
Three sections: "In both" with Chorus role, team and Harvest hours for the period; "Chorus only" (a seller with no Harvest user); "Harvest only" with their hours, flagging any with hours but no Chorus user. Keep it short and give counts first. Do not show cost rates.
**Rules & Guidelines:**
* Harvest tools (names starting harvest-) come from the harvest server and Chorus tools (names starting chorus-) come from the chorus server. Both servers must be connected.
* This is read-only. Do NOT call any Harvest create, update, delete or restart tool (for example `harvest-clients-create`, `harvest-contacts-create`, `harvest-invoices-create`, `harvest-estimates-create`, `harvest-invoices-update`, `harvest-time-entries-create`). Chorus has no write tools here.
* Chorus calls its customers accounts and Harvest calls them clients. The only link is the name, so match on exact name first, then a case-insensitive contains match, and always show which kind of match was used.
* Hourly rates, cost rates and invoice amounts are sensitive: show them only because the user asked for billing context.
**Validation:**
* If a Harvest user has no email, list them separately as unmatched.
* If either side returns nothing, say so and stop.Who it's for
One answer, three teams that use it
IT administrators
Keep licenses tidy
Find active Chorus users with no Harvest user, so seats are not held by people who have left or moved on.
Which active Chorus users do not have a Harvest user?
Integration engineers
Verify the email match
Check that both systems agree on who is active, with users that have no email set aside rather than guessed.
Compare Chorus and Harvest users by email and list anyone with no email in Harvest.
Sales operations
Find time logged without a Chorus seat
See people who logged Harvest hours in the period but have no Chorus user, so the gap can be closed.
Who in Harvest logged hours last month but has no Chorus user?
How it works
What PopdockAI does when you ask
You choose a period. Your AI assistant reads users in Chorus and Harvest and matches them on email. Both must be connected, and nothing is changed in either system.
Ask
You give a period, or accept the last 30 days.
Read
It collects active users from Chorus and from Harvest, with hours for the period.
Match
It matches on email address only and sets aside Harvest users with no email.
Report
You get counts, then people in both, in Chorus only and in Harvest only.
What PopdockAI provides
The tools behind the answer
Ready made tools for Chorus and one secure connection to your AI tool. No code, no exports.
chorus-get-users
harvest-get-users
harvest-get-time-reports-team
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
A clear view of who is in which system
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.

.webp)
