{
  "name": "Hotel guest journey automation with Gmail & Google Sheets",
  "nodes": [
    {
      "id": "7befd68e-1976-4e76-a283-f00955b26582",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        368,
        336
      ],
      "parameters": {
        "width": 512,
        "height": 240,
        "content": "🏨 PRE-ARRIVAL WELCOME EMAIL AUTOMATION\n═══════════════════════════════════════════════════════════\n✨ Automatically sends personalized welcome emails 1-2 days before check-in\n📧 Includes reservation det"
      }
    },
    {
      "id": "c25c0e43-0a84-449a-856f-e0c37d166bc8",
      "name": "Schedule Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        400,
        640
      ]
    },
    {
      "id": "db181591-4b20-4919-acf7-de13edddd5a0",
      "name": "Edit Fields",
      "type": "n8n-nodes-base.set",
      "position": [
        592,
        640
      ]
    },
    {
      "id": "42dcd64c-0fba-4886-957e-fe6f76ac0171",
      "name": "Switch",
      "type": "n8n-nodes-base.switch",
      "position": [
        1184,
        672
      ]
    },
    {
      "id": "136a56f4-c7e3-4231-ac45-ecc17bb381bd",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        960,
        336
      ],
      "parameters": {
        "width": 416,
        "height": 256,
        "content": "⭐ POST-STAY REVIEW REQUEST AUTOMATION\n═══════════════════════════════════════════════════════════\n🎯 Automatically requests reviews from guests 24 hours after checkout\n📝 Includes Google Reviews and Tri"
      }
    },
    {
      "id": "de93fa3f-c28f-4738-95b7-1115f0d2c33e",
      "name": "Welcome Email",
      "type": "n8n-nodes-base.gmail",
      "position": [
        1744,
        608
      ]
    },
    {
      "id": "1e7320e3-3824-4151-833c-77c8565852d8",
      "name": "Write Review",
      "type": "n8n-nodes-base.gmail",
      "position": [
        1712,
        848
      ]
    },
    {
      "id": "a1b1c191-ab75-4b91-821e-c93af3502970",
      "name": "Daily at 6 AM",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        336,
        1520
      ]
    },
    {
      "id": "2ad1c6ca-ddc3-4341-a57b-af2cb0b409f2",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        336,
        1280
      ],
      "parameters": {
        "width": 496,
        "height": 208,
        "content": "📋 DAILY ARRIVALS & DEPARTURES AUTOMATION\n═══════════════════════════════════════════════════════════\n🌅 Runs every morning at 6:00 AM\n📊 Generates comprehensive arrival/departure report\n📧 Emails to fron"
      }
    },
    {
      "id": "a026265f-89b7-4eaf-978e-78da9196bc58",
      "name": "Get Hotel Reservation",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        752,
        640
      ]
    },
    {
      "id": "4d3de6a5-c629-4441-98ad-72fcc7749d18",
      "name": "Filter Upcoming Guest",
      "type": "n8n-nodes-base.filter",
      "position": [
        944,
        640
      ]
    },
    {
      "id": "54f73600-b1f4-43e9-8cf1-085c870b2914",
      "name": "Filter Today's Arrivals",
      "type": "n8n-nodes-base.filter",
      "position": [
        1008,
        1488
      ]
    },
    {
      "id": "56671ab0-8308-43be-bba8-9bdb0785876a",
      "name": "Filter Today's Departures",
      "type": "n8n-nodes-base.filter",
      "position": [
        1008,
        1696
      ]
    },
    {
      "id": "6d4a09b8-e497-4eff-872b-d607502dc134",
      "name": "Add Information",
      "type": "n8n-nodes-base.set",
      "position": [
        512,
        1520
      ]
    },
    {
      "id": "f7b35941-581c-4151-bb15-b5819e329bbf",
      "name": "Create E mail HTMl",
      "type": "n8n-nodes-base.set",
      "position": [
        1280,
        1568
      ]
    },
    {
      "id": "af87b761-f185-4b3c-8d2a-6e83739c98c7",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -240,
        288
      ],
      "parameters": {
        "width": 480,
        "height": 1056,
        "content": "🏨 HOTEL GUEST COMMUNICATION AUTOMATION\n═══════════════════════════════════════════════════════════\n✨ Complete guest journey automation from booking to post-stay\n📧 Pre-arrival welcome emails (1-2 days "
      }
    },
    {
      "id": "a7314fef-efc9-4c72-b1b5-b03ac1f7b625",
      "name": "Filter Unsent Welcome Emails",
      "type": "n8n-nodes-base.filter",
      "position": [
        1456,
        608
      ]
    },
    {
      "id": "84f4af1e-ae12-474b-970b-c72cccaa7e4a",
      "name": "Filter Unsent Review Requests",
      "type": "n8n-nodes-base.filter",
      "position": [
        1456,
        832
      ]
    },
    {
      "id": "fcc8fcde-b050-41cd-900c-655c222d0fa9",
      "name": "Mark Welcome Email as Sent",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1952,
        608
      ]
    },
    {
      "id": "e868be76-2548-409b-a07f-aecad9c8492d",
      "name": "Mark Review Email as Sent",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1936,
        848
      ]
    },
    {
      "id": "0ca981cf-f1cc-454d-ae86-21a8cd385c0c",
      "name": "Send Daily Staff Report",
      "type": "n8n-nodes-base.gmail",
      "position": [
        1488,
        1568
      ]
    },
    {
      "id": "eec36efc-0b64-4c72-9b93-e15d394e9faf",
      "name": "Get All Reservations",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        736,
        1520
      ]
    }
  ],
  "connections": {
    "Switch": {
      "main": [
        [
          {
            "node": "Filter Unsent Welcome Emails",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Filter Unsent Review Requests",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Edit Fields": {
      "main": [
        [
          {
            "node": "Get Hotel Reservation",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Write Review": {
      "main": [
        [
          {
            "node": "Mark Review Email as Sent",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Daily at 6 AM": {
      "main": [
        [
          {
            "node": "Add Information",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Welcome Email": {
      "main": [
        [
          {
            "node": "Mark Welcome Email as Sent",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Add Information": {
      "main": [
        [
          {
            "node": "Get All Reservations",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "Edit Fields",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Create E mail HTMl": {
      "main": [
        [
          {
            "node": "Send Daily Staff Report",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get All Reservations": {
      "main": [
        [
          {
            "node": "Filter Today's Arrivals",
            "type": "main",
            "index": 0
          },
          {
            "node": "Filter Today's Departures",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Filter Upcoming Guest": {
      "main": [
        [
          {
            "node": "Switch",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Hotel Reservation": {
      "main": [
        [
          {
            "node": "Filter Upcoming Guest",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Filter Today's Arrivals": {
      "main": [
        [
          {
            "node": "Create E mail HTMl",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Filter Today's Departures": {
      "main": [
        [
          {
            "node": "Create E mail HTMl",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Filter Unsent Welcome Emails": {
      "main": [
        [
          {
            "node": "Welcome Email",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Filter Unsent Review Requests": {
      "main": [
        [
          {
            "node": "Write Review",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}