Connectors

/

Harvest

/

Overdue Harvest invoices with Pipedrive sales context
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Overdue Harvest invoices with Pipedrive sales context
Which Harvest invoices are more than 45 days overdue, and is anyone in sales talking to those customers in Pipedrive?
Two clients are more than 45 days overdue, and one of them has an open deal. - Contoso Ltd: INV-1042, 61 days overdue, USD 6,200 due; open deal in negotiation - Latest note: Procurement reviewing the renewal terms - Fabrikam: INV-1051, 48 days overdue, EUR 1,900 due; not in Pipedrive - Contact for Contoso: Priya Shah Should I widen this to invoices 30 days overdue?
Harvest
Sample figures. Your results come from your own account.
harvest-get-invoices
pipedrive-get-organization
pipedrive-get-deal
pipedrive-get-note
pipedrive-get-person

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Harvest

Harvest
Run it on your own Harvest data.

Connect Harvest, pick your AI tool and paste the prompt.

Try PopdockAI free

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.

Prompt
**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.

Your AI tool

Read

It lists overdue Harvest invoices by client with totals per currency.

harvest-get-invoices
pipedrive-get-organization
pipedrive-get-deal
pipedrive-get-note
pipedrive-get-person

Context

It finds each client in Pipedrive and reads open deals, recent notes and contacts.

No items found.

Report

You get one section per client, largest amount first, with open deals flagged.

Your AI tool

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.

get-data

harvest-get-invoices

Returns invoices from Harvest. Read-only Get data tool for the Harvest connector; accepts the filters the list supports.
get-data

pipedrive-get-organization

Returns Pipedrive organizations with address, industry, size, owner and open and won deal counts. Filter by name, city, state, country, industry or owner.
get-data

pipedrive-get-deal

Returns Pipedrive deals with stage, pipeline, value, probability, owner and expected close date. Filter by status, stage, owner, organization, value range, expected close date range or title.
get-data

pipedrive-get-note

Returns notes attached to Pipedrive deals, people, organizations and leads. Filter by record, created date range or note text.
get-data

pipedrive-get-person

Returns Pipedrive contacts with email, phone, job title, organization, owner and last activity date. Filter by name, email, city, organization or owner.
Read only.Nothing in Harvest 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

Collections that respect the sales conversation

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