Connectors

/

Freshdesk

/

Freshdesk and Salesforce contact sync gap report
Report
Cross-Connector

Find contacts missing between Freshdesk and Salesforce

For integration owners who want to see which of a company's contacts exist in only one system, just by asking their AI assistant.

Try PopdockAI free
Get a live demo
Freshdesk and Salesforce contact sync gap report
Which Northwind Traders contacts are in Freshdesk but not Salesforce, or the other way round?
Northwind Traders has 3 contacts that exist in only one system. - Freshdesk only: Dana Whitfield, dana@northwindtraders.com, Operations Manager - Salesforce only: Lee Ortiz, lee@northwindtraders.com, Buyer - Salesforce only: Priya Nair, priya@northwindtraders.com, Finance Lead - In both: 14 contacts, 1 contact without an email set aside Want the list of contacts found in both?
Freshdesk
Sample figures. Your results come from your own account.
freshdesk-get-companies
freshdesk-get-contacts
salesforce-get-account
salesforce-get-contact

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

Contact lists drift apart between help desk and CRM

Contacts in Freshdesk and Salesforce drift over time, and finding who is missing means exporting both and comparing by eye. Without an agreed key, people get matched on similar names and the gaps stay hidden.

Without PopdockAI

  • Export the company's contacts from both systems
  • Compare names and emails in a spreadsheet
  • Match people on similar names
  • Leave the real gaps hidden

With PopdockAI

  • The company and account are found, stopping if either is ambiguous
  • Contacts are matched by email, never by name alone
  • Freshdesk only, Salesforce only and both are listed with counts
  • Contacts with no email are set aside, 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:** Find contacts of `{company-name}` that exist in Freshdesk but not Salesforce, or the reverse, matching on email address.

**Step 1: Freshdesk contacts**

Call `freshdesk-get-companies` with name.contains set to the company name. If more than one matches, list them and stop. Then call `freshdesk-get-contacts` with company-id from that company and active set to true. Keep name, email and job title.

**Step 2: Salesforce contacts**

Call `salesforce-get-account` with name.contains set to the company name; if more than one matches, list them and stop. Then call `salesforce-get-contact` with account-id from that account. Keep name, email and title.

**Step 3: Match by email**

Compare emails case-insensitively. A contact with no email cannot be matched; list those separately. Do not match on name alone.

**Step 4: Report**

Three lists: in Freshdesk only, in Salesforce only, in both. For each gap give name, email and title. Finish with the counts.

**Rules & Guidelines:**

* reshdesk-* tools are on the freshdesk server and salesforce-* tools are on the salesforce server; both servers must be connected.
* This prompt is read-only. Never call any freshdesk add, update, delete or reply tool (such as reshdesk-add-ticket-note, reshdesk-update-ticket, reshdesk-reply-to-ticket) or any salesforce add or update tool (such as salesforce-add-case, salesforce-add-contact, salesforce-update-account).

**Validation:**

* If the company is missing from one system, report that and stop instead of listing every contact as a gap.
* If a contact list reached the max-records limit, say the list may be incomplete.

Who it's for

One answer, three teams that use it

Integration owners

Check the sync is doing its job

Three lists show which contacts exist in only one system, so you can trace the sync gap to real people.

Compare Contoso contacts in Freshdesk and Salesforce by email and list who is only in one system.

Salesforce admins

Find contacts the CRM never received

Freshdesk only contacts with name, email and title tell you exactly what to add or investigate.

Which Fabrikam contacts are in Freshdesk but missing from the Salesforce account?

Support operations

Make sure the help desk knows every contact

Salesforce only contacts show who could write in without being recognised by Freshdesk.

List Northwind Traders contacts that exist in Salesforce but not in Freshdesk, with their titles.

How it works

What PopdockAI does when you ask

You name a company and your AI assistant compares its contacts in Freshdesk and Salesforce by email. It stops if one system lacks the company or several records match.

01

Ask

You name the company to compare.

Your AI tool

02

Match

It finds the company in Freshdesk and the account in Salesforce, stopping if either is ambiguous.

freshdesk-get-companies
salesforce-get-account

03

Compare

It matches contacts by email, setting aside any with no email.

freshdesk-get-contacts
salesforce-get-contact

04

Report

It lists Freshdesk only, Salesforce only and both, with counts.

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

Returns contacts from Freshdesk, with filters on the fields that matter. Read-only.
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-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.
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

Know exactly who is missing on each side

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