Skip to content

On a schedule

Email weekly call activity per rep

Every Friday I see how many calls each rep had and how long they talked.

Runs
On a schedule
Apps
Gong
AI
Not needed
Access
read

Send this to your assistant

Create a ClickRuntime automation: every Friday at 4pm, email me a table of this week's Gong call counts and total talk time for each rep, sorted by call count.

Paste it into your assistant. It tells you what it will send or change before it runs live.

First time? Adding ClickRuntime to your assistant takes about two minutes.

Why use it

Why teams use this automation

A sales director plans coaching on Friday and wants to know who is actually on the phone. Gong holds the answer, but pulling it means opening a dashboard, picking a date range, exporting a table and squinting at it. So it gets skipped, and the quiet rep who made six calls all week looks the same on paper as the one who made forty-five.

On the schedule you set, ClickRuntime pulls Gong's aggregate stats for each rep over the past week, lays them out as a clean table and emails it to you. There is no AI step, only the counts from Gong, so the same data produces the same table each time.

Many directors send it to their sales ops lead as well, so pipeline reviews start from the same numbers.

What you get out of it

  • Low activity noticed within a week

    A rep with a sharp drop in call count shows up in the next email. Because it arrives weekly, you raise it in a one-to-one while it is still a bad week and not a bad quarter.

  • Fair comparisons across the team

    Everyone is measured from the same Gong data over the same seven days, with no manual edits in between. That avoids arguments about whose spreadsheet is right when you discuss targets, ramp time or territory changes.

  • Coaching time goes where it matters

    Seeing call volume next to outcomes elsewhere helps you spot who needs help getting meetings versus who needs help in them. Those are very different conversations and different uses of your hour.

  • New hire ramp is easy to monitor

    A rep in their first month can be checked against what peers did at the same stage. If the numbers lag, you step in with shadowing and call reviews before the gap hurts quota.

  • No Friday dashboard ritual

    The table is waiting in your inbox, so nobody has to remember to export it. Leaders spend their Friday reading and acting on activity rather than assembling it by hand from a dashboard.

How it works

What happens, step by step

  1. Every Friday at 4pm, ClickRuntime pulls this week's call activity from Gong, starting from Monday.

  2. It matches each user to their name and counts the calls they hosted.

  3. You get an email with a table of reps and their call counts, busiest rep first.

Before it runs live

  • Connect Gong

What you get

RunsOn a schedule
Email weekly call activity per reptoday, 9:00Succeeded
Email · Weekly call activitySam Lee Calls 23 Alex Morgan Calls 17

Build your own

Need it to work differently?

This template is a starting point. Copy the prompt and change it, or describe a different automation from scratch, with your own conditions, more apps or an AI step. Your assistant writes it, tests it and runs it on ClickRuntime.
  • Your own rules

    Conditions, thresholds, filters and exceptions, written the way you'd explain them to a colleague.

  • Any number of apps

    One automation can read from one app and update several others. Over 248 apps are ready, and anything with an API works too.

  • AI where it helps

    Summaries, classification, extraction and drafts use ClickRuntime's built-in AI, with no extra key.

  • On a schedule or on each event

    Runs as often as every 5 minutes, or the moment an app sends an event, and keeps track of what it already handled.

Changes you can ask for

  • Run it at a different time, more or less often, or only on weekdays
  • Add an AI step, for example to summarize, sort or draft a reply
  • Add another app, for example also send it to Slack
  • Combine it with other Gong steps into one automation

Under the hood

The code that runs this automation

This is the Python script that runs each time the automation starts. Your AI assistant writes it for you when you send the prompt, and you allow each step in your assistant. To change how the automation works, describe the change to your assistant and it updates the script for you. For every function it can use, see the script reference.
weekly_call_activity_per_rep.pyexample
from datetime import date, timedelta
from clickruntime import on_trigger, credentials, notify, http

@on_trigger
def run(event):
    auth = (credentials.secret("GONG_ACCESS_KEY"), credentials.secret("GONG_ACCESS_SECRET"))
    today = date.today()
    monday = today - timedelta(days=today.weekday())
    users = {u["id"]: f"{u['firstName']} {u['lastName']}"
             for u in http.get("https://api.gong.io/v2/users", auth=auth).json()["users"]}
    stats = http.post("https://api.gong.io/v2/stats/activity/aggregate", auth=auth, json={
        "filter": {"fromDate": monday.isoformat(), "toDate": (today + timedelta(days=1)).isoformat()},
    }).json()["usersAggregateActivityStats"]
    rows = sorted(((users.get(s["userId"], s["userId"]), s["userAggregateActivity"].get("callsAsHost", 0))
                   for s in stats), key=lambda r: r[1], reverse=True)
    lines = [f"{'Rep':<28}{'Calls':>6}"] + [f"{name:<28}{calls:>6}" for name, calls in rows]
    notify.email_me(f"Gong calls, week of {monday}", "\n".join(lines))
    return {"reps": len(rows)}

FAQ

Common questions

Which numbers appear in the table?
The table uses the aggregate activity stats Gong provides per user, such as the number of calls for the week. Exactly which metrics can be included depends on what your Gong plan exposes. You can ask for columns to be added or removed.
Does it need admin access in Gong?
The connection needs permission to read user activity and call data, which usually means an admin or a role with access to team stats. If your Gong role cannot see other reps' numbers, the report will only include what that role can view.
Can I get this for one team instead of everyone?
Yes. Reps can be filtered by workspace, manager or a list of names, so a regional director sees only their own team. Many companies run a separate copy per manager, each emailed to the right person.
What permissions does it need?
read. Nothing else in your accounts is used.
Does it need AI?
No. It runs without AI, so it doesn't use your plan's AI allowance.
How many runs does it use?
One run each time it runs (on a schedule). Checks that find nothing to do and stop right away aren't counted.
Can I change how it works?
Yes. Describe the change to your AI assistant, for example a different schedule, channel or filter. It updates the automation, tests it and tells you what changed.

Set up “Email weekly call activity per rep” from your assistant

Copy the prompt above, or connect your assistant first. Free plan, no credit card.