/
/
Put a customer OnePageCRM deals next to its Harvest billing
For sales teams who ask their AI assistant for a customer contacts, deals and next actions alongside invoices, hours and unbilled work.
On this page
Connector
Connect OnePageCRM, pick your AI tool and paste the prompt.
The problem
Deals in one system, billing in another
OnePageCRM holds the contacts and deals while Harvest holds invoices and hours. With no shared id, checking both means two searches and a risk of the wrong match.
Without PopdockAI
- Open the company in OnePageCRM and read deals
- Search Harvest for the same name
- Collect invoices, hours and unbilled work
- Check you matched the right customer
With PopdockAI
- Contacts, next actions and deals come from OnePageCRM
- The Harvest client is matched by name and the match is shown
- Invoices, hours and unbilled work are added
- Missing or unclear names are reported, not guessed
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Build one picture of `{customer-name}` by pairing its contacts and deals in OnePageCRM with its billing and delivery in Harvest, looking back `{lookback-days}` days (default 90).
**Step 1: Find the company in OnePageCRM**
Call `onepagecrm-get-company` with `name.contains` set to `{customer-name}`. If more than one distinct `name` comes back, list the names and stop to ask which is meant. Note its `id`, `name`, `pending-deals-count`, `total-pending-amount`, `won-deals-count` and `total-won-amount`. Then call `onepagecrm-get-contact` with `company-id` set to that `id` and note each person's name, `status`, `owner-id`, `next-action` and `next-action-date`. Call `onepagecrm-get-deal` with `company-id` set to the same `id` and note each deal's `name`, `status`, `stage`, `amount` and `expected-close-date`.
**Step 2: Find the client in Harvest**
Take the OnePageCRM company `name` and call `harvest-get-clients` with `name.contains` set to it. If nothing matches, retry once with `{customer-name}`. If there is still no match, report the company as present in OnePageCRM and absent from Harvest and go to Step 4. If more than one client matches, list them and stop.
**Step 3: Pull the Harvest side**
Using the client's `id` as `client-id`, call `harvest-get-invoices` (with `issue-date.from` set to the start of the window), `harvest-get-time-reports` (with `period-start` and `period-end` for the window) and `harvest-get-uninvoiced-report`. Collect invoiced amount, amount still due, hours, billable hours and uninvoiced amount.
**Step 4: Report**
Give two short sections, "OnePageCRM" (contacts with their next actions, open deals with amount and expected close, pending and won totals) and "Harvest billing" (invoiced, due, hours, uninvoiced). Finish with up to three observations that only make sense with both together, such as an open deal for a client with overdue invoices, or a client with heavy hours and no open deal.
**Rules & Guidelines:**
* Harvest tools (names starting harvest-) come from the harvest server and OnePageCRM tools (names starting onepagecrm-) come from the onepagecrm server. Both servers must be connected.
* OnePageCRM calls customers companies (and the people at them contacts) and Harvest calls them clients. There is no shared id, so match on name: exact (ignoring case, punctuation and suffixes such as Inc, LLC, Ltd) first, then one name containing the other, and always show which kind of match was used.
* This is read-only. Do NOT call any Harvest create, update, delete, stop or restart tool (for example `harvest-clients-create`, `harvest-contacts-create`, `harvest-invoices-create`, `harvest-estimates-create`, `harvest-time-entries-update`) and do NOT call `onepagecrm-add-contact`, `onepagecrm-add-deal`, `onepagecrm-add-note`, `onepagecrm-add-call`, `onepagecrm-add-meeting`, `onepagecrm-add-action`, `onepagecrm-update-contact`, `onepagecrm-update-deal`, `onepagecrm-update-action`, `onepagecrm-delete-contact` or `onepagecrm-delete-deal`.
* Hourly rates, cost rates and invoice amounts are sensitive: show them only because the user asked for billing context.
**Validation:**
* If OnePageCRM returns nothing, say so and still report the Harvest side if the client exists.
* If both systems return nothing, say the name matches nothing in either and suggest checking the spelling.
* State the exact date window used.Who it's for
One answer, three teams that use it
Sales reps
Walk into a call knowing the billing status
Your deals and next actions appear with what the customer owes, so you do not raise a new deal while an invoice is overdue.
Before I call Contoso, show their OnePageCRM deals and next actions and their Harvest invoices.
Account managers
Review a customer in one request
Hours, invoices and open deals are shown together, so you can judge the health of an account without two logins.
Give me a customer view of Northwind Traders across OnePageCRM and Harvest for 90 days.
Sales managers
Spot mismatches between effort and pipeline
Clients with heavy hours and no open deal stand out, as do open deals for clients with unpaid invoices.
Does Fabrikam have an open deal in OnePageCRM while invoices are overdue in Harvest?
How it works
What PopdockAI does when you ask
You name the customer and your AI assistant reads OnePageCRM and Harvest. It asks when the name is unclear and does not edit anything.
Ask
You name the customer and how far back to look.
Find
It finds the company in OnePageCRM with its contacts, next actions and deals.
Match
It finds the Harvest client by name and reads invoices, hours and unbilled work.
Report
You get a CRM section, a billing section and observations that need both.
What PopdockAI provides
The tools behind the answer
Ready made tools for OnePageCRM and one secure connection to your AI tool. No code, no exports.
onepagecrm-get-company
onepagecrm-get-contact
onepagecrm-get-deal
harvest-get-clients
harvest-get-invoices
harvest-get-time-reports
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
Account reviews that cover deals and billing
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)
