Connectors

/

Attio

/

Attio deals at risk from open Zendesk tickets
Report
Cross-Connector

Find Attio deals put at risk by open Zendesk tickets

For sales teams who want their AI assistant to flag deals whose customers have open urgent Zendesk tickets.

Try PopdockAI free
Get a live demo
Attio deals at risk from open Zendesk tickets
Which deals in the Negotiation stage have customers with open urgent Zendesk tickets?
2 of the 9 Negotiation deals have open urgent Zendesk tickets, worth 61,000 USD in total. - Northwind Traders: Renewal 2027, 36,000 USD, 2 tickets, oldest 6 Oct - Contoso: Platform rollout, 25,000 USD, 1 ticket, oldest 21 Oct - No Zendesk match: 2 companies - No matching tickets: 5 deals Want the ticket subjects for each?
Attio
Sample figures. Your results come from your own account.
attio-get-record-deals
attio-get-record-companies
zendesk-get-organization
zendesk-get-ticket

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Attio

Attio
Run it on your own Attio data.

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

Try PopdockAI free

The problem

Unhappy customers stall deals before reps find out

Open urgent tickets sit in Zendesk where reps never see them, so they learn a customer is unhappy only after a deal stalls. Checking each deal's company against Zendesk by hand takes more time than anyone has.

Without PopdockAI

  • List the deals in a stage from Attio
  • Look up each company's organization in Zendesk
  • Count open tickets at each priority by hand
  • Treat an unmatched company as a clean one

With PopdockAI

  • Deals in the stage are read with their company domains
  • Zendesk organizations are matched on domain
  • Open tickets at the chosen priority are counted per deal
  • Companies with no Zendesk match are counted separately

The prompt

Use this prompt

Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.

Prompt
**Objective:** Find Attio deals in stage `{deal-stage}` whose customer has open Zendesk tickets at priority `{priority}` (default urgent).

**Step 1: List the deals**

Call `attio-get-record-deals` (Attio server) with `deal-stage` set to the stage and `max-records` 50. If none come back, say so and stop. Keep `deal-name`, `deal-value`, `deal-owner` and `associated-company`.

**Step 2: Find each company's domains**

For each distinct `associated-company`, call `attio-get-record-companies` (Attio server) with `name` set to that company. Keep `domains`. If a name matches several companies, mark that deal as ambiguous and skip it.

**Step 3: Check Zendesk**

For each company, call `zendesk-get-organization` (Zendesk server) with `domain-names.contains` set to its domain; keep the organization `name`. Then call `zendesk-get-ticket` (Zendesk server) with `organization-name`, `priority` set to the requested priority and `status` set to open. Note that `status` values depend on the Zendesk account; if a filter returns nothing, retry without `status` and exclude solved and closed tickets yourself.

**Step 4: Report**

A table of deals with at least one such ticket: deal, value, owner, company, ticket count, oldest ticket `created-date`, newest `subject`. Sort by deal value, largest first. Then list companies with no Zendesk organization match separately, and the count of deals with no matching tickets.

**Rules & Guidelines:**

* `attio-*` tools are on the Attio server; `zendesk-*` tools are on the Zendesk server.
* Read-only. Do not call `attio-update-deal`, `zendesk-update-ticket` or `zendesk-add-ticket-comment`.

**Validation:**

* Match on domain, never on a partial company name alone.
* Say how many companies were checked and how many had no Zendesk match, so a quiet result is not mistaken for a clean one.

Who it's for

One answer, three teams that use it

Sales managers

Find at risk deals before they stall

Deals with open urgent tickets are ranked by value, so you know which conversations need support involved first.

Which Proposal stage deals in Attio have customers with open high priority Zendesk tickets?

Account executives

Know about support trouble before the customer raises it

See the oldest ticket and newest subject for each exposed deal, so you can raise it first.

Show me deals in Negotiation that have open urgent tickets in Zendesk, with the oldest ticket date.

Support managers

Prioritise tickets that touch revenue

Know which open tickets belong to customers in late stage deals, so they get looked at first.

List Attio deals in the Contract Sent stage whose companies have open normal priority Zendesk tickets.

How it works

What PopdockAI does when you ask

You name a deal stage and your AI assistant checks each deal's customer in Zendesk. Ambiguous companies are skipped and nothing is written to either system.

01

Ask

You name the deal stage and, optionally, the ticket priority.

Your AI tool

02

List

It reads the Attio deals in that stage and finds each company's domains.

attio-get-record-deals
attio-get-record-companies

03

Check

It matches Zendesk organizations on domain and counts the open tickets at that priority.

zendesk-get-organization
zendesk-get-ticket

04

Report

You get exposed deals by value, plus companies with no Zendesk match.

Your AI tool

What PopdockAI provides

The tools behind the answer

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

get-data

attio-get-record-deals

Returns deals from Attio CRM. Read-only; filter by the fields the tool offers.
get-data

attio-get-record-companies

Returns companies from Attio CRM. Read-only; filter by the fields the tool offers.
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.
Read only.Nothing in Attio 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

See which deals are exposed to open tickets

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