# Form Response Sentiment Scoring

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

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.

![Workflow](preview.webp)

## How it works

1. A new form response lands in Google Sheets.
2. AI classifies the sentiment of the feedback.
3. The result is written back to the same row.

## Use cases

- Product feedback surveys
- Post-purchase reviews
- Event feedback

## Data setup

**Google Sheets** (tab: columns)

- **Customer Feedback → Form Responses 3**: `Email`, `Sentiment`

## Setup

1. In n8n open **Workflows → Import from File** and choose `workflow.json`.
2. Connect these credentials:
   - Google Sheets Trigger account
   - 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

- **Google Sheet Trigger** — `n8n-nodes-base.googleSheetsTrigger`
- **Update Sentiment** — `n8n-nodes-base.googleSheets`
- **Sentiment Analysis from OpenAI** — `@n8n/n8n-nodes-langchain.openAi`
