Connectors

/

Freshdesk

/

Freshdesk and Mailchimp customer profile by email
Report
Cross-Connector

Know a customer's tickets and Mailchimp status before replying

For support agents who want Freshdesk history and Mailchimp subscription status for one email, just by asking their AI assistant.

Try PopdockAI free
Get a live demo
Freshdesk and Mailchimp customer profile by email
Before I reply to dana@northwindtraders.com, give me her Freshdesk and Mailchimp profile for the last 90 days.
Dana looks at risk: she unsubscribed last week and has an open high priority ticket. - Identity: Dana Whitfield, Northwind Traders, not a VIP - Support: 3 tickets, 1 open (high priority, due tomorrow) - Email: unsubscribed, reason given as too many emails - Activity: 4 opens, 0 clicks before the unsubscribe Want the full ticket list?
Freshdesk
Sample figures. Your results come from your own account.
freshdesk-get-contacts
freshdesk-get-tickets
freshdesk-get-satisfaction-ratings
mailchimp-get-list-member
mailchimp-get-campaign-email-activity

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

Replying without knowing the customer just unsubscribed

Before replying, an agent checks Freshdesk for tickets and Mailchimp for subscription status and campaign activity. It is easy to miss that the person just unsubscribed, which changes how the reply should be pitched.

Without PopdockAI

  • Search Freshdesk for tickets and ratings
  • Look up the member in Mailchimp
  • Check unsubscribe reason, opens and bounces
  • Write the reply without the full picture

With PopdockAI

  • Freshdesk tickets and ratings are read for the email
  • Mailchimp status, unsubscribe reason and activity are added
  • A one line read says happy, engaged or at risk
  • A missing side is named 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:** Build a combined support and email-marketing profile for the person with email address {email}, looking back {lookback-days} days (default 90) for tickets and campaign activity.

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

Call `freshdesk-get-contacts` with `email` = {email}. If nothing matches, note that the person is not a Freshdesk contact and continue with Step 2. Then call `freshdesk-get-tickets` with `requester-email` = {email} and `created-at.from` set to the lookback start. Then call `freshdesk-get-satisfaction-ratings` with `user-id` = the contact's `contact-id` (skip if there is no contact).

**Step 2: Marketing side (mailchimp server)**

Call `mailchimp-get-list-member` with `email` = {email}. Carry the same address across, lower-cased and trimmed. If no list member exists, report the person as in Freshdesk but not subscribed in Mailchimp. Then call `mailchimp-get-campaign-email-activity` with `email-address` = {email} and `activity-date.from` set to the lookback start.

**Step 3: Report**

Give four short sections: Identity (name, company-id, list status, vip), Support (ticket counts by status, open tickets with subject, priority, due-by; ratings), Email (subscription status, unsubscribe-reason, recent action counts such as open, click, bounce), and a one-line read on whether the person is a happy, engaged customer or a risk.

**Rules & Guidelines:**

* Tools whose names start with freshdesk are on the freshdesk server; tools whose names start with mailchimp are on the mailchimp server. Both servers must be connected.
* This prompt is read-only. Do NOT call any `freshdesk-add-contact`, `freshdesk-update-contact`, `freshdesk-update-ticket`, `freshdesk-add-ticket-note`, `freshdesk-reply-to-ticket`, `mailchimp-add-list-member` or `mailchimp-update-list-member` tool, or any other add, update, delete, start, pause or replicate tool.

**Validation:**

* If either system returns nothing for the address, say which side is empty and still report the other.
* If `freshdesk-get-contacts` returns more than one contact for the address, list them and use the first, saying so.

Who it's for

One answer, three teams that use it

Support agents

Set the right tone before you reply

Know if the customer just unsubscribed or bounced, so your answer does not read like another marketing email.

Has lee@contoso.com unsubscribed from Mailchimp, and what tickets has he opened in Freshdesk?

Email marketers

Understand why someone unsubscribed

See the unsubscribe reason beside recent tickets, so you can tell a support problem from campaign fatigue.

Why did ana@fabrikam.com leave our Mailchimp list, and did she have Freshdesk tickets around then?

Customer success managers

Get a quick happy or at risk read

A one line verdict built on tickets, ratings and engagement helps you decide who needs attention.

Is sam@northwindtraders.com a happy customer or a risk, based on Freshdesk and Mailchimp?

How it works

What PopdockAI does when you ask

You give an email and a period, and your AI assistant returns a short profile in four sections. If the address is missing from one system, it still reports the other.

01

Ask

You give an email and how many days to look back.

Your AI tool

02

Support

It reads the Freshdesk contact, tickets and satisfaction ratings.

freshdesk-get-contacts
freshdesk-get-tickets
freshdesk-get-satisfaction-ratings

03

Email

It checks Mailchimp for list status, unsubscribe reason and recent campaign activity.

mailchimp-get-list-member
mailchimp-get-campaign-email-activity

04

Read

It reports four short sections and a one-line happy or at-risk read.

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

Returns contacts 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-satisfaction-ratings

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

mailchimp-get-list-member

Returns the members (subscribers) of Mailchimp audiences, with subscription status, tags and engagement rating. Filter by email address or status to look someone up.
get-data

mailchimp-get-campaign-email-activity

Returns each member's open, click and bounce events for Mailchimp campaigns, with timestamps and the URLs they clicked.
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

Pitch every reply to the customer in front of you

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