# Call Transcript Sentiment Analysis

**Category:** Customer Support  
**Tools:** Google Sheets, OpenAI  
**Nodes:** 9  
**Built by:** Forgent Systems

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

![Workflow](preview.webp)

## 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

## Data setup

**Google Sheets** (tab: columns)

- **Transcript_analysis_system → Sheet1**: `Status`, `Full Transcript`, `Conversations Topics`, `Customer Name`, `Agent Name`, `Greeting Sentiment`, `Closing Sentiment`, `Problem Solving`, `Agent Friendliness`, `Customer Sentiment`, `Issue Resolved`, `Total Rating`

## Setup

1. In n8n open **Workflows → Import from File** and choose `workflow.json`.
2. Connect these credentials:
   - Google Sheets account
   - OpenAI account
3. Point the Sheets / Airtable / Drive / Slack nodes at your own resources (structure above).
4. Replace placeholder emails, phone numbers and `YOUR-FORM-ID` links with your own.
5. Times use the America/New_York timezone and dates use MM/DD/YYYY. Adjust if needed.
6. Run a test execution, then activate.

## Nodes

- **OpenAI Chat Model** — `@n8n/n8n-nodes-langchain.lmChatOpenAi`
- **Loop Over Items** — `n8n-nodes-base.splitInBatches`
- **Schedule Trigger** — `n8n-nodes-base.scheduleTrigger`
- **Get All Transcript** — `n8n-nodes-base.googleSheets`
- **Send only Transcript Field** — `n8n-nodes-base.set`
- **Analysis Transcript** — `@n8n/n8n-nodes-langchain.agent`
- **Structured Output** — `@n8n/n8n-nodes-langchain.outputParserStructured`
- **Store Analysis Transcript** — `n8n-nodes-base.googleSheets`
- **Sticky Note** — `n8n-nodes-base.stickyNote`
