The Scenario
You are a sales manager with eight reps. The leadership team wants a call activity report for last month: every outbound call logged in Fireberry, with rep name, contact called, call duration, and outcome, so they can compare activity levels per rep and identify who needs coaching.
The data exists. Every rep is supposed to log calls in Fireberry after each conversation. Some do it consistently, some do not, and you will find out which when you pull the data.
The bad version of this Monday:
- You navigate to Fireberry's activity reports section
- You filter to phone calls, set the date range to last month, export the CSV
- You open it in Sheets and find the duration column is in seconds, not minutes
- You write a conversion formula, copy-paste as values, delete the helper column
- You build a pivot table to get totals per rep
- You realize two reps have fewer than five logged calls for the entire month and you are not sure if they are not calling or not logging
- You spend the rest of the morning manually checking Fireberry for those two reps instead of preparing for the coaching conversation
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your spreadsheet that pulls the Fireberry call records and converts, totals, and flags the data as part of the same request.
Open the SheetXAI sidebar and type:
Pull all phone call records from Fireberry for the last 30 days and paste them into my 'Call Log' sheet with columns for call date, rep name, contact name, account name, call duration in minutes, and call outcome. Then add a summary table at the bottom showing total call count and average duration per rep, sorted by call count descending.
SheetXAI pulls the records, converts duration from seconds to minutes, writes the log, and builds the summary table at the bottom. You have the full picture without touching the export or writing a formula.
What You Get
A call activity sheet with two sections:
- Full call log — every call in the last 30 days with date, rep, contact, account, duration in minutes, outcome
- Summary table at the bottom — total calls and average duration per rep, sorted by activity level
Duration arrives as minutes, not seconds. You do not write the conversion formula.
The summary table makes the coaching conversation specific: "You made 12 calls last month, the team average is 22. Let's talk about pipeline cadence."
What If the Data Is Not Quite Ready
Call logs from a live CRM have a few common messiness patterns.
When some call records have no associated contact
Reps sometimes log calls against the account without linking to a specific contact.
Pull all Fireberry call records for the last 30 days. For rows where the contact field is blank, populate the contact name column with "Account-level call." Then write all records into the 'Call Log' sheet and build the summary table.
When you want to separate inbound from outbound calls
Outbound activity is what leadership tracks, but the export includes both directions.
Pull all Fireberry call records for the last 30 days. Create two sections in the 'Call Log' sheet: one for outbound calls and one for inbound. Add a subtotal row at the end of each section showing call count and average duration. Build the per-rep summary table using outbound calls only.
When you want to flag reps below a call volume threshold
The activity target is 20 calls per month. You want the coaching list auto-generated.
Pull all Fireberry call records for the last 30 days. Build a summary table by rep with total call count. Then add a 'Below Target' column in the summary table: mark any rep with fewer than 20 calls with a red flag. Write those rep names into a separate 'Coaching List' sheet so I have it ready for the 1:1s.
When you want the full call activity audit: raw log, conversion, summary, and coaching flags in one pass
Pull all Fireberry phone call records for the last 30 days. Convert duration from seconds to minutes. Separate inbound and outbound into two sections. Build a per-rep summary table for outbound calls only, showing call count, average duration, and total talk time. Flag any rep below 20 outbound calls in red. Write the flagged rep names into a 'Coaching List' sheet with their actual count and the delta from target.
The pattern: you describe the finished analysis, not the steps to get there. SheetXAI handles the conversion, the grouping, and the flagging inline.
Try It
Get the 7-day free trial of SheetXAI and pull your Fireberry call log into a sheet, then ask it to summarize activity by rep. The Fireberry integration is included in every plan. For related workflows, see how to export your Fireberry pipeline for forecasting or the Fireberry in Google Sheets overview.