Connectors

/

HubSpot

/

Review a HubSpot contact's Contivio calls
Report
Cross-Connector

One history of a HubSpot contact's calls and tickets

For support reps who want a contact's Contivio calls, HubSpot calls and tickets in one view, just by asking their AI assistant.

Try PopdockAI free
Get a live demo
Review a HubSpot contact's Contivio calls
Build a call and ticket history for dana@northwindtraders.com from the last 30 days, and show which Contivio calls are logged in HubSpot.
Dana Whitfield had 4 Contivio calls and 2 tickets in 30 days. 1 of the calls is not logged in HubSpot. - Contivio calls: 4, latest 4 Nov inbound with Sam Patel, summary says delivery delay - HubSpot calls: 3 logged, outcome mostly connected - Tickets: Delivery delay (open, high), Invoice copy (closed, normal) - Not logged: the 2 Nov outbound call has no matching HubSpot call She has mainly been calling about a delayed delivery. Want the full call tables?
HubSpot
Sample figures. Your results come from your own account.
hubspot-get-contacts
contivio-get-call
hubspot-get-calls
hubspot-get-tickets

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

HubSpot

HubSpot
Run it on your own HubSpot data.

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

Try PopdockAI free

The problem

Call history is split across the phone platform and HubSpot

To see everything a customer has done you open the phone platform, then HubSpot for calls and tickets. Matching them by hand is slow, and unlogged calls and tickets are missed.

Without PopdockAI

  • Find the contact in HubSpot
  • Search the phone platform for their number
  • Open HubSpot calls and tickets separately
  • Overlook calls that were never logged

With PopdockAI

  • The contact is found by email, and ambiguity stops the job
  • Calls are matched on the last 9 digits of the number
  • Contivio calls, HubSpot calls and tickets sit side by side
  • Each call is marked logged or not logged in HubSpot

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 a combined call and ticket history for the HubSpot contact with email `{contact-email}` over the last `{lookback-days}` days (default 30).

**Step 1: Find the contact in HubSpot**

Call `hubspot-get-contacts` (HubSpot server) with `email` = `{contact-email}`. If more than one contact matches, list them (record-id, name, company-name) and stop. If none matches, report that and stop. Keep `record-id`, `first-name`, `last-name` and `phone-number`.

**Step 2: Find the contact's Contivio calls**

Call `contivio-get-call` (Contivio server) with `start-time.from` set to the start of the lookback window. The tool has no phone filter, so keep only calls where `from` or `to` matches the contact's `phone-number` after stripping spaces, dashes and brackets and comparing the last 9 digits. If the contact has no phone-number, say so and skip to Step 3.

**Step 3: Find HubSpot activity**

Call `hubspot-get-calls` (HubSpot server) with `contact-id` = the record-id and `activity-date.from` for the window. Call `hubspot-get-tickets` (HubSpot server) with `contact-id` = the record-id.

**Step 4: Report**

Give a table of Contivio calls (start-time, direction, queue, agent, result, talk-duration-seconds, ai-short-summary), a table of HubSpot calls (activity-date, call-direction, call-outcome, summary), and a table of tickets (ticket-name, ticket-status, priority, create-date). Mark each Contivio call as logged in HubSpot or not logged, matching on the same direction and a start within 10 minutes. End with a two-sentence reading of what the customer has been calling about.

**Rules & Guidelines:**

* `contivio-get-call` is on the Contivio server; every tool whose name starts with hubspot is on the HubSpot server.
* This is read-only. Do not call any hubspot-add-*, hubspot-update-*, hubspot-subscribe-contact, hubspot-unsubscribe-contact, hubspot-remove-list-members or hubspot-import-file-from-url tool. Do not call any other Contivio tool except `contivio-get-call`.

**Validation:**

* If Contivio returns no matching calls, say so and still report the HubSpot side.
* If phone formats differ (country codes, leading zeros), match on the last 9 digits and note the assumption.

Who it's for

One answer, three teams that use it

Support reps

Know what the customer has already said

See their calls with AI summaries and any open tickets in one place before you reply.

Show the call and ticket history for priya@contoso.com over the last 30 days.

Support team leads

Find calls missing from HubSpot

Each Contivio call is marked logged or not logged, which shows where agents are not recording contact.

For tom@fabrikam.com, which Contivio calls in the last 14 days are not logged as calls in HubSpot?

Account managers

Understand what a customer is calling about

A short reading of the call topics together with open tickets helps you prepare for an account conversation.

Review dana@northwindtraders.com in HubSpot and Contivio for the last 60 days and tell me what they have been calling about.

How it works

What PopdockAI does when you ask

You give the contact's email and your AI assistant reads HubSpot and Contivio. It only reads data and never writes to HubSpot.

Ask

You give the contact's email and how far back to look.

Your AI tool

Find

It finds the HubSpot contact and stops if none or several match.

hubspot-get-contacts
contivio-get-call
hubspot-get-calls
hubspot-get-tickets

Gather

It matches Contivio calls on the last 9 digits of the phone number and reads their HubSpot calls and tickets.

No items found.

Report

You get three tables, each Contivio call marked logged or not, and a short reading of the topics.

Your AI tool

What PopdockAI provides

The tools behind the answer

Ready made tools for HubSpot and one secure connection to your AI tool. No code, no exports.

get-data

hubspot-get-contacts

Returns contact records from HubSpot CRM, with email, phone, company, lifecycle stage, lead status, owner and location from the HubSpot connector. Filter by company id, state region, contact owner, email, last name, create date, company name, record id, lifecycle stage, lead status.
get-data

contivio-get-call

Returns Contivio call records with durations, results, direction, queue, agent and AI call summaries, filterable by date, agent, queue and customer.
get-data

hubspot-get-calls

Returns calls logged in HubSpot, with direction, status, outcome, duration and the associated contact, company and deal from the HubSpot connector. Filter by call status, call title, activity assigned to, call direction, company id, activity date, contact id.
get-data

hubspot-get-tickets

Returns support tickets from HubSpot, with name, status, priority, category, owner, dates and associated contact and company from the HubSpot connector. Filter by category, record id, priority, ticket name, create date, ticket status, company id, contact id, ticket owner.
Read only.Nothing in HubSpot 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 complete customer story in one report

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