All templates
For contact centre managers, IT teams & sales operations

See every call your team missed yesterday

Every morning, WebRun signs in to 3CX, reads yesterday's call reports for abandoned and unanswered calls, logs each one into a Google Sheet with the caller number, the time, the queue, and the wait before the caller gave up, then posts the daily count and the worst hour to Telegram.

  • No credit card
  • Under $0.01 per run
  • Cancel anytime
14,115 templates Safe automation No code
Every day at 8:00 AM WebRun
1 3CX pull yesterday's missed calls
2 Google Sheets log the callback list
3 Telegram post the daily count
Run a sample
In short

How do I get a daily report of missed calls from 3CX?

WebRun signs in to 3CX every morning and pulls yesterday's abandoned and unanswered calls. It logs each one into a Google Sheet with the caller number, time, queue, and wait time, then posts the daily count to Telegram along with the worst hour, the busiest queue, and any repeat callers.

  • Every missed call becomes a callback row with a number and a time
  • Repeat callers are flagged before they give up on you
  • The worst hour and busiest queue are named every single morning

Built for contact centre managers · IT teams · sales operations · service desks

Step by step

What does WebRun do on every run?

The exact actions WebRun takes, in order - in plain language, so you can adjust anything.

  1. WebRun signs in and gets to work

    Opens customer.3cx.com in a real browser with your saved login - no setup, no API keys.

  2. 1
    3CX - pull yesterday's missed calls
    3cx.com
    WebRun in 3CX: pull yesterday's missed calls
    WebRun opens 3CX to pull yesterday's missed calls.
    • Sign in to 3CX and open the call reports for yesterday
    • Pull the abandoned queue calls and the unanswered inbound calls
    • Capture the caller number, the time, the queue or extension, and how long the caller waited
    • Mark any caller who tried more than once, and any who were called back later the same day

    Done when Every missed call from yesterday is listed with its wait time and queue.

  3. 2
    Google Sheets - log the callback list
    google.com How to Automate Google Sheets
    WebRun in Google Sheets: log the callback list
    WebRun opens Google Sheets to log the callback list.
    • Append one row per missed call to your callback sheet
    • Fill in the date, time, caller number, queue, wait time, and repeat-caller flag
    • Leave the callback owner and outcome columns blank for your team to fill in
    • Keep the history so you can see missed calls by hour and by queue over time

    Done when Yesterday's missed calls are rows in the callback sheet, ready to work.

  4. 3
    Telegram - post the daily count
    telegram.org How to Automate Telegram
    WebRun in Telegram: post the daily count
    WebRun opens Telegram to post the daily count.
    • Post yesterday's missed call count and how it compares with the day before
    • Name the worst hour and the queue with the most abandons
    • Call out repeat callers first so they get a callback before they give up entirely

    Done when The team has yesterday's missed call summary in Telegram.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
customer.3cx.com
ScheduleRuns automatically on this cadence
Every day at 8:00 AM
DeliveryHow each run's result reaches you
Missed call callback list · Google Sheets
OutputWhat each run produces - A growing Google Sheet of missed 3CX calls with time, caller, queue, wait time, and repeat flag, plus a daily Telegram summary naming the worst hour and queue.
Table
Setup & safety

Secure by default

Connect once, stays signed in

WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.

Your credentials stay in your own private environment - WebRun never stores your passwords.
Strict Lockdown

Every action is checked against this policy before it runs.

Domains ALLOWLIST
Typed input ALLOW
Shell command BLOCK
File uploads BLOCK
Runs in a contained environment More on policies
Good to know

Questions, answered

Does it call or text the people who were missed?

No. WebRun builds the callback list and reports it internally. It never dials a number, never sends an SMS, and never leaves a voicemail. Your team makes every callback.

Does it change anything in my 3CX system?

No. WebRun reads the call reports only. It never edits an extension, a queue, a ring group, or a routing rule, so your phone system configuration is untouched by the automation.

How does it spot a repeat caller?

By matching the caller number across yesterday's report and the existing sheet history. Callers who tried more than once are flagged at the top of the Telegram summary so they get called back first.

Put this on autopilot.

Turn it on in minutes - or have our team set it up for you.