This is an n8n workflow that grades AI receptionist calls made through Vapi. When a call ends, it sends the transcript to OpenAI along with your business facts from Google Sheets. OpenAI returns a structured scorecard covering the outcome, captured details, invented facts, rule breaks, and a summary.
The workflow reads the end-of-call report to get the transcript, caller, duration, and recording URL. It skips empty or too-short calls. Fixed penalties applied in code produce the final score and grade. Results are appended to a "Calls" sheet, and required actions go to a "Follow-ups" sheet. If a recording URL and folder ID are provided, it can also save the recording to a Google Drive folder.
When a call needs attention, the workflow sends a formatted report by Gmail and can send an SMS alert through Twilio. Each week it summarizes the last 7 days of calls and open follow-ups. It asks OpenAI for up to three prompt improvements and emails the weekly report through Gmail.
- Platform
- n8n workflow
- Triggers
- Webhook POST when a Vapi call ends; weekly on Monday at 7am; manual run to create or update the required spreadsheet
- Integrations
- Vapi, OpenAI, Google Sheets, Gmail, Twilio (optional), Google Drive (optional)
- Google Sheets tabs
- Business facts, Calls, Follow-ups
- Extracted data
- Transcript, caller, duration, recording URL
- Scorecard
- Outcome, captured details, invented facts, rule breaks, summary
- Scoring
- Fixed penalties applied in code to compute the final score and grade
- Alerts
- Formatted Gmail report; optional Twilio SMS
- Weekly report
- Summary of the last 7 days of calls and open follow-ups, with up to three prompt improvements, emailed via Gmail
- Recordings
- Optionally saved to a specified Google Drive folder
- n8n nodes
- if, set, code, switch, gmail, twilio