Quick overview
This workflow receives Retell AI post-call webhook events, extracts key details from the call transcript using Anthropic, then logs each call as a structured row in Google Sheets and emails a short call summary to your team.
How it works
- Receives a POST webhook from Retell AI when a call event is sent.
- Validates the payload by checking the event type, call ID, voicemail status, and minimum transcript length, and stops processing for invalid events.
- Sends the call transcript to Anthropic to extract a structured JSON report (caller, location, what happened, urgency, and follow-up details).
- Applies safe defaults and flags the record for review when AI output is missing or incomplete, then builds a final report row with call metadata.
- Appends the report row to a Google Sheets worksheet.
- Sends an email via SMTP with the formatted call report and links/metadata (including the recording URL when available).
Setup
- In the workflow settings, set the Google Sheets spreadsheet URL, target sheet name, and the to/from email addresses.
- Connect credentials for Anthropic, Google Sheets (OAuth), and your SMTP email account.
- Create the target worksheet in Google Sheets (or ensure it exists) and confirm the columns you want to capture via auto-mapping.
- Copy the webhook Production URL from the webhook trigger and configure it in Retell AI as your agent or account webhook endpoint.
- If needed, adjust the accepted event type and minimum transcript length to match your Retell configuration and reporting needs.