/
/
Chase overdue invoices with the sales context in hand
For finance and collections teams who want to see open deals and recent notes next to every overdue Harvest invoice, by asking their AI assistant.
On this page
Connector
Connect Harvest, pick your AI tool and paste the prompt.
The problem
A reminder that lands in the middle of a deal
Overdue invoices come from Harvest, but the story behind the customer is in Pipedrive. Chasing payment without checking can clash with an open deal or a conversation sales is already having.
Without PopdockAI
- Filter Harvest for invoices past due
- Search Pipedrive for each customer one at a time
- Read deal stages and notes separately
- Call the customer and find out sales is mid negotiation
With PopdockAI
- Overdue invoices are grouped by client for you
- Open deals, notes and contacts are read from Pipedrive
- Clients missing from Pipedrive are reported, not guessed
- No reminder is sent and nothing is recorded
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** For every Harvest invoice more than `{days-overdue}` days overdue (default 30), show what is happening with that customer in Pipedrive before anyone chases payment.
**Step 1: Read overdue invoices (Harvest)**
Call `harvest-get-invoices` with `state` set to open and `due-date.to` set to today minus `{days-overdue}` days. Group the invoices by client and total the `due-amount` per client.
**Step 2: Find each customer in Pipedrive**
For each client, call `pipedrive-get-organization` with `name` set to the client name. If there is no match, record "not in Pipedrive" and continue.
**Step 3: Read the sales context (Pipedrive)**
With the `organization-id`, call `pipedrive-get-deal` (filter `organization-id`, `status` open) and `pipedrive-get-note` (filter `organization-id`, newest first, at most 3). Call `pipedrive-get-person` with `organization-id` to get the contact names.
**Step 4: Report**
One section per client, largest amount due first: invoices (number, due date, days overdue, amount due), open deals (title, stage, value, expected close), the latest notes, and the people to contact. Flag clients with an open deal, because chasing payment may need to be coordinated with the deal owner.
**Rules & Guidelines:**
* Harvest tools: `harvest-get-invoices`. Pipedrive tools: `pipedrive-get-organization`, `pipedrive-get-deal`, `pipedrive-get-note`, `pipedrive-get-person`.
* Read-only. Do not call `harvest-invoice-messages-create`, `harvest-invoice-payments-create`, `pipedrive-add-activity`, `pipedrive-add-note` or any other write tool.
* Do not draft or send any reminder; only report.
**Validation:**
* If there are no overdue invoices, say so and stop.
* Never add amounts in different currencies; total them per currency.Who it's for
One answer, three teams that use it
Collections staff
Know who to speak to before you chase
See contact names and the latest sales notes for each overdue customer, so the first call is to the right person with the right tone.
List Harvest invoices over 30 days overdue and show the Pipedrive contacts for each client.
Finance managers
See which overdue balances need coordination
Customers with an open deal are flagged, so payment chasing can be agreed with the deal owner first.
Which overdue Harvest clients also have open deals in Pipedrive?
Sales managers
Protect deals from awkward payment calls
Check whether your accounts are behind on invoices before a reminder goes out.
Is Northwind Traders overdue in Harvest, and what are the latest notes on their Pipedrive deal?
How it works
What PopdockAI does when you ask
You set the overdue threshold and your AI assistant reads Harvest and then Pipedrive. It reports what it finds and leaves every message and note to you.
Ask
You say how many days overdue to look for.
Read
It lists overdue Harvest invoices by client with totals per currency.
Context
It finds each client in Pipedrive and reads open deals, recent notes and contacts.
Report
You get one section per client, largest amount first, with open deals flagged.
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-invoices
pipedrive-get-organization
pipedrive-get-deal
pipedrive-get-note
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
Collections that respect the sales conversation
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)
