Turn Retell AI call transcripts into structured reports with Anthropic and Google Sheets

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.

0
Downloads
0
Views
8.43
Quality Score
intermediate
Complexity
Created:11/18/2026
Updated:11/18/2026

🔒 Please log in to import templates to n8n and favorite templates

Workflow Visualization

Loading...

Preparing workflow renderer

Comments (0)

Login to post comments