/
/
Keep Nutshell companies and Harvest clients in step
For operations teams who ask their AI assistant to compare Nutshell companies with Harvest clients and list what exists in only one.
On this page
Connector
Connect Nutshell, pick your AI tool and paste the prompt.
The problem
CRM and billing customer lists drift apart
Companies live in Nutshell and clients live in Harvest, and nobody keeps the two in step. Comparing exports by eye misses renamed and duplicate records.
Without PopdockAI
- Export companies from Nutshell
- Export clients from Harvest
- Compare names side by side in a spreadsheet
- Argue over which near matches are the same
With PopdockAI
- Both lists are read in one request
- Pairs are marked exact, loose or unmatched
- Loose matches are left for you to confirm
- Empty or truncated lists are flagged, nothing changes
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Compare Nutshell companies with Harvest clients, optionally only names containing `{name-contains}`, and report what exists in one system but not the other. Fetch at most `{max-records}` records per system (default 200).
**Step 1: Read Nutshell companies (Nutshell server)**
Call `nutshell-get-account`. If `{name-contains}` is not empty, pass it as `name.contains`. Pass `max-records`. Keep `name`, `id`, `account-type`, `number-of-leads` and `owner`.
**Step 2: Read Harvest clients (Harvest server)**
Call `harvest-get-clients` with `active` set to true. If `{name-contains}` is not empty, pass it as `name.contains`. Keep `name` and `id`.
**Step 3: Match**
Match each Nutshell `name` to a Harvest client `name`. Mark each pair exact, loose (one name contains the other) or unmatched. Do not guess beyond that.
**Step 4: Report**
Give three lists: companies with no client (most leads first), clients with no company, and loose matches with both names side by side. End with the count of each.
**Rules & Guidelines:**
* Harvest tools (names starting harvest-) come from the harvest server and Nutshell tools (names starting nutshell-) come from the nutshell server. Both servers must be connected.
* Nutshell calls customers companies or accounts and Harvest calls them clients. There is no shared id, so match on name: exact (ignoring case, punctuation and suffixes such as Inc, LLC, Ltd) first, then one name containing the other, and always show which kind of match was used.
* This is read-only. Do NOT call any Harvest create, update, delete, stop or restart tool (for example `harvest-clients-create`, `harvest-contacts-create`, `harvest-invoices-create`, `harvest-estimates-create`, `harvest-time-entries-update`) and do NOT call `nutshell-add-company`, `nutshell-add-person`, `nutshell-add-lead`, `nutshell-add-activity`, `nutshell-update-person`, `nutshell-update-lead`, `nutshell-update-company`, `nutshell-delete-person`, `nutshell-delete-company` or `nutshell-delete-lead`.
* Hourly rates, cost rates and invoice amounts are sensitive: show them only because the user asked for billing context.
**Validation:**
* If either system returns nothing, say so and stop; do not report the other side as all unmatched.
* If a call returns exactly the max-records limit, warn that the lists may be truncated.
* A company with no client is not an error (prospects are not billed yet); label it as informational.Who it's for
One answer, three teams that use it
Sales operations
Keep CRM companies and billing clients aligned
You see which Nutshell companies have no Harvest client, ordered by lead count, so the busiest gaps come first.
Which Nutshell companies with open leads have no client in Harvest?
Billing administrators
Find clients that no longer have a company
Harvest clients with no Nutshell company show up, so you can check whether they are retired or simply named differently.
List active Harvest clients that do not appear as companies in Nutshell.
Data stewards
Review near matches in one place
Loose matches are shown with both names side by side, so you can confirm which are the same customer.
Compare Nutshell and Harvest names containing Fabrikam and show the loose matches.
How it works
What PopdockAI does when you ask
You ask for the comparison and your AI assistant reads Nutshell and Harvest. It only reads and never decides a loose match for you.
Ask
You say whether to check everything or only names containing some text.
Read
It reads Nutshell companies and active Harvest clients.
Match
It marks each pair exact, loose or unmatched and does not guess further.
Report
You get companies with no client, clients with no company and loose matches, with counts.
What PopdockAI provides
The tools behind the answer
Ready made tools for Nutshell and one secure connection to your AI tool. No code, no exports.
nutshell-get-account
harvest-get-clients
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
Know which customers exist where
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)
