Connectors

/

Pipedrive

/

Pipedrive and Harvest account health brief
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Pipedrive and Harvest account health brief
I have a call with Northwind Traders at 3pm. Give me an account brief from Harvest and Pipedrive, using the last 180 days of invoices.
Northwind Traders is billed in Harvest but has one overdue invoice and no open deal in Pipedrive. - Billing: 3 invoices issued, 1 overdue (INV-1042), USD 4,800 still due - Uninvoiced work: 22.5 hours not yet billed - Projects: 2 active, one with 15 percent of budget remaining - Sales: no open deals, 1 won deal, 3 contacts on file Want the full list of contacts and project budgets?
Pipedrive
Sample figures. Your results come from your own account.
harvest-get-clients
harvest-get-invoices
harvest-get-uninvoiced-report
harvest-get-project-budget-report
pipedrive-get-organization
pipedrive-get-deal
pipedrive-get-person

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Pipedrive

Pipedrive
Run it on your own Pipedrive data.

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

Try PopdockAI free

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.

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

Your AI tool

Find

It matches the client in Harvest and the organization in Pipedrive, and stops if a name is ambiguous.

harvest-get-clients
harvest-get-invoices
harvest-get-uninvoiced-report
harvest-get-project-budget-report
pipedrive-get-organization
pipedrive-get-deal
pipedrive-get-person

Read

It gathers invoices, uninvoiced work, project budgets, deals and contacts.

No items found.

Report

You get the brief plus up to three observations from reading both sides together.

Your AI tool

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.

get-data

harvest-get-clients

Returns clients from Harvest. Read-only Get data tool for the Harvest connector; accepts the filters the list supports.
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

harvest-get-uninvoiced-report

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

harvest-get-project-budget-report

Returns project budget report 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-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 Pipedrive 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

Walk into the call with the full picture

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