Support metrics from two systems — in one weekly report

The scenario pulls tickets from both helpdesks, computes the metrics, keeps history in a sheet and emails you the report.

  • Tickets from both systems in a single view
  • Metrics: volume, response speed, tickets left hanging
  • Week-by-week history builds up in Microsoft SQL
  • An alert to vk without waiting for the report
Set it upScriptera

How it works

To move data from vk to Gmail automatically, use a ready-made scenario — no manual exports.

  1. Starts when: Weekly Trigger
  2. Then: Fetch Tickets From Zendesk
  3. Check: Merge
  4. Then: Format Ticket Data (Zendesk & Freshdesk)
  5. Then: Log KPIs in Google Sheets
  6. Then: Calculate Support KPIs
  7. Check: Evaluate Alerts
  8. If yes: Generate Slack Alert Message
  9. Then: Send Slack Alert
  10. If yes: Generate Weekly HTML Report
  11. Then: Send Weekly Email
  12. Then: Fetch Tickets From Freshdesk

You can launch this vk + Gmail integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.

Similar scenarios