Connectors

/

Harvest

/

Harvest and Salesforce customer 360
Report
Cross-Connector

One summary of a customer across Salesforce and Harvest

For leaders who want a customer's pipeline and cases next to its hours and billing, by asking their AI assistant before a call or renewal.

Try PopdockAI free
Get a live demo
Harvest and Salesforce customer 360
Give me a customer 360 for Northwind Traders covering the last 90 days, with Salesforce and Harvest side by side.
Northwind Traders has an active renewal and a high-priority case, and a meaningful amount of unbilled work. - Pipeline: 1 open opportunity, Renewal 2027, Negotiation stage, USD 48,000 - Support: 1 open high-priority case, 6 days old - Delivery: 2 active projects, 312 hours in 90 days - Billing: USD 9,400 outstanding, USD 5,100 unbilled Want me to go deeper on the unbilled projects?
Harvest
Sample figures. Your results come from your own account.
salesforce-get-account
harvest-get-clients
salesforce-get-opportunity
salesforce-get-case
harvest-get-projects
harvest-get-time-reports
harvest-get-invoices
harvest-get-uninvoiced-report

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 customer view split across two tools

Pipeline and cases live in Salesforce, while hours, projects and billing live in Harvest. Opening both before a renewal leaves an incomplete picture and gaps nobody noticed.

Without PopdockAI

  • Open Salesforce for opportunities and cases
  • Open Harvest for projects, hours and invoices
  • Reconcile account and client names by hand
  • Miss a case on an account with heavy unbilled work

With PopdockAI

  • Both systems are read for the same customer
  • Ambiguous names stop and ask first
  • Open deals, cases, hours and balances are summarised
  • Missing data is reported as no data, nothing is changed

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 single view of `{customer-name}` joining Salesforce relationship data with Harvest delivery and billing data, covering the last `{lookback-days}` days for time (default 90).

**Step 1: Resolve the customer in both systems**

Call `salesforce-get-account` with `name.contains` = `{customer-name}` and `harvest-get-clients` with `name.contains` = `{customer-name}`. If either returns more than one record, list the matches and stop. If one side has no match, continue with the other side and say so.

**Step 2: Salesforce side (Salesforce server)**

With the `account-id`, call `salesforce-get-opportunity` (open ones, `closed` = false) and `salesforce-get-case` (open ones, `closed` = false).

**Step 3: Harvest side (Harvest server)**

With the Harvest client id, call `harvest-get-projects` (`client-id`, `active` = true), `harvest-get-time-reports` (`client-id`, `period-start` = today minus `{lookback-days}` days, `period-end` = today), `harvest-get-invoices` (`client-id`, `due-amount.min` = 0.01) and `harvest-get-uninvoiced-report` (`client-id`).

**Step 4: Report**

* Header: account name, owner, industry, Harvest currency.
* Pipeline: open opportunities with stage, amount, close date.
* Support: open cases with priority and age.
* Delivery: active projects, hours and billable amount over the period.
* Billing: outstanding invoice balance and unbilled amount.
* Three to five observations that only show up when the two sides are read together, for example a high-priority case on an account with heavy unbilled work.

**Rules & Guidelines:**

* `salesforce-get-account`, `salesforce-get-opportunity` and `salesforce-get-case` are on the Salesforce server. The `harvest-*` tools are on the Harvest server.
* Never call any Harvest tool whose name contains `-create`, `-update`, `-delete`, `-stop` or `-restart`, and never call `salesforce-add-*` or `salesforce-update-*` tools. This prompt is read-only.

**Validation:**

* State the currency of every amount; do not add Harvest and Salesforce amounts together.
* Do not infer a figure when a call returns nothing; write "no data".

Who it's for

One answer, three teams that use it

Executives

Prepare for a renewal in one read

See pipeline, support load, delivery effort and billing together, so the discussion starts from facts.

Prepare me for the Contoso renewal: Salesforce deals and cases plus Harvest hours and balances.

Account managers

Spot risk hiding between systems

Notice a high-priority case on an account with heavy unbilled work or a stalled opportunity.

Give me a 360 view of Fabrikam over the last 60 days.

Customer success leads

Check delivery and support together

Compare the hours invested with open cases and active projects before a quarterly business review.

For Adventure Works, show open cases in Salesforce and active projects and hours in Harvest.

How it works

What PopdockAI does when you ask

You name the customer and your AI assistant resolves it in both systems before reading anything. It joins the two views without adding amounts across systems or changing any record.

Ask

You name the customer and, optionally, how many days of time to cover.

Your AI tool

Resolve

It finds the Salesforce account and the Harvest client and stops if a name is ambiguous.

salesforce-get-account
harvest-get-clients
salesforce-get-opportunity
salesforce-get-case
harvest-get-projects
harvest-get-time-reports
harvest-get-invoices
harvest-get-uninvoiced-report

Read

It gathers open opportunities and cases, projects, hours, balances and unbilled work.

No items found.

Report

You get a sectioned summary with cross-system observations.

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

salesforce-get-account

Returns Salesforce accounts with their type, industry, owner, billing address, phone and annual revenue. Filter by name, account number, type, industry, owner, billing city or state, annual revenue and created date.
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

salesforce-get-opportunity

Returns Salesforce opportunities with their account, stage, amount, probability, close date, next step, owner and whether they are closed or won. Filter by name, account, stage, owner, amount, close date and closed and won flags.
get-data

salesforce-get-case

Returns Salesforce support cases with their subject, status, priority, origin, owner, account, contact and whether they are escalated or closed. Filter by case number, subject, status, priority, owner, account, contact email, closed flag and created date.
get-data

harvest-get-projects

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

harvest-get-time-reports

Returns time reports by client 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.
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

The whole customer relationship at a glance

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