Automation library · Scheduling

Route missed roofing calls to a Retell AI agent with Twilio

Started by another system calling it, and works across Google Calendar, Google Sheets and Twilio. 31 steps, 4 branches: large, and worth reading before you trust it with anything live.

Large

31 stepsLarge: read it before trusting it with anything live
4Branches: places the flow splits
0Loops or waits
3Services it connects to

The flow

Starts it 11Logic 9Service 11

The steps in the order they run, from what starts it.

  1. 1Webhook - Retell ToolsWebhookStarts it
  2. 2Webhook - Retell Call EndedWebhookStarts it
  3. 3Webhook - Twilio FallbackWebhookStarts it
  4. 4Switch - Route Tool NameSwitchLogic
  5. 5Google Sheets - Update Lead Row By CallIdGoogle SheetsService
  6. 6Format Call Log EntryCodeLogic
  7. 7Google Sheets - Lookup Service AreaGoogle SheetsService
  8. 8Google Calendar - Get Busy EventsGoogle CalendarService
  9. 9Code - Parse Booking ArgsCodeLogic
  10. 10Google Sheets - Append Urgent LeadGoogle SheetsService
  11. 11If - Booking CompletedIfLogic
  12. 12Google Sheets - Append Call LogGoogle SheetsService
  13. 13If - Call Was AnsweredIfLogic
  14. 14Code - Build Service Area ResponseCodeLogic
  15. 15Code - Compute Open SlotsCodeLogic
  16. 16Google Sheets - Search Recent DuplicateGoogle SheetsService
  17. 17Twilio - SMS On-Call EstimatorTwilioService
  18. 18Twilio - SMS Owner Call SummaryTwilioService
  19. 19Twilio - SMS Office Manager (Needs Follow-up)TwilioService
  20. 20Respond to Webhook - Call HandledRespond To WebhookStarts it
  21. 21Respond to Webhook - Route to AIRespond To WebhookStarts it
  22. 22Respond to Webhook - Service Area ResultRespond To WebhookStarts it
  23. 23Respond to Webhook - Availability ResultRespond To WebhookStarts it
  24. 24Code - Check Duplicate WindowCodeLogic
  25. 25Respond to Webhook - Escalated ResultRespond To WebhookStarts it
  26. 26Respond to Webhook - AckRespond To WebhookStarts it
  27. 27If - Is Duplicate LeadIfLogic
  28. 28Respond to Webhook - Duplicate ResultRespond To WebhookStarts it
  29. 29Google Calendar - Create Inspection EventGoogle CalendarService
  30. 30Google Sheets - Append Lead RowGoogle SheetsService
  31. 31Respond to Webhook - Booking ConfirmedRespond To WebhookStarts it

How it's built

Starts on
Another system calling it
Steps
31, with 4 branches
Size
Large: read it before trusting it with anything live
Connects to
Google Calendar, Google Sheets, Twilio
Model
None. This is plumbing, not judgement

Questions

What does it need to run?

An n8n account, plus your own Google Calendar, Google Sheets and Twilio accounts. You connect your own accounts after importing it; none are included.

What starts it?

It starts on another system calling it.

Does it use AI?

No. Every step is fixed logic or a call to a service, so it does the same thing every time.

How long does it take to set up?

Take your time. At 31 steps it is large: read it before trusting it with anything live.

How do I import it?

Copy the workflow, open a new workflow in n8n and paste. The steps appear on the canvas, ready for your own accounts.

Before you run it

Nothing here has been tested by us. It is somebody's working automation, read and described from its own steps. Treat the connections it wants as a list of accounts it will touch, and read the 31 steps before you point it at anything that matters.