The Scenario
Your sales manager is doing the monthly coaching review. Before the one-on-ones start, she wants a Google Sheet showing every call logged in Pipedrive over the last 30 days — caller name, call duration, outcome, and the deal it was linked to — so she can identify which reps are making the most calls and which outcomes are trending.
She tried to get this from Pipedrive's activity report last month. The report UI lets her filter by type = call, but the export only includes the fields visible on screen — it does not include duration or outcome unless she customizes the column layout first. She customized it. The export still only had 100 rows even though there were clearly more calls logged.
The bad version:
- She exports the call activities from Pipedrive with the 100-row limit and pastes them into a sheet
- She realizes the export is missing duration because the column wasn't included in the activity list view — she goes back, adds the column, exports again
- She spots that several calls are showing the wrong outcome because reps were logging calls as completed without filling in the outcome field
The coaching session starts in 20 minutes and the data is still incomplete.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It queries Pipedrive's call log data directly and writes all the fields you need in one pull — no column configuration, no 100-row limit.
Fetch all Pipedrive call logs for the last 30 days and write caller name, duration, outcome, linked deal name, and call date into this sheet, one call per row.
What You Get
- Every call logged in Pipedrive in the last 30 days, with no row limit
- Caller display name, call duration in minutes, outcome (answered, no answer, busy, left message, etc.), linked deal name, and call date as separate columns
- Calls with no linked deal show a blank in the deal column rather than breaking the output
- Rows arrive in chronological order — most recent calls last by default
What If the Data Is Not Quite Ready
You want calls broken out by rep with a per-rep count summary
Fetch all Pipedrive call logs for the last 30 days. Write caller name, duration, outcome, linked deal name, and call date into this sheet. Then write a summary table below showing each caller and their total call count, sorted descending.
You only want calls with a specific outcome — no answer calls for follow-up targeting
Fetch all Pipedrive call logs from the last 30 days where outcome is no answer. Write caller name, linked deal name, person name, and call date into this sheet.
You want to calculate average call duration per rep
Fetch all Pipedrive call logs for the last 30 days. Write caller name and duration into this sheet. Then write a summary below showing each caller's average call duration in minutes.
You need the call log, a per-rep summary, and a flag for deals with zero calls in 30 days — all in one shot
Fetch all Pipedrive call logs for the last 30 days and write the full list to this sheet. Below it, write a per-rep call count summary. Then separately, fetch all open deals from the same period that have no logged call activity and write their deal names and owners into a section labeled No Call Activity — so the coaching review covers both ends.
The pattern: pull the activity log, derive the coaching metrics, and surface the missing-activity gaps in one prompt rather than two separate exports.
Try It
Before your next sales coaching session, Get the 7-day free trial of SheetXAI and ask it to pull the Pipedrive call log for whatever date range you need into a flat table. See the spoke on pulling overdue activities if you also want to review what calls are still scheduled but not completed.