Connectors

/

Salesforce

/

Salesforce account brief with Zendesk support
Report
Cross-Connector

Combine Salesforce deals and Zendesk support in one brief

For account teams preparing a renewal who want commercial position and support history together, by asking their AI assistant.

Try PopdockAI free
Get a live demo
Salesforce account brief with Zendesk support
Prepare a renewal brief for Northwind Traders with Salesforce deals and Zendesk support from the last 90 days.
Northwind Traders renews on 2026-12-31 with 1 open deal and 23 Zendesk tickets in 90 days. - Support: 5 unsolved, 2 high priority - CSAT: 14 good, 3 bad, one citing slow replies - Top requester: Jordan Lee, 9 tickets - Not in Salesforce: 2 ticket requesters Want the full brief with the three talking points?
Salesforce
Sample figures. Your results come from your own account.
salesforce-get-account
salesforce-get-opportunity
salesforce-get-contract
salesforce-get-contact
salesforce-get-task
zendesk-get-organization
zendesk-get-ticket
zendesk-get-satisfaction-rating

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Salesforce

Salesforce
Run it on your own Salesforce data.

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

Try PopdockAI free

The problem

An hour of searching two systems before every renewal

Before a renewal the account team pulls deals, contracts and tasks from Salesforce, then asks support for ticket history and ratings from Zendesk. Assembling it takes an hour, and tickets from contacts outside the organization are missed.

Without PopdockAI

  • Pull deals, contracts and tasks from Salesforce
  • Ask support for the Zendesk ticket history
  • Search tickets contact by contact
  • Miss requesters who are not in Salesforce

With PopdockAI

  • Deals, contracts, contacts and open tasks are read for you
  • The account is matched to one Zendesk organization
  • Tickets by organization and contact email are merged without double counting
  • Read only, with three talking points from the data

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 a brief on the Salesforce account {account-name}, covering its commercial position in Salesforce and its support history in Zendesk over the last {lookback-days} days (default 90), for a renewal or account review meeting.

**Step 1: Find the account in Salesforce**

Call `salesforce-get-account` with `name` set to {account-name}. If nothing comes back, call it again with `name.contains`. If more than one account matches, list them (`name`, `account-id`, `billing-city`, `owner`) and stop so the user can pick one.

With the `account-id`:

* call `salesforce-get-opportunity` with `account-id` and `closed` set to false for open pipeline;
* call `salesforce-get-contract` with `account-id` for contract `status`, `start-date` and `end-date`;
* call `salesforce-get-contact` with `account-id` for contacts and their `email` addresses;
* call `salesforce-get-task` with `account-id` and `closed` set to false for open follow-ups.

**Step 2: Match the account in Zendesk**

**How to match a Salesforce account to a Zendesk organization (use this order, stop at the first hit):**

1. Call `zendesk-get-organization` with `external-id` set to the Salesforce `account-id`.
2. If nothing comes back, call `zendesk-get-organization` with `name` set to the Salesforce account `name` exactly.
3. If still nothing, take the domain from the account's `website` (strip `http://`, `https://`, `www.` and any path) and call `zendesk-get-organization` with `domain-names.contains` set to it.
4. If more than one organization matches at any step, list them and treat the account as ambiguous rather than guessing.
5. If none match, report the account as "No Zendesk organization found" and continue with the next account.

Once matched, use the Zendesk organization's own `name` (not the Salesforce account name) as `organization-name` on `zendesk-get-ticket`, since the two systems can spell the company differently.

**Step 3: Pull support history from Zendesk**

* Call `zendesk-get-ticket` with `organization-name` and `created.from` set to {lookback-days} days ago (default 90).
* For each Salesforce contact with an `email`, call `zendesk-get-ticket` with `requester-email` and the same `created.from` to catch tickets not filed under the organization. Merge by `ticket-id` so no ticket is counted twice.
* For each ticket, call `zendesk-get-satisfaction-rating` with `ticket-id` (at most 25 tickets).

**Step 4: Report**

* **Account:** name, owner, annual revenue, industry, rating.
* **Commercial:** open opportunities (name, stage, amount, close date), active and upcoming contract end dates, open Salesforce tasks.
* **Support:** tickets in the window by status and priority, unsolved tickets listed with subject, priority and age, CSAT good/bad counts with any bad-rating comments quoted.
* **Contacts raising tickets:** which Salesforce contacts filed tickets and how many each.
* **Talking points:** three short bullets the account team should raise, based only on the data above.

**Rules & Guidelines:**

* Salesforce tools start with "salesforce-" and come from the Salesforce MCP server. Zendesk tools start with "zendesk-" and come from the Zendesk MCP server. Both servers must be connected.
* This prompt is read-only. Do NOT call any write tool on either server, including `salesforce-add-task`, `salesforce-update-task`, `salesforce-add-case`, `salesforce-update-case`, `salesforce-update-account`, `salesforce-update-opportunity`, `zendesk-add-ticket`, `zendesk-update-ticket`, `zendesk-add-ticket-comment`, `zendesk-update-organization` or `zendesk-update-user`.

**Validation:**

* If no Zendesk organization matches, still run the `requester-email` searches, and say the organization link is missing.
* If a Zendesk requester email has no Salesforce contact, list it under "Ticket requesters not in Salesforce".

Who it's for

One answer, three teams that use it

Account executives

Walk into renewals knowing the support story

See ticket history and satisfaction next to the deal so the renewal call has no surprises.

Build a renewal brief for Contoso with Salesforce deals and contracts plus Zendesk tickets from the last 6 months.

Customer success managers

Prepare account reviews faster

Get commercial and support history in one brief, including who is raising tickets.

Which Fabrikam contacts raised Zendesk tickets this quarter, and what is open in Salesforce for them?

Support managers

Give account teams the full picture

Share a support summary that includes requesters missing from Salesforce, without building a report.

Summarise Northwind Traders support history in Zendesk for the last 90 days alongside their Salesforce account.

How it works

What PopdockAI does when you ask

You name the account and a period, and your AI assistant combines its Salesforce position with its Zendesk support history. Nothing is changed in either system.

01

Ask

You name the Salesforce account and a lookback period.

Your AI tool

02

Read

It reads open deals, contracts, contacts and open tasks from Salesforce.

salesforce-get-account
salesforce-get-opportunity
salesforce-get-contract
salesforce-get-contact
salesforce-get-task

03

Match

It finds the Zendesk organization and tickets by organization and contact email.

zendesk-get-organization
zendesk-get-ticket
zendesk-get-satisfaction-rating

04

Report

You get one brief with support history and three talking points, with nothing changed.

Your AI tool

What PopdockAI provides

The tools behind the answer

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

get-data

salesforce-get-account

Returns Salesforce accounts with their type, industry, owner, billing address, phone and annual revenue. Filter by name, account number, type, industry, owner, billing city or state, annual revenue and created date.
get-data

salesforce-get-opportunity

Returns Salesforce opportunities with their account, stage, amount, probability, close date, next step, owner and whether they are closed or won. Filter by name, account, stage, owner, amount, close date and closed and won flags.
get-data

salesforce-get-contract

Returns Salesforce contracts with their account, status, term, start and end dates, price book and signatories. Filter by contract number, account, owner, status and start and end date.
get-data

salesforce-get-contact

Returns Salesforce contacts with their account, title, department, email, phone, mailing address, owner and lead source. Filter by name, email, account, title, owner, lead source and mailing city or state.
get-data

salesforce-get-task

Returns Salesforce tasks with their subject, due date, priority, status, assignee and the record they relate to. Filter by subject, assigned user, account, related record, contact or lead, status, priority, closed flag and due date.
get-data

zendesk-get-organization

Returns Zendesk organizations, the customer companies your users belong to, with their domains, tags and notes.
get-data

zendesk-get-ticket

Returns Zendesk support tickets with their status, priority, requester, assignee, group and organization. Filter by status, priority, assignee, group or dates to find the tickets you need.
get-data

zendesk-get-satisfaction-rating

Returns Zendesk customer satisfaction (CSAT) ratings with the score, the customer's comment and reason, and the ticket, agent and group they relate to. Filter by score or date to find bad ratings.
Read only.Nothing in Salesforce 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 accurate brief instead of an hour of searching

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