Connectors

/

Chorus

/

Reconcile Chorus and Harvest team members
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Reconcile Chorus and Harvest team members
Compare our active Chorus users with our Harvest users for the last 30 days and show who is missing from either.
18 people are in both systems, 2 are only in Chorus and 3 are only in Harvest. - Chorus only: Priya Shah, a seller with no Harvest user - Harvest only: Tom Reyes, 34 hours and no Chorus user - Harvest only: Sam Patel, 0 hours - No email in Harvest: 1 user listed separately as unmatched Want the Chorus role and team for the people in both?
Chorus
Sample figures. Your results come from your own account.
chorus-get-users
harvest-get-users
harvest-get-time-reports-team

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Chorus

Chorus
Run it on your own Chorus data.

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

Try PopdockAI free

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.

Prompt
**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.

Your AI tool

Read

It collects active users from Chorus and from Harvest, with hours for the period.

chorus-get-users
harvest-get-users
harvest-get-time-reports-team

Match

It matches on email address only and sets aside Harvest users with no email.

No items found.

Report

You get counts, then people in both, in Chorus only and in Harvest only.

Your AI tool

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.

get-data

chorus-get-users

Returns Chorus users, with their name, email, title, role, license type and whether the account is active. Use it for license reviews and for matching reps to their conversations.
get-data

harvest-get-users

Returns users from Harvest. Read-only Get data tool for the Harvest connector; accepts the filters the list supports.
get-data

harvest-get-time-reports-team

Returns time reports by team from Harvest. Read-only Get data tool for the Harvest connector; accepts the filters the list supports.
Read only.Nothing in Chorus 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

A clear view of who is in which system

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