Connectors

/

Nutshell

/

Find won Nutshell leads missing a Harvest client
Report
Cross-Connector

Never invoice a new customer late because no client exists

For finance teams who ask their AI assistant which recently won Nutshell leads still need a client set up in Harvest.

Try PopdockAI free
Get a live demo
Find won Nutshell leads missing a Harvest client
Which leads did we win in Nutshell in October that do not have a client in Harvest yet?
Of 9 leads won in October, 3 have no Harvest client yet. - Needs a client: Lead 1184 Website rebuild, Contoso, 18,000.00, closed Oct 9, owner Sam Patel - Needs a client: Lead 1190 Support retainer, Fabrikam, 6,500.00, closed Oct 17 - No company on lead: Lead 1193 Training package - Already have a client: 5, for example Northwind Traders matched exactly Want the list of the 5 matched leads?
Nutshell
Sample figures. Your results come from your own account.
nutshell-get-lead
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

Won deals reach billing by memory

When a Nutshell lead is won, billing hears about it by email or by chance. If nobody creates the Harvest client, the first invoice goes out late or not at all.

Without PopdockAI

  • List recently won leads in Nutshell
  • Search Harvest for each company
  • Note which ones have no client
  • Tell billing by email and hope

With PopdockAI

  • Won leads are read for the date range
  • Each company is checked against Harvest clients
  • Missing clients are listed with value and owner
  • Loose and ambiguous matches are shown, nothing is created

The prompt

Use this prompt

Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.

Prompt
**Objective:** Find leads won in Nutshell between `{won-from}` and `{won-to}` (default: the last 30 days) whose company has no client in Harvest, so that billing can be set up.

**Step 1: Read won leads (Nutshell server)**

Call `nutshell-get-lead` with `status` set to the won status (use the value the account uses for won leads; if unsure, call it once without `status` and look at the distinct `status` values), `closed-time.from` set to `{won-from}` and `closed-time.to` set to `{won-to}`. Keep `name`, `number`, `value`, `closed-time`, `owner` and `companies`.

**Step 2: Check Harvest (Harvest server)**

For each distinct company name in `companies`, call `harvest-get-clients` with `name.contains` set to it. A lead whose company has an exact or loose match is "has client". If a lead has no company, list it separately as "no company on lead".

**Step 3: Report**

Give a table of leads with no Harvest client: lead number and name, company, value, closed date, owner. Then list the leads that already have a client, with the matched client name. End with the counts.

**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 no leads were won in the window, say so and stop.
* If a company name matches more than one client, list the candidates rather than choosing.
* State the exact dates used.

Who it's for

One answer, three teams that use it

Billing coordinators

Set up clients before the first invoice

You get a short list of won leads that still need a Harvest client, with the details needed to create one.

Which Nutshell leads were won in the last 30 days with no client in Harvest?

Sales operations

Close the handoff between sales and billing

You can check that every closed lead made it to billing and chase the owner of any that did not.

Show me won leads from this quarter whose company is not a Harvest client, with the lead owner.

Finance managers

Catch revenue that has not started billing

Won value with no client is visible in one list, so late billing is caught before it affects cash flow.

Which won Nutshell leads over 10,000 in October are missing a Harvest client?

How it works

What PopdockAI does when you ask

You set the won period and your AI assistant reads Nutshell and Harvest. It reports the gaps and leaves creating clients to you.

Ask

You give the won dates, or leave it at the last 30 days.

Your AI tool

Read

It reads the leads won in Nutshell in that period.

nutshell-get-lead
harvest-get-clients

Check

It looks for each company among the Harvest clients by name.

No items found.

Report

You get leads that need a client, leads that already have one and leads with no company, 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-lead

Returns Nutshell leads (deals) with status, value, confidence, close date, owner and source. Filter by status, owner and dates.
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

Every won customer ready to be billed

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