{
  "name": "Google Calendar automated notifications with email, SMS & analytics dashboard",
  "nodes": [
    {
      "id": "5b691df1-5ce9-4ed2-8c62-46f3dc01e9a2",
      "name": "6 AM Daily Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        224,
        -336
      ]
    },
    {
      "id": "a9a40d14-9f77-4d9a-bdb6-39394fd6a9f4",
      "name": "Get Today's Events",
      "type": "n8n-nodes-base.googleCalendar",
      "position": [
        448,
        -336
      ]
    },
    {
      "id": "5276e607-6717-4957-a10b-422760a31a76",
      "name": "Format HTML Email",
      "type": "n8n-nodes-base.code",
      "position": [
        672,
        -336
      ]
    },
    {
      "id": "6d656a85-0e32-4351-8c24-f38dd58bb715",
      "name": "Send Email - Mailchimp Transactional",
      "type": "n8n-nodes-base.mailchimp",
      "position": [
        896,
        -512
      ]
    },
    {
      "id": "e53a471a-b992-4844-876e-4544bdff7626",
      "name": "7 AM Daily Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        224,
        -96
      ]
    },
    {
      "id": "ebdca122-34a2-4046-bcda-bbf361c1c08a",
      "name": "Format SMS Message",
      "type": "n8n-nodes-base.code",
      "position": [
        672,
        -96
      ]
    },
    {
      "id": "38ffbe70-59d0-4f20-b23d-263ad46f42bd",
      "name": "Get Today's Events1",
      "type": "n8n-nodes-base.googleCalendar",
      "position": [
        448,
        -96
      ]
    },
    {
      "id": "1f9d8602-d3bc-4c2d-97ed-18c31a005cc2",
      "name": "Check Every 5 Minutes1",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        208,
        320
      ]
    },
    {
      "id": "fc27caf0-857b-460d-b383-bdeae420a74e",
      "name": "Get Events in Next 20 Min1",
      "type": "n8n-nodes-base.googleCalendar",
      "position": [
        432,
        320
      ]
    },
    {
      "id": "677ad906-d696-46ba-8e75-ca9f625b25d3",
      "name": "Format Reminder SMS1",
      "type": "n8n-nodes-base.code",
      "position": [
        672,
        320
      ]
    },
    {
      "id": "cb8e4f2c-f5c2-46eb-a6d9-098bb8e2701c",
      "name": "Sunday 6 PM Trigger1",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        208,
        672
      ]
    },
    {
      "id": "25092f71-7b8f-4571-b190-fa4670436433",
      "name": "Get Next 7 Days1",
      "type": "n8n-nodes-base.googleCalendar",
      "position": [
        432,
        672
      ]
    },
    {
      "id": "ed2164a1-4825-4e21-b1e8-2796e517962d",
      "name": "Format Weekly Summary1",
      "type": "n8n-nodes-base.code",
      "position": [
        672,
        672
      ]
    },
    {
      "id": "dc72fb23-f78d-412c-b286-442728af7a43",
      "name": "Twilio SMS",
      "type": "n8n-nodes-base.twilio",
      "position": [
        896,
        -96
      ]
    },
    {
      "id": "b9865c86-5393-4abd-b81f-8551d738214a",
      "name": "Twilio SMS1",
      "type": "n8n-nodes-base.twilio",
      "position": [
        880,
        320
      ]
    },
    {
      "id": "50dc5e30-0389-4c35-8806-351a5e481a7f",
      "name": "Twilio SMS2",
      "type": "n8n-nodes-base.twilio",
      "position": [
        880,
        672
      ]
    },
    {
      "id": "7772cf91-7ff7-4f36-b8ea-2cfde7ce3f9d",
      "name": "Send an email",
      "type": "n8n-nodes-base.sendGrid",
      "position": [
        896,
        -336
      ]
    },
    {
      "id": "5627f00a-10b0-4fe4-9c90-5150b7edc27c",
      "name": "Append to Execution Log5",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1152,
        -336
      ]
    },
    {
      "id": "0ed219e7-4718-4cd2-ba76-8f9681f4e7ba",
      "name": "Append to Execution Log7",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1152,
        -96
      ]
    },
    {
      "id": "24e25e70-10d5-4cf5-a033-293910a6a80c",
      "name": "Append to Execution Log8",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1136,
        320
      ]
    },
    {
      "id": "b28d200c-1bb2-4ae4-b686-aa8346c8c675",
      "name": "Append to Execution Log9",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1136,
        672
      ]
    },
    {
      "id": "2ee2913c-e93a-4dd0-90e0-aad8110e384e",
      "name": "Update or append daily stats",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1392,
        -336
      ]
    },
    {
      "id": "ae950134-a459-428f-91fa-344bc2fb0832",
      "name": "Update or append daily stats1",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1376,
        -96
      ]
    },
    {
      "id": "015ea5fa-3da4-4f85-86a5-2a4fda183471",
      "name": "Update or append daily stats2",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1376,
        320
      ]
    },
    {
      "id": "5ad580b3-7e63-47a3-8b06-146af13abd61",
      "name": "Update or append daily stats3",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1360,
        672
      ]
    },
    {
      "id": "7af73f93-f434-4ae5-9344-be99542ef098",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        112,
        -768
      ],
      "parameters": {
        "width": 1504,
        "height": 960,
        "content": "## 1.  Daily Email and SMS Summary"
      }
    },
    {
      "id": "f7776254-ce07-499b-a109-c2ed66115c3b",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        96,
        224
      ],
      "parameters": {
        "width": 1536,
        "height": 320,
        "content": "## 2. 15-minute SMS Reminder before Events"
      }
    },
    {
      "id": "d8a05f69-ae2b-4ff4-b625-c0e32b01c5c5",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        96,
        576
      ],
      "parameters": {
        "width": 1536,
        "height": 320,
        "content": "## 3. Next 7-day Weekly Sunday SMS Review"
      }
    },
    {
      "id": "a22a9b1f-57b8-4c9f-ba76-12b35e495a62",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -672,
        -800
      ],
      "parameters": {
        "width": 640,
        "height": 832,
        "content": "## Auto Calendar Notifications and Real-Time Reporting with n8n and App Script\n\n## How it works\n- **Schedule Trigger** is to set a trigger on the precise time to run\n- **Google Calendar node** to read"
      }
    },
    {
      "id": "caead13e-f0e5-4b9d-9cac-319a24d2e6a5",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        832,
        -704
      ],
      "parameters": {
        "width": 272,
        "height": 544,
        "content": "## Can work with MailChimp by replacing with SendGrid - Standard plan or higher"
      }
    }
  ],
  "connections": {
    "Twilio SMS": {
      "main": [
        [
          {
            "node": "Append to Execution Log7",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Twilio SMS1": {
      "main": [
        [
          {
            "node": "Append to Execution Log8",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Twilio SMS2": {
      "main": [
        [
          {
            "node": "Append to Execution Log9",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send an email": {
      "main": [
        [
          {
            "node": "Append to Execution Log5",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Next 7 Days1": {
      "main": [
        [
          {
            "node": "Format Weekly Summary1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Format HTML Email": {
      "main": [
        [
          {
            "node": "Send an email",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "6 AM Daily Trigger": {
      "main": [
        [
          {
            "node": "Get Today's Events",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "7 AM Daily Trigger": {
      "main": [
        [
          {
            "node": "Get Today's Events1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Format SMS Message": {
      "main": [
        [
          {
            "node": "Twilio SMS",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Today's Events": {
      "main": [
        [
          {
            "node": "Format HTML Email",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Today's Events1": {
      "main": [
        [
          {
            "node": "Format SMS Message",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Format Reminder SMS1": {
      "main": [
        [
          {
            "node": "Twilio SMS1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Sunday 6 PM Trigger1": {
      "main": [
        [
          {
            "node": "Get Next 7 Days1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Check Every 5 Minutes1": {
      "main": [
        [
          {
            "node": "Get Events in Next 20 Min1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Format Weekly Summary1": {
      "main": [
        [
          {
            "node": "Twilio SMS2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Append to Execution Log5": {
      "main": [
        [
          {
            "node": "Update or append daily stats",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Append to Execution Log7": {
      "main": [
        [
          {
            "node": "Update or append daily stats1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Append to Execution Log8": {
      "main": [
        [
          {
            "node": "Update or append daily stats2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Append to Execution Log9": {
      "main": [
        [
          {
            "node": "Update or append daily stats3",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Events in Next 20 Min1": {
      "main": [
        [
          {
            "node": "Format Reminder SMS1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}