Connectors

/

Nutshell

/

Nutshell and Harvest customer 360 view
Report
Cross-Connector

See a customer pipeline and billing in one view

For sales teams who ask their AI assistant to put a customer Nutshell leads and contacts next to its Harvest invoices, hours and unbilled work.

Try PopdockAI free
Get a live demo
Nutshell and Harvest customer 360 view
Give me the full picture on Northwind Traders: what is open in Nutshell and what Harvest shows for billing and hours over the last 90 days.
Northwind Traders has one open lead and a clean billing history, with some work not yet invoiced. - Nutshell pipeline: owner Sam Patel, 1 open lead worth 24,000.00, 3 contacts - Harvest billing: 18,600.00 invoiced, 2,100.00 due, 142 hours, 12.5 hours uninvoiced - Match: exact name match, 90 day window ending today - Observation: open lead with unbilled hours, a good moment to invoice Want the lead and invoice details?
Nutshell
Sample figures. Your results come from your own account.
nutshell-get-account
nutshell-get-lead
nutshell-get-contact
harvest-get-clients
harvest-get-invoices
harvest-get-time-reports
harvest-get-uninvoiced-report

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

Pipeline and billing sit in different systems

Nutshell knows the deals and Harvest knows the invoices and hours, with no shared id. Combining them by hand takes time and risks matching the wrong customer.

Without PopdockAI

  • Find the company in Nutshell and read its leads
  • Search for the same name in Harvest
  • Collect invoices, hours and unbilled work
  • Hope you matched the right customer

With PopdockAI

  • The company is found in Nutshell with leads and contacts
  • The Harvest client is matched by name and the match is shown
  • Invoices, hours and unbilled work are added
  • Ambiguous or missing names are reported, 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:** Build one picture of `{customer-name}` by pairing its pipeline in Nutshell with its billing and delivery in Harvest, looking back `{lookback-days}` days (default 90).

**Step 1: Find the company in Nutshell**

Call `nutshell-get-account` with `name.contains` set to `{customer-name}`. If more than one distinct `name` comes back, list the names and stop to ask which is meant. Note its `id`, `owner`, `account-type`, `last-contacted`, `number-of-leads` and `open-leads`. Then call `nutshell-get-lead` with `company-id` set to that `id` and note each lead's `name`, `status`, `value`, `confidence` and `anticipated-close-time`. Call `nutshell-get-contact` with `company-id` set to the same `id` and count the people.

**Step 2: Find the client in Harvest**

Take the Nutshell `name` and call `harvest-get-clients` with `name.contains` set to it. If nothing matches, retry once with `{customer-name}`. If there is still no match, report the company as present in Nutshell and absent from Harvest and go to Step 4. If more than one client matches, list them and stop.

**Step 3: Pull the Harvest side**

Using the client's `id` as `client-id`, call `harvest-get-invoices` (with `issue-date.from` set to the start of the window), `harvest-get-time-reports` (with `period-start` and `period-end` for the window) and `harvest-get-uninvoiced-report`. Collect invoiced amount, amount still due, hours, billable hours and uninvoiced amount.

**Step 4: Report**

Give two short sections, "Nutshell pipeline" (owner, last contacted, open leads with value and expected close, number of contacts) and "Harvest billing" (invoiced, due, hours, uninvoiced). Finish with up to three observations that only make sense with both together, such as an open lead for a client with overdue invoices, or a client with heavy hours and no open pipeline.

**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 Nutshell returns nothing, say so and still report the Harvest side if the client exists.
* If both systems return nothing, say the name matches nothing in either and suggest checking the spelling.
* State the exact date window used.

Who it's for

One answer, three teams that use it

Account executives

Prepare for a customer meeting

Open leads, contacts and billing status appear together, so you know what is in play and what they owe before you talk.

Before my call with Contoso, show their open Nutshell leads and Harvest invoices.

Customer success

Check work against pipeline

Heavy hours with no open pipeline, or the reverse, stand out when both systems are shown together.

Does Fabrikam have a lot of hours in Harvest but no open lead in Nutshell?

Sales managers

Review an account without opening two tools

You can see owner, last contact and billing in a single answer and decide whether the account needs attention.

Summarise Northwind Traders across Nutshell and Harvest for the last 60 days.

How it works

What PopdockAI does when you ask

You name the customer and your AI assistant reads Nutshell and Harvest. It asks when the name is unclear and never edits records.

Ask

You name the customer and how far back to look.

Your AI tool

Find

It finds the company in Nutshell with its leads and contacts, and asks which one if several match.

nutshell-get-account
nutshell-get-lead
nutshell-get-contact
harvest-get-clients
harvest-get-invoices
harvest-get-time-reports
harvest-get-uninvoiced-report

Match

It finds the client in Harvest by name and reads invoices, hours and unbilled work.

No items found.

Report

You get a pipeline section, a billing section and observations that need both.

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

nutshell-get-lead

Returns Nutshell leads (deals) with status, value, confidence, close date, owner and source. Filter by status, owner and dates.
get-data

nutshell-get-contact

Returns Nutshell people (contacts) with their emails, phones and linked companies. Filter by name, email, owner and other 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.
get-data

harvest-get-invoices

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

harvest-get-time-reports

Returns time reports by client from Harvest. Read-only Get data tool for the Harvest connector; accepts the filters the list supports.
get-data

harvest-get-uninvoiced-report

Returns uninvoiced report 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

Customer conversations that use both views

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