{
  "name": "Travel itinerary reminders with Google Calendar, Excel, and SMS/Email alerts",
  "nodes": [
    {
      "id": "2c9cace5-a7fa-4a0f-975d-c10c7f4405ad",
      "name": "Daily Travel Check",
      "type": "n8n-nodes-base.cron",
      "position": [
        -448,
        240
      ]
    },
    {
      "id": "5e304a56-4b9c-42dc-84d9-b63f336a5a99",
      "name": "Read Travel Itinerary",
      "type": "n8n-nodes-base.microsoftExcel",
      "position": [
        -224,
        240
      ]
    },
    {
      "id": "e41bf01b-ddc7-47cb-b0b8-027016b22fca",
      "name": "Filter Today's Trips",
      "type": "n8n-nodes-base.code",
      "position": [
        0,
        240
      ]
    },
    {
      "id": "a978bf0f-96e8-4257-abd0-a10b19dc3143",
      "name": "Has Trips Today?",
      "type": "n8n-nodes-base.if",
      "position": [
        224,
        128
      ]
    },
    {
      "id": "bcd8b022-52db-4095-8f69-6c95f8b1135f",
      "name": "Read Traveler Contacts",
      "type": "n8n-nodes-base.microsoftExcel",
      "position": [
        448,
        128
      ]
    },
    {
      "id": "586c2dcb-e203-4817-874b-c52480abe596",
      "name": "Create Traveler Reminders",
      "type": "n8n-nodes-base.code",
      "position": [
        656,
        240
      ]
    },
    {
      "id": "7773868f-847a-4e2c-b3f8-d9c46342235b",
      "name": "Split Into Batches",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        1088,
        240
      ]
    },
    {
      "id": "4b4296c2-4710-49e0-9272-c5dc39e4e7d2",
      "name": "Email or SMS?",
      "type": "n8n-nodes-base.if",
      "position": [
        1312,
        240
      ]
    },
    {
      "id": "0c27ad59-6f7b-49ea-93a9-93529773438f",
      "name": "Prepare Email Reminders",
      "type": "n8n-nodes-base.code",
      "position": [
        1536,
        128
      ]
    },
    {
      "id": "71d0ce98-bcb5-4b70-9be8-a3bc7264c8a7",
      "name": "Prepare SMS Reminders",
      "type": "n8n-nodes-base.code",
      "position": [
        1536,
        336
      ]
    },
    {
      "id": "bd8a65eb-1712-42ce-82de-f9b6525a2a00",
      "name": "Sync to Google Calendar",
      "type": "n8n-nodes-base.googleCalendar",
      "position": [
        448,
        336
      ]
    },
    {
      "id": "7cd24c85-ebc9-488a-ba09-0d038aed0600",
      "name": "Read Reminder Log",
      "type": "n8n-nodes-base.microsoftExcel",
      "position": [
        1744,
        240
      ]
    },
    {
      "id": "fec45952-9b13-4611-89da-5dda16dc9895",
      "name": "Update Reminder Log",
      "type": "n8n-nodes-base.code",
      "position": [
        1968,
        240
      ]
    },
    {
      "id": "3b8caca5-4c45-484b-860f-17ef4ea2566b",
      "name": "Save Reminder Log",
      "type": "n8n-nodes-base.microsoftExcel",
      "position": [
        2192,
        240
      ]
    },
    {
      "id": "aed8c63f-1c9d-43a3-b514-8b971303a377",
      "name": "Wait For Data",
      "type": "n8n-nodes-base.wait",
      "position": [
        864,
        240
      ]
    },
    {
      "id": "c32a8171-99f7-4a2f-9b13-c70de6b93e02",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        288,
        -256
      ],
      "parameters": {
        "width": 624,
        "height": 272,
        "content": "## What This Workflow Does\n\n* Automatically checks travel itineraries every day\n* Identifies today's trips and upcoming departures\n* Syncs trip information to Google Calendar\n* Sends personalized remi"
      }
    },
    {
      "id": "8bb24600-34ec-4f10-a221-4d900ad777b4",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        336,
        -576
      ],
      "parameters": {
        "width": 560,
        "height": 240,
        "content": "## Essential Prerequisites\n\n* Travel itinerary database/Excel file with trip assignments\n* Traveler contact database with email and phone numbers\n* Google Calendar API access and credentials\n* SMTP se"
      }
    },
    {
      "id": "24480f08-45ae-418e-a086-aaea9b8648a3",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        960,
        -672
      ],
      "parameters": {
        "width": 512,
        "height": 816,
        "content": "## Required Data Files\n\n### trip_itinerary.xlsx:\n* Trip ID | Trip Name | Date | Departure Time | Duration\n* Departure Location | Destination | Hotel | Flight Number\n* Assigned Travelers | Status | Boo"
      }
    },
    {
      "id": "f3b7fd2c-3fd6-4fc1-aff2-94241fb42a28",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -464,
        -528
      ],
      "parameters": {
        "width": 640,
        "height": 416,
        "content": "## Main Components\n\n* **Daily Travel Check** - Triggers daily to check travel itineraries\n* **Read Travel Itinerary** - Retrieves today's trips and bookings from database/Excel\n* **Filter Today's Trip"
      }
    }
  ],
  "connections": {
    "Email or SMS?": {
      "main": [
        [
          {
            "node": "Prepare Email Reminders",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Prepare SMS Reminders",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Wait For Data": {
      "main": [
        [
          {
            "node": "Split Into Batches",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Has Trips Today?": {
      "main": [
        [
          {
            "node": "Read Traveler Contacts",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Read Reminder Log": {
      "main": [
        [
          {
            "node": "Update Reminder Log",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Daily Travel Check": {
      "main": [
        [
          {
            "node": "Read Travel Itinerary",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Split Into Batches": {
      "main": [
        [
          {
            "node": "Email or SMS?",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Update Reminder Log": {
      "main": [
        [
          {
            "node": "Save Reminder Log",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Filter Today's Trips": {
      "main": [
        [
          {
            "node": "Has Trips Today?",
            "type": "main",
            "index": 0
          },
          {
            "node": "Sync to Google Calendar",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Prepare SMS Reminders": {
      "main": [
        [
          {
            "node": "Read Reminder Log",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Read Travel Itinerary": {
      "main": [
        [
          {
            "node": "Filter Today's Trips",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Read Traveler Contacts": {
      "main": [
        [
          {
            "node": "Create Traveler Reminders",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Prepare Email Reminders": {
      "main": [
        [
          {
            "node": "Read Reminder Log",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Sync to Google Calendar": {
      "main": [
        [
          {
            "node": "Create Traveler Reminders",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Create Traveler Reminders": {
      "main": [
        [
          {
            "node": "Wait For Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}