{"product_id":"vapi-voice-agent-tool-calls-call-logging-with-google-sheets-gmail","title":"Vapi Voice Agent Tool Calls + Call Logging with Google Sheets \u0026 Gmail","description":"\u003ch3\u003eTurn Vapi voice tool calls into real-time Google Calendar + Sheets actions—then log every call with keyword alerts\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow acts as a single webhook backend for \u003cstrong\u003eVapi voice agents\u003c\/strong\u003e. It handles \u003cstrong\u003emid-call tool calls\u003c\/strong\u003e using \u003cstrong\u003eGoogle Calendar\u003c\/strong\u003e and \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, then \u003cstrong\u003elogs end-of-call details\u003c\/strong\u003e to a Google Sheets “Calls” tab and sends \u003cstrong\u003eGmail\u003c\/strong\u003e follow-up alerts when configured keywords are detected.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives POST requests from Vapi\u003c\/strong\u003e through one webhook for both \u003cem\u003etool call events\u003c\/em\u003e and \u003cem\u003eend-of-call reports\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes the payload\u003c\/strong\u003e to extract key fields including event type, tool call details, caller number, call ID, transcript, summary, and call metadata.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRoutes mid-call tool requests by function name\u003c\/strong\u003e to:\n    \u003cul\u003e\n      \u003cli\u003eCheck \u003cstrong\u003eGoogle Calendar\u003c\/strong\u003e availability.\u003c\/li\u003e\n      \u003cli\u003eLook up customer information in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e.\u003c\/li\u003e\n      \u003cli\u003eAppend a request to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e.\u003c\/li\u003e\n      \u003cli\u003eReturn a \u003cstrong\u003esafe response\u003c\/strong\u003e for unknown functions.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReturns Vapi tool results immediately\u003c\/strong\u003e in the required format: \u003ccode\u003e{ results: [{ toolCallId, result }] }\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOn end-of-call\u003c\/strong\u003e, scans transcript and summary for configured \u003cstrong\u003eFollowUpKeywords\u003c\/strong\u003e, sets follow-up flags, then:\n    \u003cul\u003e\n      \u003cli\u003eAppends the call record to the Google Sheets \u003cstrong\u003e“Calls”\u003c\/strong\u003e tab.\u003c\/li\u003e\n      \u003cli\u003eSends a \u003cstrong\u003eGmail\u003c\/strong\u003e alert email \u003cem\u003eonly if\u003c\/em\u003e the call is flagged for follow-up.\u003c\/li\u003e\n      \u003cli\u003eAcknowledges receipt back to Vapi.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAutomated appointment scheduling during live voice calls with \u003cstrong\u003ecalendar availability checks\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eEnriching conversations by looking up customers in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e and recording new requests.\u003c\/li\u003e\n  \u003cli\u003eOperations and sales follow-up: alert the right team via \u003cstrong\u003eGmail\u003c\/strong\u003e when keywords appear in transcripts\/summaries.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWebhook backend\u003c\/strong\u003e for Vapi events (tool calls + end-of-call reports).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Google Calendar, Google Sheets, Gmail.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n node types used:\u003c\/strong\u003e \u003ccode\u003eif\u003c\/code\u003e, \u003ccode\u003eset\u003c\/code\u003e, \u003ccode\u003ecode\u003c\/code\u003e, \u003ccode\u003egmail\u003c\/code\u003e, \u003ccode\u003eswitch\u003c\/code\u003e, \u003ccode\u003ewebhook\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003eConfigurable values include \u003cstrong\u003eCalendarId\u003c\/strong\u003e, \u003cstrong\u003eAlertEmail\u003c\/strong\u003e, \u003cstrong\u003eSlotLengthMinutes\u003c\/strong\u003e, \u003cstrong\u003eTransferMessage\u003c\/strong\u003e, and \u003cstrong\u003eFollowUpKeywords\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46123247141043,"sku":"N8N-20085","price":36.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/QbY4uuPgZm7J9HTZPzDjr_U7uovKzV.png?v=1790673843","url":"https:\/\/buyflowscripts.com\/products\/vapi-voice-agent-tool-calls-call-logging-with-google-sheets-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}