/
/
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.
On this page
Connector
Connect Harvest, pick your AI tool and paste the prompt.
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.
**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.
Resolve
It finds the Salesforce account and the Harvest client and stops if a name is ambiguous.
Read
It gathers open opportunities and cases, projects, hours, balances and unbilled work.
Report
You get a sectioned summary with cross-system observations.
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.
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
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
The whole customer relationship at a glance
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)
