/
/
See a client's billing and deals in one view
For leaders who ask their AI assistant whether a client's Harvest invoices and HubSpot deals tell the same story.
On this page
Connector
Connect Harvest, pick your AI tool and paste the prompt.
The problem
Pipeline and billing live in different tools
To compare a client's deals with its billing someone opens HubSpot and Harvest and adds figures by hand. States and currencies differ, so mismatches slip through.
Without PopdockAI
- Open estimates and invoices in Harvest
- Open the client's deals in HubSpot
- Add totals by state in a spreadsheet
- Miss won deals with nothing billed
With PopdockAI
- Billing totals and deals gathered together
- Totals by state and stage laid out
- Mismatches flagged for a closer look
- Currency shown, nothing changed in either tool
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Build a combined billing and pipeline view for the client named `{client-name}`, looking at Harvest records issued since `{since-date}` (default the start of the current year).
**Step 1: Find the client (Harvest server)**
Call `harvest-get-clients` with `name.contains` set to `{client-name}`. If more than one client matches, list them and stop. Keep the client `id` and `name`.
**Step 2: Billing (Harvest server)**
Call `harvest-get-estimates` with `client-id` and `issue-date.from` set to `{since-date}`. Call `harvest-get-invoices` with `client-id` and `issue-date.from` set to `{since-date}`. Total the estimates by `state` and the invoices by `state`, and total the balance in `due-amount`.
**Step 3: Pipeline (HubSpot server)**
Call `hubspot-get-companies` with `company-name` set to the Harvest client `name` (retry with `company-name.contains`). If none or several match, say so. Otherwise call `hubspot-get-deals` with the company `record-id` as `company-id`.
**Step 4: Report**
Show: estimates by state with totals, invoices by state with total billed, paid and outstanding, HubSpot deals by stage with amounts, and a short list of mismatches worth a look, for example a won deal with no estimate or invoice, or an accepted estimate with no matching deal.
**Rules & Guidelines:**
* Harvest tools: `harvest-get-clients`, `harvest-get-estimates`, `harvest-get-invoices`. HubSpot tools: `hubspot-get-companies`, `hubspot-get-deals`.
* Read-only. Do not call any create or update tool on either server.
**Validation:**
* If the client is not in Harvest, say so and stop. If it is in Harvest but not HubSpot, still report the billing side.
* Do not assume currencies match; show the currency beside every amount.Who it's for
One answer, three teams that use it
Executives
Check a key account at a glance
See billed, paid and outstanding amounts beside the deals in play for a major client.
Compare billing and pipeline for Contoso since the start of the year.
Sales leaders
Find won deals not yet billed
Spot deals marked won that have no estimate or invoice in Harvest.
For Fabrikam, are there any won HubSpot deals with no Harvest estimate or invoice?
Finance managers
Check estimates against the pipeline
Confirm accepted estimates have a matching deal and outstanding balances are visible.
Show Northwind Traders accepted estimates and outstanding invoices next to its HubSpot deals.
How it works
What PopdockAI does when you ask
You name the client and your AI assistant reads Harvest and HubSpot. It only reads, and it still reports billing when the client is not in HubSpot.
Ask
You name the client and a start date.
Bill
It totals Harvest estimates and invoices by state.
Pipeline
It finds the HubSpot company and lists its deals by stage.
Report
You get both views and a short list of mismatches.
What PopdockAI provides
The tools behind the answer
Ready made tools for Harvest and one secure connection to your AI tool. No code, no exports.
harvest-get-clients
harvest-get-estimates
harvest-get-invoices
hubspot-get-companies
hubspot-get-deals
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 whether deals and billing agree
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)
