# Every Monday, log last week's Dialpad calls to Sheets

> Every Monday morning, flatten the previous week of Dialpad calls into a Google Sheet so your ops team can pivot on volume, duration, and rep activity.

- Workflow type: code
- Services: Dialpad, Google Sheets
- Categories: Operations, Sales
- Published: 2026-07-17

## What it does

- Runs every Monday at 8am and pulls every call from the previous seven days out of Dialpad
- Adds one row per call to your Google Sheet with the date, direction, phone numbers, rep, duration, call state, recording flag, and Dialpad call id
- Keeps the column layout stable so pivot tables and charts in your sheet keep working week after week
- Lets you exclude internal-to-internal calls so the log only reflects real customer conversations

## What you'll need

- A Dialpad account with permission to see company call history
- A Google account with edit access to the destination spreadsheet
- The spreadsheet and the name of the worksheet tab where calls should land

## Prompt

Every Monday at 8am, log the previous week's Dialpad calls into a Google Sheet so ops can pivot on the data.

Use Dialpad List Calls with a 7-day time range (the previous Monday 00:00 through the following Sunday 23:59:59 in the user's chosen timezone) to pull every call. Then use Google Sheets Append Values on the user-selected spreadsheet and worksheet to add one row per call with a fixed column layout: date, direction, from number, to number, internal user (rep), duration in minutes, call state (completed / missed / voicemail), whether it was recorded, and the Dialpad call id for drill-down.

Dialpad returns durations in milliseconds and timestamps in Unix epoch millis, so convert duration to minutes (rounded to one decimal) and format each timestamp as a human-readable date string in the user's chosen timezone before appending. Represent booleans (recorded yes/no) as plain TRUE / FALSE strings and keep phone numbers in their E.164 form so they stay pivotable.

Paginate through Dialpad's List Calls response (follow the cursor) so every call in the seven-day window is included, then build one batch of rows and send them to Google Sheets Append Values in a single call to stay well under the 2 MB payload guidance.

Let the user pick the target spreadsheet and worksheet, the timezone used for the date column, and a toggle for whether to include internal-to-internal calls (calls where both the caller and callee are Dialpad users in the same company). When that toggle is off, filter those calls out before appending so the log only reflects real customer conversations.

This is a code workflow because it's a straight flatten-and-append with no reasoning step: every call becomes exactly one row, the column layout is fixed, and there are no judgement calls between fetch and write.

## How to customize

- Choose which spreadsheet and worksheet tab the calls land in
- Set the timezone used for the date column so weeks line up with your team's local calendar
- Decide whether internal-to-internal calls between coworkers show up in the log

## FAQ

### Will this overwrite my existing Dialpad call rows?

No. Each Monday it appends new rows below whatever is already in the sheet, so your history keeps building week over week.

### Does this include missed calls and voicemails?

Yes. Every call in the seven-day window shows up with its state, whether that is completed, missed, or voicemail, so your pivots can slice by outcome.

### What happens if a Monday run is skipped?

The next run still pulls the previous seven days, so a missed Monday leaves a one-week gap. You can rerun the workflow manually any time to backfill.

### Can I add more columns like disposition or notes later?

Yes. You can extend the row layout in the workflow to include any additional fields Dialpad returns, and existing pivot tables keep working as long as the header row stays in place.

### Can I point this at a different day or time?

Yes. Monday at 8am is the default because ops teams usually review the prior week first thing, but you can move the schedule to any day and time that fits your review cadence.

Use this prompt in General Input: https://www.generalinput.com/prompts/every-monday-log-last-weeks-dialpad-calls-to-sheets