Turn support calls into Zendesk tickets with WayinVideo, GPT-4o-mini, and Google Sheets

Description

Submit any customer support call recording URL along with the agent name, customer details, issue category, call date, and product name and the workflow transcribes and analyzes the full call automatically. WayinVideo's Transcription API returns a speaker-labeled timestamped transcript which GPT-4o-mini reads to extract 10 structured fields — ticket subject, issue summary, root cause, resolution given, follow-up actions, key customer quotes, sentiment, priority, CSAT prediction, and tags. A Zendesk ticket is created via the REST API with the customer as the requester and the full structured summary as the ticket body, and every call is logged to Google Sheets with the Zendesk Ticket ID and URL. Built for customer support teams, customer success managers, and QA teams who record support calls and want structured tickets created automatically without manually listening to recordings after every call.

---

What This Workflow Does

- Transcribes the full call with speaker labels and timestamps — WayinVideo's Transcription API returns every word spoken in the call labeled by speaker and time so GPT has accurate context for every field it extracts - Extracts 10 structured support intelligence fields — GPT identifies the ticket subject, issue summary, root cause, resolution given, follow-up actions, key customer quotes, sentiment, priority, CSAT prediction, and tags — all from what was actually said - Predicts CSAT on a 1–5 scale — GPT assesses how the call ended and assigns a predicted customer satisfaction score so your team can proactively follow up on low-scoring calls - Builds a structured Zendesk ticket body — All 10 fields are assembled into a formatted ticket body with clear section headers making it immediately readable in Zendesk - Creates the Zendesk ticket with the customer as requester — The ticket is opened in Zendesk with the customer's name and email as the requester — not the agent — so reply threads go to the right person - Maps priority to Zendesk values automatically — The GPT priority label (Urgent, High, Normal, Low) is converted to the exact value Zendesk expects before the API call - Logs 19 fields to Google Sheets — Every field plus the Zendesk Ticket ID and constructed Ticket URL are saved in one row per call for QA review and reporting

---

Setup Requirements

Tools Needed - n8n instance (self-hosted or cloud) - [WayinVideo](https://wayin.ai/api/) account with API access - OpenAI account with GPT-4o-mini API access - Zendesk account with API token access - Google Sheets (one sheet with a tab named Support Call Log)