{"product_id":"twilio-roofing-call-routing-to-retell-ai-google-sheets","title":"Twilio Roofing Call Routing to Retell AI + Google Sheets","description":"\u003ch3\u003eRoute Missed Roofing Calls to Retell AI—Check Coverage, Offer Slots, Book Inspections \u0026amp; Escalate Leaks\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow connects \u003cstrong\u003eTwilio\u003c\/strong\u003e missed roofing call handling with \u003cstrong\u003eRetell AI\u003c\/strong\u003e, using \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e and \u003cstrong\u003eGoogle Calendar\u003c\/strong\u003e to verify service coverage, present real inspection availability, book appointments, and urgently escalate suspected leaks by \u003cstrong\u003eTwilio SMS\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 Twilio fallback webhooks for inbound calls\u003c\/strong\u003e, logs call details to Google Sheets, and either ends the flow (when answered) or returns TwiML to forward the caller to the \u003cstrong\u003eRetell phone number\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHandles Retell tool webhook requests during the call\u003c\/strong\u003e and routes actions based on the requested tool name.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eService-area coverage check\u003c\/strong\u003e: looks up the caller’s \u003cstrong\u003eZIP\/region\u003c\/strong\u003e in the Google Sheets \u003cstrong\u003e“ServiceAreas”\u003c\/strong\u003e tab and responds with a JSON result indicating whether the address is covered.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAvailability check\u003c\/strong\u003e: reads busy events from the Google Calendar \u003cstrong\u003e“Inspections”\u003c\/strong\u003e calendar, then calculates the \u003cstrong\u003enext five open one-hour slots\u003c\/strong\u003e within business hours over the next \u003cstrong\u003eseven days\u003c\/strong\u003e and returns them to Retell.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBooking requests\u003c\/strong\u003e: parses booking details, searches Google Sheets \u003cstrong\u003e“Leads”\u003c\/strong\u003e for recent entries by phone number to prevent duplicates, and either returns a duplicate response or creates an \u003cstrong\u003einspection event\u003c\/strong\u003e in Google Calendar and appends a new lead row in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUrgent leak escalation\u003c\/strong\u003e: appends an urgent lead to Google Sheets and sends an on-call escalation \u003cstrong\u003eTwilio SMS\u003c\/strong\u003e, then returns an \u003cstrong\u003e“escalated”\u003c\/strong\u003e status to Retell.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eTurn missed roofing calls into instant AI-assisted triage with coverage verification and live scheduling options.\u003c\/li\u003e\n  \u003cli\u003eReduce double-booking by checking duplicates in the \u003cstrong\u003eLeads\u003c\/strong\u003e sheet before creating new inspection appointments.\u003c\/li\u003e\n  \u003cli\u003eEscalate urgent leak reports quickly with SMS while still logging outcomes and call artifacts to Google Sheets.\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, code, switch, twilio, webhook, sticky note\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations\u003c\/strong\u003e: Twilio (voice fallback + SMS), Retell AI (tool webhooks + TwiML forwarding), Google Sheets (\u003cstrong\u003eServiceAreas\u003c\/strong\u003e, \u003cstrong\u003eLeads\u003c\/strong\u003e), Google Calendar (\u003cstrong\u003eInspections\u003c\/strong\u003e)\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45931140841651,"sku":"N8N-18949","price":16.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/iMTdhm165qh7gP-HanZ3G_POqz4kto.png?v=1788254395","url":"https:\/\/buyflowscripts.com\/products\/twilio-roofing-call-routing-to-retell-ai-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}