← ClaudeAtlas

create-call-logs-and-email-recording-link-to-ownerlisted

Build a Zap on Zapier that logs each completed phone call as a row in a Google Sheets call log and emails the call's recording link to the owner. Use when a call center or support team wants every finished call recorded in a sheet, with the recording link sent to the person responsible for it, without manual entry.
zapier/awesome-zaps · ★ 2 · AI & Automation · score 78
Install: claude install-skill zapier/awesome-zaps
# Create call logs and email recording link to owner The Zap's code lives at https://github.com/zapier/awesome-zaps/tree/main/zaps/create-call-logs-and-email-recording-link-to-owner. Read the files there if this skill was installed on its own. ## What it does 1. **Trigger:** a completed call's event arrives at a Webhooks by Zapier catch hook (`webhook`, `hook_v2`). The telephony system posts to it. 2. **Filter:** if the event has no end time, the run stops and writes nothing. Only finished calls are logged. 3. **Timing:** computes the call's duration in seconds from the start and end times. 4. **Google Sheets** appends one row to the call log: call reference, session ID, call type, agent ID, start, end, duration, recording link and status (`Completed`). 5. **Gmail** emails the owner the recording link, with the call reference and start time in the subject and body. This step runs only when the payload includes a recording URL. The Zap only appends rows and sends the owner's recording emails. It never edits or deletes existing rows. ## Ask the user Each `REPLACE_…` value is set per person. Resolve names to IDs with the user's own connections; don't ask them to paste an ID you can look up. | Setting | What goes there | | ---------------- | -------------------------------------------------------------------------------------------------- | | `SPREADSHEET_ID` | The call-log spreadsh