Connectors

/

OnePageCRM

/

OnePageCRM and Harvest customer 360 view
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
OnePageCRM and Harvest customer 360 view
What is going on with Fabrikam? Show me their OnePageCRM deals and next actions and what Harvest says about billing over the last 60 days.
Fabrikam has an open deal and an overdue invoice, which is worth knowing before the next call. - OnePageCRM: 2 contacts, next action for Priya Shah on Friday, 1 open deal worth 12,000.00 expected to close Dec 5 - Harvest billing: 9,300.00 invoiced, 3,100.00 due, 76 hours, 4.0 hours unbilled - Match: exact name match, 60 day window ending today - Observation: open deal and a due invoice for the same client Want the deal details?
OnePageCRM
Sample figures. Your results come from your own account.
onepagecrm-get-company
onepagecrm-get-contact
onepagecrm-get-deal
harvest-get-clients
harvest-get-invoices
harvest-get-time-reports
harvest-get-uninvoiced-report

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

OnePageCRM

OnePageCRM
Run it on your own OnePageCRM data.

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

Try PopdockAI free

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.

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

Your AI tool

Find

It finds the company in OnePageCRM with its contacts, next actions and deals.

onepagecrm-get-company
onepagecrm-get-contact
onepagecrm-get-deal
harvest-get-clients
harvest-get-invoices
harvest-get-time-reports
harvest-get-uninvoiced-report

Match

It finds the Harvest client by name and reads invoices, hours and unbilled work.

No items found.

Report

You get a CRM section, a billing section and observations that need both.

Your AI tool

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.

get-data

onepagecrm-get-company

Returns companies from OnePageCRM, with their details and linked contacts.
get-data

onepagecrm-get-contact

Returns contacts from OnePageCRM, with name, company, email, phone, owner and next action. Filter to find one contact or a group.
get-data

onepagecrm-get-deal

Returns deals from OnePageCRM, with their stage, status, amount, expected close date, owner and linked contact or company. Filter by stage, status or 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

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-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-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 OnePageCRM 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

Account reviews that cover deals and billing

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