All workflows
Google Sheets logoAnthropic logoGmail logo

Sales call transcript analyzer

Every hour, has Claude analyze new sales call transcripts in a Google Sheet and emails you the call breakdown and action plan.

Every hour3 apps4 steps

Apps it connects

Authenticate each one once and the workflow is ready to run.

What it does

Each integration step this workflow runs, in order, what it is for, and the conditions and loops that decide when it runs.

  1. 1Google SheetsRead rowsReads the 'Transcripts' tab to find rows with an empty 'Status' and a transcript long enough to analyse.
  2. For each row

    1. 2AnthropicGenerate model responseAsks the AI to write the call summary, deal temperature, signals, action plan, open questions and a follow up email draft.
    2. 3GmailSendEmails the full analysis as plain text to your chosen address, with the prospect and call date in the subject.
    3. 4Google SheetsWrite rowMarks 'Status' as analysed once the email is sent, or as needing review when the AI returns nothing usable.

How it works

What happens on each run, in plain English.

Every hour, the transcripts tab in your Google Sheet is read and any call not yet analysed is picked up. AI reads each transcript and writes a full breakdown: a summary, how warm the deal is, what the prospect said about pain, budget and timeline, buying signals and red flags, an action plan with owners and dates, open questions, and a follow-up email draft.

Each analysis is emailed to the address you choose, titled with the prospect and call date, and the row's 'Status' cell, the only cell ever written, is then marked so it is never analysed twice. A row with no transcript yet is left for a later hour, the number of calls per run is capped so a backlog is paced out, and if nothing usable comes back the row is marked for review and no email goes out. The AI is told to say when something was not stated rather than infer it, and the draft email is for you to review and send.

Your tab needs 'Status' as its first column, then 'Call Date', 'Prospect' and 'Transcript'.

salescall transcriptscall analysisaction planfollow upgoogle sheetsclaudegmailhourly

Start from a workflow that already works.

Add "Sales call transcript analyzer" to your workspace, connect its apps, and make it yours. No credit card required.

Free plan available · No credit card required