{"product_id":"n8n-voice-call-appointment-booking-to-google-sheets-claude","title":"n8n Voice Call Appointment Booking to Google Sheets (Claude)","description":"\u003ch3\u003eTurn voice-call transcripts into booked appointments—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow receives voice-call transcriptions via a webhook, determines availability in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and books or updates appointments. It then uses \u003cstrong\u003eAnthropic Claude\u003c\/strong\u003e to rewrite the drafted response into natural spoken wording before replying back with a JSON result.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives webhook input\u003c\/strong\u003e: Accepts a POST request with \u003ccode\u003esessionId\u003c\/code\u003e, transcribed caller text, and a \u003ccode\u003eturn number\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApplies abuse controls\u003c\/strong\u003e: Enforces allowed origin, per-session\/per-IP turn limits, and input length caps. If blocked, it returns a polite refusal.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLoads clinic configuration\u003c\/strong\u003e: Pulls in-workflow clinic setup and treatment\/service definitions, creates a stable synthetic phone number for the session, and checks for any existing lead in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes caller intent\u003c\/strong\u003e: Converts spoken phrasing into booking-friendly keywords (e.g., mapping “yes please” to “BOOK”) and resolves spoken day\/date into offered slot selections.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads and updates appointments\u003c\/strong\u003e: Checks existing appointments in Google Sheets and decides the next action—answer a question, offer available slots, confirm\/cancel\/reschedule, or create a new booking.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUses Anthropic Claude for speech\u003c\/strong\u003e: Sends the drafted reply plus allowed facts to Claude to produce more natural spoken phrasing, with a fallback to the draft if the model response is missing or appears invented.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReturns results + logs\u003c\/strong\u003e: Responds to the webhook caller with the final reply and diagnostic trace, then upserts the lead, appends any new appointment row, and logs the inbound message and reply to Google Sheets.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eClinic appointment booking from automated voice calls (transcript-based)\u003c\/li\u003e\n  \u003cli\u003eRescheduling or canceling appointments by interpreting caller confirmations\u003c\/li\u003e\n  \u003cli\u003eFast slot offering grounded in your live Google Sheets availability\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes\/stack\u003c\/strong\u003e: webhook, if, set, code, http request, and supporting workflow notes (sticky note)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations\u003c\/strong\u003e: Google Sheets (leads + appointment rows)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAI rewrite step\u003c\/strong\u003e: Anthropic Claude to transform the drafted response into spoken-ready language\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45923089449139,"sku":"N8N-18858","price":33.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/7EfXKQL3WwfBUHUkr2NND_FG28L8Fy.png?v=1788168244","url":"https:\/\/buyflowscripts.com\/products\/n8n-voice-call-appointment-booking-to-google-sheets-claude","provider":"N8N Commerce","version":"1.0","type":"link"}