{"product_id":"ai-receptionist-call-grader-with-vapi-openai-google-sheets","title":"AI Receptionist Call Grader with Vapi, OpenAI \u0026 Google Sheets","description":"\u003ch3\u003eGrade every AI receptionist call automatically—before invented info slips through\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow acts as your \u003cstrong\u003eAI Receptionist Call Grader\u003c\/strong\u003e for \u003cstrong\u003eVapi\u003c\/strong\u003e calls. When a call ends (or on a weekly schedule), it sends the transcript to \u003cstrong\u003eOpenAI\u003c\/strong\u003e with your \u003cstrong\u003ebusiness facts\u003c\/strong\u003e from \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, scores the call, logs results, and emails (and can text) you when something needs attention.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives call events\u003c\/strong\u003e via webhook POST when an AI receptionist call ends, \u003cstrong\u003eor\u003c\/strong\u003e runs weekly on \u003cstrong\u003eMonday at 7am\u003c\/strong\u003e, \u003cstrong\u003eor\u003c\/strong\u003e runs manually to create\/update the required spreadsheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eParses the end-of-call report\u003c\/strong\u003e to extract transcript, caller, duration, and recording URL—then \u003cstrong\u003eskips grading\u003c\/strong\u003e for empty or too-short calls.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOptionally downloads recordings\u003c\/strong\u003e and saves them to a specified \u003cstrong\u003eGoogle Drive folder\u003c\/strong\u003e when a recording URL and folder ID are provided.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGrades with OpenAI\u003c\/strong\u003e by reading the \u003cstrong\u003e“Business facts”\u003c\/strong\u003e tab from Google Sheets and submitting the transcript + facts for a structured scorecard (outcome, captured details, invented facts, rule breaks, and summary).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApplies fixed penalties\u003c\/strong\u003e in code to compute a final score\/grade, then appends results to the \u003cstrong\u003e“Calls”\u003c\/strong\u003e sheet and required actions to \u003cstrong\u003e“Follow-ups”\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNotifies you fast\u003c\/strong\u003e when a call needs attention: sends a formatted report via \u003cstrong\u003eGmail\u003c\/strong\u003e, and can optionally send an SMS alert via \u003cstrong\u003eTwilio\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWeekly coaching:\u003c\/strong\u003e summarizes the last 7 days of calls and open follow-ups, asks OpenAI for up to three prompt improvements, and emails the weekly report via Gmail.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eCatch \u003cstrong\u003einvented prices and hours\u003c\/strong\u003e during AI receptionist calls before customers see them.\u003c\/li\u003e\n  \u003cli\u003eReview missed details automatically by enforcing rules from your \u003cstrong\u003eGoogle Sheets business facts\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eOperational reporting for SaaS teams: weekly grading + action-oriented follow-ups.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eBuilt with n8n nodes including \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003eswitch\u003c\/strong\u003e, \u003cstrong\u003egmail\u003c\/strong\u003e, and \u003cstrong\u003etwilio\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eIntegrates with \u003cstrong\u003eVapi\u003c\/strong\u003e for end-of-call data, \u003cstrong\u003eOpenAI\u003c\/strong\u003e for scoring, and \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e for “Business facts,” “Calls,” and “Follow-ups.”\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46232447221939,"sku":"N8N-21022","price":30.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/RSNHvHKvNs6VA-vdT2L97_EerWnpyQ.png?v=1792142687","url":"https:\/\/buyflowscripts.com\/products\/ai-receptionist-call-grader-with-vapi-openai-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}