Connectors

/

Freshdesk

/

Freshdesk and Capsule CRM account health brief
Report
Cross-Connector

Account health briefs from Freshdesk and Capsule CRM

For account leaders who want support and pipeline in one rated brief, just by asking their AI assistant about a customer.

Try PopdockAI free
Get a live demo
Freshdesk and Capsule CRM account health brief
Give me an account health brief for Northwind Traders over the last 90 days, using Freshdesk and Capsule CRM.
Northwind Traders is Amber: support load is rising while a renewal deal is still open. - Support: 34 tickets in 90 days, 9 open, 2 escalated, health score 62 - Pipeline: 1 open opportunity, 48,000, expected close 30 Nov - Cases: 2 open, highest severity High - Renewal: Freshdesk says 15 Dec, Capsule CRM says 30 Nov (flagged) Want the ticket volume broken down by priority?
Freshdesk
Sample figures. Your results come from your own account.
freshdesk-get-companies
freshdesk-get-tickets
freshdesk-get-time-entries
capsule-crm-get-party
capsule-crm-get-opportunity
capsule-crm-get-case

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Freshdesk

Freshdesk
Run it on your own Freshdesk data.

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

Try PopdockAI free

The problem

Account reviews built by hand are stale on arrival

An account review means pulling tickets and health score from Freshdesk, then opportunities and cases from Capsule CRM, and stitching them together. The numbers are stale by the time it is done, and renewal date mismatches slip by.

Without PopdockAI

  • Pull ticket counts and health score from Freshdesk
  • Look up opportunities and cases in Capsule CRM
  • Paste both into one page by hand
  • Miss that the renewal dates disagree

With PopdockAI

  • The company is found in Freshdesk, asking if several match
  • Tickets, priority mix and health score are read
  • Capsule CRM opportunities and cases are added
  • Renewal date mismatches are shown and 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 an account health brief for the customer named `{company-name}`, using the last `{lookback-days}` days (default 90) of activity.

**Step 1: Support side (freshdesk server)**

Call `freshdesk-get-companies` with `name.contains` set to `{company-name}`. If several match, list them and stop. Note `company-id`, `health-score`, `account-tier`, `renewal-date`. Call `freshdesk-get-tickets` with that `company-id` and `created-at.from` at the lookback start. Call `freshdesk-get-time-entries` for the ticket ids if hours spent are relevant.

**Step 2: Sales side (capsule-crm server)**

Call `capsule-crm-get-party` with `organization-name.contains` set to `{company-name}` and note the matching parties. Call `capsule-crm-get-opportunity` with `party-name.contains` set to `{company-name}` and `capsule-crm-get-case` with `party-name.contains` set to `{company-name}`.

**Step 3: Report**

Sections: Support (ticket volume, open vs resolved, escalations, average priority mix, health-score), Pipeline (open opportunities with value and expected-close-date), Cases (open cases and severity), Renewal (renewal-date from Freshdesk against expected-close-date of any renewal opportunity). End with an overall rating of Green, Amber or Red and the two facts that drove it.

**Rules & Guidelines:**

* `freshdesk-get-companies`, `freshdesk-get-tickets` and `freshdesk-get-time-entries` are on the freshdesk server; `capsule-crm-get-party`, `capsule-crm-get-opportunity` and `capsule-crm-get-case` are on the capsule-crm server.
* Read-only. Do not call any add, update or delete tool on either server.

**Validation:**

* If the customer exists in only one system, report that side and flag the gap.
* If renewal-date and the CRM close date disagree, show both and flag it.

Who it's for

One answer, three teams that use it

Executives

Get a quick health rating with reasons

A Green, Amber or Red rating with the two facts behind it tells you where an account stands in a minute.

How healthy is Contoso as an account? Use Freshdesk and Capsule CRM for the last 60 days.

Account managers

Prepare quarterly reviews in minutes

Ticket volume, open opportunities and cases come together in one brief, ready for the review meeting.

Prepare an account health brief for Fabrikam covering the last 180 days in Freshdesk and Capsule CRM.

Customer success managers

Catch renewal dates that disagree

When Freshdesk and the Capsule CRM renewal opportunity show different dates, both are shown so you can fix the right one.

Does the Northwind Traders renewal date in Freshdesk match the renewal opportunity in Capsule CRM?

How it works

What PopdockAI does when you ask

You name a customer and a period, and your AI assistant combines support and pipeline into one brief with a Green, Amber or Red rating. It shows both dates when the systems disagree.

01

Ask

You name the customer and, if you like, how many days to look back.

Your AI tool

02

Match

It finds the company in Freshdesk and stops to ask if several companies match.

freshdesk-get-companies

03

Gather

It reads tickets and health score from Freshdesk and opportunities and cases from Capsule CRM.

freshdesk-get-tickets
freshdesk-get-time-entries
capsule-crm-get-party
capsule-crm-get-opportunity
capsule-crm-get-case

04

Rate

It reports each side, flags renewal date mismatches and gives a Green, Amber or Red rating.

Your AI tool

What PopdockAI provides

The tools behind the answer

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

get-data

freshdesk-get-companies

Returns companies from Freshdesk, with filters on the fields that matter. Read-only.
get-data

freshdesk-get-tickets

Returns tickets from Freshdesk, with filters on the fields that matter. Read-only.
get-data

freshdesk-get-time-entries

Returns time entries from Freshdesk, with filters on the fields that matter. Read-only.
get-data

capsule-crm-get-party

Returns people and organizations from Capsule CRM with email, phone, job title, organization, location, owner and last contacted date. Filter by name, email, type, organization, owner, city, state or country.
get-data

capsule-crm-get-opportunity

Returns Capsule CRM sales opportunities with milestone, value, currency, probability, expected close date, owner and lost reason. Filter by name, party, owner, milestone, value range, expected close date or closed date.
get-data

capsule-crm-get-case

Returns Capsule CRM projects (cases) with status, owner, team, party, linked opportunity and last contacted date. Filter by name, status, party, owner, created date or closed date.
Read only.Nothing in Freshdesk 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

One current brief across support and pipeline

Try PopdockAI free
Get a live demo

Related use cases

More ways to put this data to work

All Ramp use cases

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