Daily sales call coaching scorecard from Fireflies
Every weekday evening, grade your team's sales calls from Fireflies, log scores to a Google Sheet, and DM each rep a short, supportive coaching note in Slack.
Every weekday at 6pm in my timezone, grade my team's sales calls from Fireflies and turn them into a running coaching scorecard in Google Sheets plus a private Slack note to each rep. Run this on a cron schedule (Fireflies does not have a first-class new-transcript trigger in this platform, so use a scheduled poll-and-dedupe pattern).
Step 1. Pull calls. Use Fireflies List Transcripts to fetch every transcript finished since the last run (look back about 24 hours, or since the most recent date already in the scorecard, whichever is longer). Filter to sales calls only by keeping transcripts that have at least one external participant (an email domain outside our company) or whose organizer is on the sales team. Skip transcripts that are internal only, still live (is_live = true), or already in the scorecard sheet (dedupe by transcript ID or transcript URL).
Step 2. Fetch detail. For each remaining transcript, call Fireflies Get Transcript to pull the full sentences, summary, action items, attendees, organizer email, duration, and talk-time analytics.
Step 3. Score the rep. Grade the call against this rubric (treat it as configurable and easy for me to edit later):
- Discovery quality: did the rep ask open questions, uncover pain, and confirm understanding?
- Objection handling: were objections acknowledged, explored, and addressed instead of brushed off?
- Talk-to-listen ratio: ideally the rep talks 40 to 50 percent of the time. Use the Fireflies analytics if available, otherwise estimate from the sentence speaker breakdown.
- Qualification signals: how many MEDDICC or BANT elements (metrics, economic buyer, decision criteria, decision process, identified pain, champion, competition; or budget, authority, need, timeline) were confirmed on the call?
- Clear next steps: did the rep land a specific, dated next step with the prospect?
Produce an overall score out of 100, per-criterion scores out of 10, the top two strengths, the top two improvement areas, and a single one-line coaching tip that is specific to this call (no generic advice).
Step 4. Log to the scorecard sheet. For each graded call, use Google Sheets Append Values to add one row to the sheet I configure. Columns, in order: Call Date, Rep Name, Rep Email, Prospect / Account, Meeting Title, Transcript URL, Duration (min), Overall Score, Discovery, Objection Handling, Talk-to-Listen, Qualification, Next Steps, Top Strengths, Top Improvement Areas, Coaching Tip. If the sheet does not yet have a header row, write the header on the first run.
Step 5. DM the rep in Slack. For each graded call, look up the rep's Slack user with Slackbot Look Up User by Email using their Fireflies organizer email, then open a direct message channel with Slackbot Open a Conversation, then send the coaching note with Slackbot Send a Message. Keep the message short, specific, and supportive (4 to 7 lines max). Format example:
"Nice work on the {Prospect} call today, {First Name}. Score: {Overall}/100. What landed: {Strength 1}; {Strength 2}. One thing to try next time: {Coaching Tip}. Full transcript: {URL}."
Use Slack mrkdwn (single asterisks for bold). Do not @channel. If the email lookup fails, skip the DM but still write the row to the sheet and include a note in the Coaching Tip column that the rep could not be matched.
Rules to enforce:
- Never grade the same transcript twice. Dedupe by reading the existing Transcript URL column from the sheet before grading.
- Skip internal-only meetings (every attendee shares our email domain).
- Skip live or unfinished transcripts.
- Keep the Slack note supportive and concrete, never mechanical or scolding. One improvement area per DM, not a list.
- If there are zero new sales calls for the day, do nothing (no empty digest, no "no calls today" DM).
Inputs I should be prompted for when I set this up: my company email domain (for the internal/external filter), the Google Sheet to log into and the tab name, the Slack workspace, the cron time and timezone, and the scoring rubric text (with a sensible default so I can ship without editing).
Additional information
What does this prompt do?
- Pulls every external sales call your team recorded in Fireflies that day, skipping internal-only meetings.
- Scores each rep against a rubric you control: discovery, objection handling, talk-to-listen ratio, qualification signals like MEDDICC or BANT, and clear next steps.
- Appends one row per call to a running Google Sheets scorecard with rep name, prospect, date, link to the transcript, overall score, per-criterion scores, strengths, and a coaching tip.
- Sends each rep a private Slack message with their score, two things they did well, and the one thing to work on next call, in a short and supportive tone.
- Dedupes against the sheet so the same call is never graded twice, even if the workflow runs multiple times.
What do I need to use this?
- A Fireflies.ai account that records your team's sales calls.
- A Google account with edit access to the spreadsheet you want to use as the scorecard.
- A Slack workspace where your reps can receive direct messages, with their email addresses matching the ones on the calls.
How can I customize it?
- Change the run time or cadence. Default is every weekday at 6pm in your timezone, but you can pick mornings, end of week, or any other rhythm.
- Edit the scoring rubric. Swap MEDDICC for BANT, add a custom criterion like product knowledge, or change how heavily each criterion is weighted.
- Adjust the filter for what counts as a sales call. You can match by external participants, by specific organizers on the sales team, or by meeting title keywords.
- Tune the Slack coaching message. Make it longer, add a weekly summary, send to a manager channel instead of a DM, or include a link to the full scorecard.
Frequently asked questions
Will the same call ever get graded twice?
What stops it from grading internal meetings?
Does the rep see their score or just their manager?
Can I use my own scoring rubric instead of MEDDICC or BANT?
What if a rep's email in Fireflies doesn't match their Slack email?
Stop letting great calls go uncoached.
Connect Fireflies, Google Sheets, and Slack once, and Geni grades every sales call your team makes, every evening, without anyone having to listen back.