Connectors

/

Nutshell

/

Reconcile Nutshell companies with Harvest clients
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Reconcile Nutshell companies with Harvest clients
Compare our Nutshell companies with Harvest clients and show me which ones are in only one system.
Nutshell has 6 companies with no Harvest client, and Harvest has 2 clients with no Nutshell company. - Companies with no client: Contoso (4 leads), Adventure Works (2 leads), 4 others - Clients with no company: Tailspin Toys, Wingtip Retail - Loose matches: Northwind Traders in Nutshell and Northwind Traders Ltd in Harvest - Note: a company with no client is informational, since prospects are not billed yet Want the full list of the 6 companies?
Nutshell
Sample figures. Your results come from your own account.
nutshell-get-account
harvest-get-clients

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Nutshell

Nutshell
Run it on your own Nutshell data.

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

Try PopdockAI free

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.

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

Your AI tool

Read

It reads Nutshell companies and active Harvest clients.

nutshell-get-account
harvest-get-clients

Match

It marks each pair exact, loose or unmatched and does not guess further.

No items found.

Report

You get companies with no client, clients with no company and loose matches, with counts.

Your AI tool

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.

get-data

nutshell-get-account

Returns Nutshell companies (accounts) with their contact details, owner and related fields. Filter by name, owner and other company fields.
get-data

harvest-get-clients

Returns clients from Harvest. Read-only Get data tool for the Harvest connector; accepts the filters the list supports.
Read only.Nothing in Nutshell 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 customers exist where

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