{"product_id":"gemini-live-voice-support-n8n-workflow-w-drive-sheets","title":"Gemini Live Voice Support n8n Workflow w\/ Drive \u0026 Sheets","description":"\u003ch3\u003eGemini Live Voice Support for Your Store—Powered by n8n, Drive, and Sheets\u003c\/h3\u003e\n\u003cp\u003eDeploy a ready-to-run \u003cstrong\u003eGemini Live Voice Support\u003c\/strong\u003e automation in n8n that creates secure single-use \u003cstrong\u003eGemini ephemeral tokens\u003c\/strong\u003e, loads your knowledge base from \u003cstrong\u003eGoogle Drive\u003c\/strong\u003e, and handles real customer tool calls like \u003cstrong\u003eorder status\u003c\/strong\u003e, \u003cstrong\u003ereturns\/exchanges\u003c\/strong\u003e, and \u003cstrong\u003ecomplaints\u003c\/strong\u003e—logging everything to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e and notifying the owner 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\u003eCreates a Gemini Live voice session:\u003c\/strong\u003e Receives a POST webhook request to start a new session.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApplies rate limits:\u003c\/strong\u003e Enforces \u003cem\u003edaily\u003c\/em\u003e and \u003cem\u003eper-IP\u003c\/em\u003e rate limiting before proceeding.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBuilds a knowledge base from Google Drive:\u003c\/strong\u003e Lists and downloads supported knowledge files from a specified \u003cstrong\u003eDrive folder\u003c\/strong\u003e, then combines them into a single system prompt.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates secure session credentials:\u003c\/strong\u003e Creates the Gemini Live session configuration (voice, model, and tool schema), signs session metadata with an \u003cstrong\u003eHMAC\u003c\/strong\u003e, and requests a \u003cstrong\u003esingle-use ephemeral token\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReturns session details to the client:\u003c\/strong\u003e Responds with the token, model, WebSocket URL, signed metadata, and the tool-callback URL.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHandles tool-call webhooks:\u003c\/strong\u003e Validates the HMAC signature and expiry, enforces a per-session tool-call limit, and routes authorized tools.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eConnects customers to store operations:\u003c\/strong\u003e Reads order data from Google Sheets for status, verifies and appends return\/exchange requests to Google Sheets and emails the owner, logs complaints to Google Sheets and emails the owner, or notifies the owner for unanswered questions.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReturns results or errors:\u003c\/strong\u003e Sends JSON tool results, or error responses for missing info, rate limits, unknown tools, or unauthorized calls.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eVoice-based \u003cstrong\u003eorder status\u003c\/strong\u003e for e-commerce shoppers\u003c\/li\u003e\n  \u003cli\u003eAutomated \u003cstrong\u003ereturn\/exchange\u003c\/strong\u003e request intake with owner notification\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eComplaint logging\u003c\/strong\u003e to Google Sheets with Gmail alerts\u003c\/li\u003e\n  \u003cli\u003eFallback owner notifications when questions can’t be answered from your Drive knowledge\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\/logic:\u003c\/strong\u003e if, set, code, switch, gmail, crypto\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Google Drive (knowledge files), Google Sheets (orders + logging), Gmail (owner notifications), Gemini Live (ephemeral token + WebSocket\/session + tool callbacks)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSecurity:\u003c\/strong\u003e HMAC signing\/validation for session metadata and tool-call authorization\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46288985391283,"sku":"N8N-21705","price":30.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/ugT8lsg_3fVVDNxvWdGDV_SboKrzaS.png?v=1793005404","url":"https:\/\/buyflowscripts.com\/products\/gemini-live-voice-support-n8n-workflow-w-drive-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}