See llms.txt for all machine-readable content.

Back to Templates

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

  1. Receives a POST webhook from Retell AI when a call event is sent.
  2. Validates the payload by checking the event type, call ID, voicemail status, and minimum transcript length, and stops processing for invalid events.
  3. Sends the call transcript to Anthropic to extract a structured JSON report (caller, location, what happened, urgency, and follow-up details).
  4. 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.
  5. Appends the report row to a Google Sheets worksheet.
  6. Sends an email via SMTP with the formatted call report and links/metadata (including the recording URL when available).

Setup

  1. In the workflow settings, set the Google Sheets spreadsheet URL, target sheet name, and the to/from email addresses.
  2. Connect credentials for Anthropic, Google Sheets (OAuth), and your SMTP email account.
  3. Create the target worksheet in Google Sheets (or ensure it exists) and confirm the columns you want to capture via auto-mapping.
  4. Copy the webhook Production URL from the webhook trigger and configure it in Retell AI as your agent or account webhook endpoint.
  5. If needed, adjust the accepted event type and minimum transcript length to match your Retell configuration and reporting needs.