{
  "name": "Recover missed calls with Twilio, Slack and Google Sheets",
  "nodes": [
    {
      "id": "f4fb7638-36e1-4b7c-a661-d7153a46af03",
      "name": "Skip - Call Was Answered",
      "type": "n8n-nodes-base.noOp",
      "position": [
        -416,
        560
      ]
    },
    {
      "id": "458423f0-bbe4-45cd-a9ec-1a466e6381d9",
      "name": "Receive Missed Call Webhook",
      "type": "n8n-nodes-base.webhook",
      "position": [
        -864,
        464
      ]
    },
    {
      "id": "72cd9de6-675f-47c6-9f2f-e5b6c13da36b",
      "name": "Check Call Failed/Busy/No-Answer",
      "type": "n8n-nodes-base.if",
      "position": [
        -640,
        464
      ]
    },
    {
      "id": "f4838746-3f2e-47fe-887f-ab1cecdfb2db",
      "name": "Check Business Hours",
      "type": "n8n-nodes-base.code",
      "position": [
        -416,
        368
      ]
    },
    {
      "id": "0819503f-36dd-421d-9a49-48a99b9314ad",
      "name": "Log Missed Call to Google Sheets",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -192,
        368
      ]
    },
    {
      "id": "3f9cc7ed-8fc5-4833-97a1-d5b0109ad9ab",
      "name": "Is It Business Hours?",
      "type": "n8n-nodes-base.if",
      "position": [
        32,
        368
      ]
    },
    {
      "id": "d022f704-5e65-4f30-be39-86597a502a8d",
      "name": "SMS - Call Back in 5 Minutes",
      "type": "n8n-nodes-base.twilio",
      "position": [
        256,
        272
      ]
    },
    {
      "id": "71b26c9e-a542-4355-9364-cd2312fc8326",
      "name": "SMS - Will Contact in Business Hours",
      "type": "n8n-nodes-base.twilio",
      "position": [
        256,
        464
      ]
    },
    {
      "id": "10303795-754a-449e-a2d7-0faa911f0318",
      "name": "Notify Team on Slack",
      "type": "n8n-nodes-base.slack",
      "position": [
        480,
        368
      ]
    },
    {
      "id": "fd720c49-849f-49c1-b144-74862aa40a61",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1472,
        16
      ],
      "parameters": {
        "width": 512,
        "height": 800,
        "content": "This workflow automatically recovers missed inbound calls so no potential lead is lost.\n\nWhen a call is missed in Twilio, the workflow captures the event, checks the call status, determines whether it"
      }
    },
    {
      "id": "c580a6c2-5def-4375-8a54-0a521391c35a",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -896,
        112
      ],
      "parameters": {
        "width": 416,
        "height": 624,
        "content": "## Call intake and filtering\n\nReceives inbound call events from Twilio via webhook. Filters for missed, busy, or failed calls and ignores answered ones. Only valid missed calls continue through the re"
      }
    },
    {
      "id": "9b4f1235-3327-46dd-96eb-3c1bafbe5f3f",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -464,
        112
      ],
      "parameters": {
        "width": 640,
        "height": 432,
        "content": "## Logging and business hour check\n\nLogs missed call details to Google Sheets for tracking and reporting. Then checks whether the call occurred during defined business hours to determine the correct S"
      }
    },
    {
      "id": "e358376d-2321-4fa9-bfcc-276602ab648b",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        192,
        112
      ],
      "parameters": {
        "width": 544,
        "height": 544,
        "content": "## Automated SMS and team notification\n\nSends an automatic SMS to the caller based on business hours, either promising a quick callback or setting next day expectations. Notifies the team in Slack wit"
      }
    }
  ],
  "connections": {
    "Check Business Hours": {
      "main": [
        [
          {
            "node": "Log Missed Call to Google Sheets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Is It Business Hours?": {
      "main": [
        [
          {
            "node": "SMS - Call Back in 5 Minutes",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "SMS - Will Contact in Business Hours",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Receive Missed Call Webhook": {
      "main": [
        [
          {
            "node": "Check Call Failed/Busy/No-Answer",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "SMS - Call Back in 5 Minutes": {
      "main": [
        [
          {
            "node": "Notify Team on Slack",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Check Call Failed/Busy/No-Answer": {
      "main": [
        [
          {
            "node": "Check Business Hours",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Skip - Call Was Answered",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Log Missed Call to Google Sheets": {
      "main": [
        [
          {
            "node": "Is It Business Hours?",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "SMS - Will Contact in Business Hours": {
      "main": [
        [
          {
            "node": "Notify Team on Slack",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}