/
/
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.
On this page
Connector
Connect Nutshell, pick your AI tool and paste the prompt.
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.
**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.
Find
It finds the company in Nutshell with its leads and contacts, and asks which one if several match.
Match
It finds the client in Harvest by name and reads invoices, hours and unbilled work.
Report
You get a pipeline section, a billing section and observations that need both.
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
nutshell-get-lead
nutshell-get-contact
harvest-get-clients
harvest-get-invoices
harvest-get-time-reports
harvest-get-uninvoiced-report
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
Customer conversations that use both views
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)
