/
/
A one page customer brief from billing and sales
For leaders and account owners who want invoices, budgets, deals and contacts for a customer before a call, just by asking their AI assistant.
On this page
Connector
Connect Pipedrive, pick your AI tool and paste the prompt.
The problem
Preparing for a customer call takes two tools
Billing sits in Harvest and the sales picture sits in Pipedrive, so a brief means opening both and combining them by hand. It is easy to miss an overdue invoice or a customer with no open deal.
Without PopdockAI
- Open Harvest for invoices, uninvoiced work and budgets
- Open Pipedrive for deals and contacts
- Copy figures into one place by hand
- Miss the overdue invoice or the missing deal
With PopdockAI
- Billing and sales are read from both systems for you
- Ambiguous names stop and ask instead of guessing
- Amounts keep their currency and are never mixed
- Cross-system observations are called out
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Produce a one-page account brief for the customer named `{customer-name}`, combining billing from Harvest with the sales picture from Pipedrive. Use invoices issued in the last `{lookback-days}` days (default 180).
**Step 1: Find the customer in Harvest**
Call `harvest-get-clients` with `name.contains` set to `{customer-name}`. If more than one client matches, list them (name, id) and stop to ask which one. If none match, say the customer is not in Harvest and continue with Step 3 only.
**Step 2: Read the billing position (Harvest)**
With the chosen client id, call `harvest-get-invoices` (filter `client-id`, `issue-date.from` set to the lookback start), `harvest-get-uninvoiced-report` (filter `client-id`) and `harvest-get-project-budget-report` (filter `client-id`, `active` true).
**Step 3: Find the same customer in Pipedrive**
Call `pipedrive-get-organization` with `name` set to the Harvest client name (or `name.contains` set to `{customer-name}` if the exact name returns nothing). If several organizations match, list them and stop to ask. If none match, report the customer as present in Harvest and absent from Pipedrive, and skip to Step 5.
**Step 4: Read the sales picture (Pipedrive)**
Take `organization-id` from that result and call `pipedrive-get-deal` with it as `organization-id` (all statuses), and `pipedrive-get-person` with it as `organization-id`.
**Step 5: Report**
Give: the customer, with the Harvest client id and Pipedrive organization id (or "not found"); invoiced total, paid total and total still due, with the count of overdue invoices; uninvoiced hours and amount; active project budgets and amount remaining; Pipedrive open deals (title, stage, value, expected close) and won deals; the contacts on file. End with up to three observations that only show up when both sides are read together, such as an open deal for a customer with overdue invoices, or a customer with active projects but no deal.
**Rules & Guidelines:**
* Harvest tools: `harvest-get-clients`, `harvest-get-invoices`, `harvest-get-uninvoiced-report`, `harvest-get-project-budget-report`. Pipedrive tools: `pipedrive-get-organization`, `pipedrive-get-deal`, `pipedrive-get-person`.
* Read-only. Do not call any create, update, add or delete tool on either server.
* Match customers by name only as a last resort and say so; never guess between two similar names.
* Show amounts with their currency and never add amounts in different currencies.
**Validation:**
* If either server returns no rows, say so plainly and report the other side alone.
* If the Harvest client name and the Pipedrive organization name differ slightly, show both spellings so the user can confirm they are the same company.Who it's for
One answer, three teams that use it
Account executives
Know the billing status before you call
See overdue invoices and active projects next to your open deals, so you do not raise a renewal with a customer who is behind on payment.
Brief me on Contoso before my renewal call: billing from Harvest, deals from Pipedrive.
Executives
Review a key account in one page
Get a single summary of money owed, work not yet billed and pipeline, without asking three people for screenshots.
Give me an account health summary for Fabrikam covering the last 90 days.
Customer success managers
Spot projects that need a follow up
See which active projects are low on budget and whether a deal already exists to cover the next phase.
Does Adventure Works have a deal open in Pipedrive, and how much budget is left on their Harvest projects?
How it works
What PopdockAI does when you ask
You name the customer and your AI assistant reads Harvest and Pipedrive for you. It never guesses between similar names and it changes nothing in either system.
Ask
You name the customer and, if you like, how many days of invoices to include.
Find
It matches the client in Harvest and the organization in Pipedrive, and stops if a name is ambiguous.
Read
It gathers invoices, uninvoiced work, project budgets, deals and contacts.
Report
You get the brief plus up to three observations from reading both sides together.
What PopdockAI provides
The tools behind the answer
Ready made tools for Pipedrive and one secure connection to your AI tool. No code, no exports.
harvest-get-clients
harvest-get-invoices
harvest-get-uninvoiced-report
harvest-get-project-budget-report
pipedrive-get-organization
pipedrive-get-deal
pipedrive-get-person
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
Walk into the call with the full picture
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)
