Customer Support

Call Transcript Sentiment Analysis

Reads call transcripts from Google Sheets, scores customer and agent sentiment with AI, and writes structured insights back to the same row.

The Call Transcript Sentiment Analysis workflow on the n8n canvas, with its 9 nodes and connections
The workflow on the n8n canvas. Click to open it full size.

At a glance

Category
Customer Support
Nodes
9
Apps
Google Sheets, OpenAI
Price
Free
Download JSON
On this page

How it works

  1. On schedule, unprocessed transcripts are fetched from the sheet.
  2. Each transcript is sent to AI for structured analysis.
  3. Customer sentiment, agent tone and key points are written back to the row.

Use cases

  • Call center QA
  • Sales call reviews
  • Customer experience reporting

What you need

This workflow connects to these apps.

  • Google Sheets
  • OpenAI

You'll need an n8n instance, on n8n Cloud or self-hosted, and these credentials. Our credentials guide shows how to create each one.

  • Google Sheets account
  • OpenAI account

Data setup

Create these tables with these exact column names before the first run.

TableColumns
Transcript_analysis_system → Sheet1Google SheetsStatusFull TranscriptConversations TopicsCustomer NameAgent NameGreeting SentimentClosing SentimentProblem SolvingAgent FriendlinessCustomer SentimentIssue ResolvedTotal Rating

Setup

  1. Download the JSON and import it into n8n with Import from File, or copy it and paste it onto an empty canvas. The import guide walks through both.
  2. Connect the credentials listed above.
  3. Point the Sheets, Airtable, Drive, and Slack nodes at your own files and channels.
  4. Replace placeholder emails, phone numbers, and form links with your own.
  5. Times use the America/New York timezone and dates use MM/DD/YYYY. Change them if you need to, then test and activate. The setup guide covers this step by step.

Nodes

NodeType
OpenAI Chat ModellmChatOpenAi
Loop Over ItemssplitInBatches
Schedule TriggerscheduleTrigger
Get All TranscriptgoogleSheets
Send only Transcript Fieldset
Analysis Transcriptagent
Structured OutputoutputParserStructured
Store Analysis TranscriptgoogleSheets

Frequently asked questions

Reads call transcripts from Google Sheets, scores customer and agent sentiment with AI, and writes structured insights back to the same row. It's a 9-node n8n workflow.

An n8n instance, on n8n Cloud or self-hosted, and credentials for Google Sheets and OpenAI. It uses only nodes that ship with n8n, so there's nothing else to install.

It works with 1 table in Google Sheets. Create it with the column names listed under Data setup on this page before the first run.

Download the JSON, then in n8n create a new workflow, open the menu in the top right, and choose Import from File. You can also copy the JSON and paste it onto an empty canvas.

Yes. It's free to download, import, and change, with no sign-up. You only pay for the apps it connects to, where those aren't free on your plan.

Keep exploring
  • n8n canvas of the Form Response Sentiment Scoring workflow

    Customer Support3 nodes

    Form Response Sentiment Scoring

    Every new Google Form response is analyzed by AI and its sentiment is written straight back into the sheet, so you can see at a glance how customers feel.

  • n8n canvas of the HubSpot Ticket Auto-Acknowledgement workflow

    Customer Support3 nodes

    HubSpot Ticket Auto-Acknowledgement

    Customers get an instant confirmation email with their ticket number as soon as a new HubSpot ticket is opened, so nobody wonders whether their request was received.

  • n8n canvas of the AI Crop Advisory for Farmers workflow

    Agriculture27 nodes

    AI Crop Advisory for Farmers

    Gives farmers practical, AI-generated crop advice based on their soil, crop and live weather. Advice is delivered instantly on sign-up and refreshed daily over WhatsApp.