Freshdesk Customer Effort Scorer

AI-powered weekly customer effort scoring that bridges Freshdesk support data with Pipedrive deal value — identifies high-effort, high-value accounts at risk of churning before it's too late.

Every Monday, AI pulls your Freshdesk tickets by company, enriches with Pipedrive deal value, and scores customer effort across 5 dimensions: ticket volume per ARR, escalation frequency, response round depth, CSAT trajectory, and time-to-resolution trend. HIGH effort accounts get Slack alerts with deal value context. All accounts get a Notion scorecard. 29+3 node split-workflow. 5 agents. SINGLE-MODEL Sonnet 4.6.

triggerSchedule01FetcherFreshdesk API02EnricherPipedrive CRM03Assembler5 CES Metrics04AnalystCES Scoring05FormatterScorecard + AlertNotionScorecardSlackEffort Alert

Five Agents. Customer Effort Scoring. Notion + Slack Delivery.

Fetcher

Step 1 — Fetcher

Code Only

Pulls all tickets by company from Freshdesk API for the configured lookback window (default 30 days). Groups tickets by company with metadata: escalation status, CSAT ratings, conversation counts, resolution times. Zero LLM cost.

Enricher

Step 2 — Enricher

Code Only

Searches Pipedrive organizations by company name and fetches associated deals. Computes total deal value and ARR per company — the revenue context that turns raw ticket data into business-weighted effort scores. Zero LLM cost.

Assembler

Step 3 — Assembler

Code Only

Computes five CES dimension metrics per account: ticket volume per ARR, escalation frequency, response round depth, CSAT trajectory, and time-to-resolution trend. Pure math from Freshdesk + Pipedrive data. Zero LLM cost.

Analyst

Step 4 — Analyst

Tier 2 Classification

Scores each CES dimension 1-10 using defined rubrics, computes composite CES (equal 20% weight), classifies LOW/MODERATE/HIGH, generates per-account effort insights, and recommends specific actions. Sonnet 4.6 with chain-of-thought enforcement.

Formatter

Step 5 — Formatter

Tier 3 Creative

Generates two outputs: (1) Notion effort scorecard with per-account CES breakdown, dimension details, and recommendations. (2) Slack Block Kit alert for HIGH CES accounts with deal value context and priority actions. Sonnet 4.6.

What It Does NOT Do

×

Does not modify Freshdesk tickets or Pipedrive deals — it reads and analyzes, never writes back

×

Does not replace your CS team — it provides early warning signals for human intervention

×

Does not work with Zendesk, Intercom, or other helpdesk tools — Freshdesk API only in v1.0

×

Does not predict individual ticket outcomes — it scores aggregate customer effort patterns

×

Does not guarantee churn prevention — it identifies high-effort accounts for proactive outreach

×

Does not cluster ticket topics — that is what Support Pattern Analyzer does

The Complete Customer Success Bundle

7+ files — workflow JSON (main + scheduler), system prompts, and complete documentation.

freshdesk_customer_effort_scorer_v1_0_0.json — The 29-node n8n main workflow (AGGREGATE weekly CES scoring)
freshdesk_customer_effort_scorer_scheduler_v1_0_0.json — The 3-node scheduler workflow (Monday 8:00 UTC trigger)
README.md — 10-minute setup guide with Freshdesk, Pipedrive, Notion, Slack credentials and split-workflow configuration
docs/TDD.md — Technical Design Document with CES taxonomy and SINGLE-MODEL pattern
system_prompts/analyst_system_prompt.md — Analyst prompt (5-dimension CES scoring + per-account insights)
system_prompts/formatter_system_prompt.md — Formatter prompt (Notion effort scorecard + Slack Block Kit alert)
CHANGELOG.md — Version history

Tested. Measured. Documented.

Every metric is ITP-measured. The Freshdesk Customer Effort Scorer bridges support data with deal value across five CES dimensions — Sonnet 4.6 for analysis and formatting, weekly aggregate cost.

Workflow Nodes

29 + 3 (scheduler)

Blueprint Quality Standard

12/12 PASS

Agent Architecture

Fetcher (Code-only) → Enricher (Code-only) → Assembler (Code-only) → Analyst (Sonnet 4.6) → Formatter (Sonnet 4.6)

Required Credentials

Freshdesk (httpHeaderAuth), Pipedrive (pipedriveApi), Notion (httpHeaderAuth), Slack (httpHeaderAuth), Anthropic (anthropicApi)

Bundle Contents

7 files

Cost per Run

$0.03–$0.10/run

ITP Milestones

8/8 variations · 14/14 milestones

n8n Compatibility

2.7.5

Freshdesk Customer Effort Scorer v1.0.0─────────────────────────────────────────────Agents        5Nodes         29 + 3 (scheduler)LLM           Sonnet 4.6 × 2 (Analyst + Formatter)Trigger       Schedule (Monday 8:00 UTC) + WebhookTool A        Freshdesk (input — tickets by company)Tool B        Pipedrive (input — deal value / ARR)Tool C        Notion (output — effort scorecard)Tool D        Slack (output — high-effort alert)ITP           8/8 variations · 14/14 milestonesBQS           12/12

What You'll Need

Platform

n8n 2.7.5+

Est. Monthly API Cost

Weekly run cost ~$0.03-0.10/week ($0.12-$0.40/month)

Credentials Required

  • ▪Anthropic API
  • ▪Freshdesk API (httpHeaderAuth Basic)
  • ▪Pipedrive API (pipedriveApi)
  • ▪Notion (httpHeaderAuth Bearer)
  • ▪Slack (Bot Token, httpHeaderAuth Bearer)

Services

  • ▪Freshdesk account (API key)
  • ▪Pipedrive account (API token)
  • ▪Notion workspace (Integration with database access)
  • ▪Slack workspace (Bot Token with chat:write scope)
  • ▪Anthropic API key

Setup Track

Quick Start

~15 min

All credentials live, n8n running

Full Setup

1–2 hrs

Needs API config + tables

From Scratch

2–4 hrs

No n8n, no credentials

Freshdesk Customer Effort Scorer v1.0.0

$199

one-time purchase

What you get:

  • ✓Production-ready 29+3 node n8n workflow — import and deploy
  • ✓Weekly schedule: fires every Monday at 8:00 UTC (customizable)
  • ✓Five CES dimensions: ticket volume/ARR, escalation frequency, response depth, CSAT trajectory, resolution trend
  • ✓CES classification: LOW (1-3) / MODERATE (4-6) / HIGH (7-10)
  • ✓Per-account effort insights with specific recommendations
  • ✓Bridges Freshdesk support data with Pipedrive deal value — revenue-weighted effort
  • ✓Notion effort scorecard with per-account breakdown and dimension details
  • ✓Slack Block Kit alert for HIGH CES accounts with deal value context
  • ✓Split-workflow pattern: scheduler + main pipeline (both included)
  • ✓SINGLE-MODEL: Sonnet 4.6 for analysis and formatting — no Opus needed
  • ✓AGGREGATE pattern: one Analyst call per weekly run, not per ticket
  • ✓ITP 8/8 variations, 14/14 milestones measured
  • ✓All sales final after download

Frequently Asked Questions

What is a Customer Effort Score (CES)?+

CES measures how much effort a customer must expend to get help. This workflow scores effort across 5 dimensions: ticket volume relative to account revenue, escalation frequency, back-and-forth depth, CSAT trajectory, and resolution time trends. A composite score of 1-10 classifies accounts as LOW (healthy), MODERATE (monitor), or HIGH (intervention needed).

Why bridge Freshdesk with Pipedrive?+

Ticket volume alone is misleading. An enterprise account with 20 tickets may be healthy if they pay $500K/year (4 tickets per $100K). A smaller account with the same volume at $20K/year is drowning. Pipedrive deal value provides the revenue context that makes effort scores business-relevant.

What are the five CES dimensions?+

Ticket Volume per ARR (tickets normalized by account revenue), Escalation Frequency (how often tickets get escalated), Response Round Depth (average back-and-forth exchanges per ticket), CSAT Trajectory (whether satisfaction is improving, stable, or declining), and Time-to-Resolution Trend (whether tickets are being resolved faster or slower than baseline).

When does a Slack alert fire?+

When any account scores at or above the CES_ALERT_THRESHOLD (default: 7). The alert includes the company name, CES score, deal value, top effort driver, and recommended action. Accounts below the threshold still get logged in the Notion scorecard.

How does it relate to Freshdesk SLA Risk Predictor?+

Different scope and timing. FSRP predicts SLA breach risk per ticket in real-time (event-driven). FCES scores aggregate customer effort per account weekly (batch). FSRP is about individual ticket deadlines. FCES is about long-term account health patterns.

How does it relate to Support Pattern Analyzer?+

Different analysis angle. SPA clusters ticket topics for pattern analysis (what are customers asking about?). FCES scores customer effort (how hard is it for customers to get help?). SPA identifies themes. FCES identifies at-risk accounts.

Why only Sonnet instead of Opus?+

The Fetcher, Enricher, and Assembler pre-compute all CES metrics from Freshdesk and Pipedrive API data. The Analyst receives pre-computed numbers and applies a scoring rubric — classification-tier reasoning that Sonnet 4.6 handles accurately. No deep causal analysis required.

Can I customize the CES thresholds?+

Yes. Five configurable variables: LOOKBACK_DAYS (default 30), CES_ALERT_THRESHOLD (default 7), DEAL_VALUE_THRESHOLD (default $10,000 minimum), NOTION_DATABASE_ID, and SLACK_CHANNEL. All set in the Config Loader node.

Does it use web scraping?+

No. All data comes from the Freshdesk API and Pipedrive API. No web_search or external scraping. Fully deterministic and fast.

Is there a refund policy?+

All sales are final after download. Review the Blueprint Dependency Matrix and prerequisites before purchase. Questions? Contact support@forgeworkflows.com before buying. Full terms at forgeworkflows.com/legal.

Read the full guide →

Related Blueprints

Freshdesk SLA Risk Predictor

AI-powered per-ticket SLA breach prediction that scores risk across five factors — complexity, customer tier, agent capacity, historical patterns, and escalation signals — and alerts your team before deadlines slip.

$199

Support Pattern Analyzer

AI reads your Freshdesk. Delivers a weekly support intelligence brief before standup.

$199

Account Health Intelligence Agent

Weekly AI health briefs for every account.

$249