create-call-logs-and-email-recording-link-to-ownerlisted
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