{"product_id":"n8n-ai-voice-webhook-log-callbacks-to-google-sheets-gmail-alerts","title":"n8n AI Voice Webhook: Log Callbacks to Google Sheets + Gmail Alerts","description":"\u003ch3\u003eTurn AI voice call-backs into a clean Google Sheets log—instantly, reliably, with Gmail alerts\u003c\/h3\u003e\n\u003cp\u003eThis n8n AI Voice Webhook workflow receives call-back requests from your voice agent, validates and de-duplicates callers, logs everything to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and sends \u003cstrong\u003eurgent or failure notifications\u003c\/strong\u003e via \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives webhook call-back requests\u003c\/strong\u003e via a POST webhook from your AI voice agent, including caller details.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes and validates the payload\u003c\/strong\u003e (including timezone-aware timestamps). If no phone number is provided, it responds asking for a phone number.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFinds existing requests\u003c\/strong\u003e in the Google Sheets \u003cstrong\u003e“Requests”\u003c\/strong\u003e tab by matching the caller’s phone number.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMerges repeat calls within a time window\u003c\/strong\u003e: if there’s an existing row with \u003cem\u003eStatus = New\u003c\/em\u003e within the configured merge window, it increments the call count and appends a timestamped note instead of creating duplicates.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreates or updates the sheet record\u003c\/strong\u003e (append a new row or update by Request ID), then confirms the save back to the webhook sender.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends Gmail alerts\u003c\/strong\u003e for \u003cem\u003eurgent\u003c\/em\u003e requests to a configured email address.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHandles Google Sheets failures\u003c\/strong\u003e: if writing fails, it responds that the request was not saved and sends a failure notification email via Gmail with caller details.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eCapture call-back requests after an \u003cstrong\u003eAI voice agent\u003c\/strong\u003e call and keep an always-current pipeline in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eDeduplicate repeated caller attempts within minutes to reduce noise and speed up follow-up.\u003c\/li\u003e\n  \u003cli\u003eNotify your team immediately when a request is marked \u003cstrong\u003eurgent\u003c\/strong\u003e or when logging fails.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets integration\u003c\/strong\u003e: writes to the \u003cstrong\u003eRequests\u003c\/strong\u003e tab with headers including Request ID, Received, Last update, Urgent, Name, Phone, Reason, Preferred time, Notes, Calls, and Status.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail integration\u003c\/strong\u003e: sends alert emails for urgent saves and for Google Sheets write failures.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\/logic\u003c\/strong\u003e: \u003cem\u003ewebhook\u003c\/em\u003e, \u003cem\u003eif\u003c\/em\u003e, \u003cem\u003eset\u003c\/em\u003e, \u003cem\u003ecode\u003c\/em\u003e, \u003cem\u003egmail\u003c\/em\u003e, and \u003cem\u003esticky note\u003c\/em\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46359771611315,"sku":"N8N-22161","price":25.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/xvbUAUhM-DmW_cDn0VDW6_T1EM1xlF.png?v=1793697461","url":"https:\/\/buyflowscripts.com\/products\/n8n-ai-voice-webhook-log-callbacks-to-google-sheets-gmail-alerts","provider":"N8N Commerce","version":"1.0","type":"link"}