Système de réservation d'hôtels

• •Compte Google et informations d'identification Gmail API
• •Informations d'identification Google Sheets API

{
  "id": "FgamqYDVNixmK2gV",
  "meta": {
    "instanceId": "f080fafc9937b6b383f471ad8cc35ad1727032832bd16212f900e0577db46644",
    "templateCredsSetupCompleted": true
  },
  "name": "Hotel Booking System",
  "tags": [],
  "nodes": [
    {
      "id": "7befd68e-1976-4e76-a283-f00955b26582",
      "name": "Note adhésive",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        368,
        336
      ],
      "parameters": {
        "color": 6,
        "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 details, hotel amenities, and contact information\n🔄 Checks every 6 hours for upcoming arrivals\n⚡ Updates tracking to prevent duplicate emails\n\n🎯 PERFECT FOR: Guest experience enhancement | Reducing front desk inquiries | Professional first impression"
      },
      "typeVersion": 1
    },
    {
      "id": "c25c0e43-0a84-449a-856f-e0c37d166bc8",
      "name": "Déclencheur Planifié",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        400,
        640
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "field": "hours",
              "hoursInterval": 6
            }
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "db181591-4b20-4919-acf7-de13edddd5a0",
      "name": "Modifier les champs",
      "type": "n8n-nodes-base.set",
      "position": [
        592,
        640
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "0583a748-dcd8-401e-8462-d9cf9920940f",
              "name": "Hotel Name",
              "type": "string",
              "value": "Mr. Wonderful"
            }
          ]
        },
        "includeOtherFields": true
      },
      "typeVersion": 3.4
    },
    {
      "id": "42dcd64c-0fba-4886-957e-fe6f76ac0171",
      "name": "Commutateur",
      "type": "n8n-nodes-base.switch",
      "position": [
        1184,
        672
      ],
      "parameters": {
        "rules": {
          "values": [
            {
              "outputKey": "welcome email",
              "conditions": {
                "options": {
                  "version": 2,
                  "leftValue": "",
                  "caseSensitive": true,
                  "typeValidation": "loose"
                },
                "combinator": "and",
                "conditions": [
                  {
                    "id": "a94938f6-a07d-49d4-a279-73cb2e6a3a6e",
                    "operator": {
                      "type": "boolean",
                      "operation": "true",
                      "singleValue": true
                    },
                    "leftValue": "={{ Boolean(Math.ceil(DateTime.fromFormat($json['Check-in Date'], 'M/d/yyyy HH:mm:ss').diff(DateTime.now(), 'days').days) > 0 && Math.ceil(DateTime.fromFormat($json['Check-in Date'], 'M/d/yyyy HH:mm:ss').diff(DateTime.now(), 'days').days) <= 2) }}",
                    "rightValue": 2
                  }
                ]
              },
              "renameOutput": true
            },
            {
              "outputKey": "Write Review",
              "conditions": {
                "options": {
                  "version": 2,
                  "leftValue": "",
                  "caseSensitive": true,
                  "typeValidation": "loose"
                },
                "combinator": "and",
                "conditions": [
                  {
                    "id": "b78e6271-d55b-43a5-b44f-c44c2e3d9c0b",
                    "operator": {
                      "type": "boolean",
                      "operation": "true",
                      "singleValue": true
                    },
                    "leftValue": "={{ Boolean(Math.abs(DateTime.fromFormat($json['Check-out Date'], 'M/d/yyyy HH:mm:ss').diff(DateTime.now(), 'days').days) >= 1 && Math.abs(DateTime.fromFormat($json['Check-out Date'], 'M/d/yyyy HH:mm:ss').diff(DateTime.now(), 'days').days) <= 2) }}",
                    "rightValue": 1
                  }
                ]
              },
              "renameOutput": true
            }
          ]
        },
        "options": {},
        "looseTypeValidation": true
      },
      "typeVersion": 3.2
    },
    {
      "id": "136a56f4-c7e3-4231-ac45-ecc17bb381bd",
      "name": "Note adhésive 1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        960,
        336
      ],
      "parameters": {
        "color": 6,
        "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 TripAdvisor links\n🎁 Offers return guest discount codes\n📞 Provides direct contact for any issues\n\n💡 BOOSTS: Online reputation | Future bookings | Guest loyalty | Review volume"
      },
      "typeVersion": 1
    },
    {
      "id": "de93fa3f-c28f-4738-95b7-1115f0d2c33e",
      "name": "E-mail de bienvenue",
      "type": "n8n-nodes-base.gmail",
      "position": [
        1744,
        608
      ],
      "webhookId": "0ad03fe4-6be0-4c11-8087-9c62cfeab4b1",
      "parameters": {
        "sendTo": "={{ $json['Guest Email'] }}",
        "message": "=<!DOCTYPE html>\n<html lang=\"en\">\n<head>\n    <meta charset=\"UTF-8\">\n    <meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\n    <title>Hotel Reservation Confirmation</title>\n</head>\n<body style=\"font-family: 'Segoe UI', Tahoma, Geneva, Verdana, sans-serif; line-height: 1.6; background-color: #f4f7fa; margin: 0; padding: 20px 0;\">\n    \n    <table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" width=\"100%\" style=\"max-width: 600px; margin: 0 auto; background: white; border-radius: 12px; box-shadow: 0 4px 20px rgba(0,0,0,0.1);\">\n        \n        <!-- Header -->\n        <tr>\n            <td style=\"background: linear-gradient(135deg, #2c5aa0 0%, #1e3a5f 100%); background-color: #2c5aa0; color: white; padding: 30px 40px; text-align: center;\">\n                <h1 style=\"font-size: 28px; margin: 0 0 10px 0; font-weight: 300;\">[Hotel Name]</h1>\n                <p style=\"font-size: 16px; opacity: 0.9; margin: 0;\">Luxury & Comfort Redefined</p>\n            </td>\n        </tr>\n        \n        <!-- Main Content -->\n        <tr>\n            <td style=\"padding: 40px;\">\n                \n                <!-- Greeting -->\n                <div style=\"font-size: 18px; color: #333; margin-bottom: 20px;\">\n                    Dear <strong>{{ $json['Guest Name'] }}</strong>,\n                </div>\n                \n                <!-- Confirmation Message -->\n                <div style=\"background: linear-gradient(135deg, #e8f5e8 0%, #f0f8f0 100%); background-color: #e8f5e8; border-left: 4px solid #28a745; padding: 20px; margin: 25px 0; border-radius: 8px;\">\n                    <p style=\"color: #155724; font-weight: 500; margin: 0;\">🎉 We're thrilled to welcome you to [Hotel Name]! Your reservation is confirmed for {{ $json['Check-in Date'] }} to {{ $json['Check-out Date'] }}.</p>\n                </div>\n                \n                <!-- Reservation Details Section -->\n                <div style=\"margin: 30px 0;\">\n                    <h2 style=\"display: flex; align-items: center; font-size: 20px; color: #2c5aa0; margin-bottom: 20px; font-weight: 600;\">\n                        <span style=\"margin-right: 12px; font-size: 24px;\">🏨</span>\n                        Your Reservation Details\n                    </h2>\n                    \n                    <table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" width=\"100%\" style=\"background: #f8f9fa; border-radius: 8px; padding: 25px;\">\n                        <tr>\n                            <td style=\"padding: 12px 0; border-bottom: 1px solid #e9ecef;\">\n                                <table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" width=\"100%\">\n                                    <tr>\n                                        <td style=\"font-weight: 600; color: #495057;\">Reservation ID:</td>\n                                        <td style=\"color: #2c5aa0; font-weight: 500; text-align: right;\">{{ $json['Booking ID'] }}</td>\n                                    </tr>\n                                </table>\n                            </td>\n                        </tr>\n                        <tr>\n                            <td style=\"padding: 12px 0; border-bottom: 1px solid #e9ecef;\">\n                                <table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" width=\"100%\">\n                                    <tr>\n                                        <td style=\"font-weight: 600; color: #495057;\">Room Type:</td>\n                                        <td style=\"color: #2c5aa0; font-weight: 500; text-align: right;\">{{ $json['Room Type'] }}</td>\n                                    </tr>\n                                </table>\n                            </td>\n                        </tr>\n                        <tr>\n                            <td style=\"padding: 12px 0; border-bottom: 1px solid #e9ecef;\">\n                                <table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" width=\"100%\">\n                                    <tr>\n                                        <td style=\"font-weight: 600; color: #495057;\">Number of Guests:</td>\n                                        <td style=\"color: #2c5aa0; font-weight: 500; text-align: right;\">{{ $json['Guest Count'] }}</td>\n                                    </tr>\n                                </table>\n                            </td>\n                        </tr>\n                        <tr>\n                            <td style=\"padding: 12px 0; border-bottom: 1px solid #e9ecef;\">\n                                <table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" width=\"100%\">\n                                    <tr>\n                                        <td style=\"font-weight: 600; color: #495057;\">Check-in:</td>\n                                        <td style=\"color: #2c5aa0; font-weight: 500; text-align: right;\">{{ $json['Check-in Date'] }} (3:00 PM)</td>\n                                    </tr>\n                                </table>\n                            </td>\n                        </tr>\n                        <tr>\n                            <td style=\"padding: 12px 0;\">\n                                <table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" width=\"100%\">\n                                    <tr>\n                                        <td style=\"font-weight: 600; color: #495057;\">Check-out:</td>\n                                        <td style=\"color: #2c5aa0; font-weight: 500; text-align: right;\">{{ $json['Check-out Date'] }} (11:00 AM)</td>\n                                    </tr>\n                                </table>\n                            </td>\n                        </tr>\n                    </table>\n                </div>\n                \n                <!-- Amenities Section -->\n                <div style=\"margin: 30px 0;\">\n                    <h2 style=\"font-size: 20px; color: #2c5aa0; margin-bottom: 20px; font-weight: 600;\">\n                        <span style=\"margin-right: 12px; font-size: 24px;\">🅿️</span>\n                        What You Need to Know\n                    </h2>\n                    \n                    <div style=\"background: white; margin: 12px 0; padding: 15px 20px; border-radius: 8px; border-left: 4px solid #2c5aa0; box-shadow: 0 2px 8px rgba(0,0,0,0.05);\">\n                        <div style=\"font-weight: 600; color: #2c5aa0; margin-bottom: 5px;\">Free WiFi</div>\n                        <div style=\"color: #666;\">Network: HotelGuest | Password: welcome2024</div>\n                    </div>\n                    \n                    <div style=\"background: white; margin: 12px 0; padding: 15px 20px; border-radius: 8px; border-left: 4px solid #2c5aa0; box-shadow: 0 2px 8px rgba(0,0,0,0.05);\">\n                        <div style=\"font-weight: 600; color: #2c5aa0; margin-bottom: 5px;\">Complimentary Breakfast</div>\n                        <div style=\"color: #666;\">Available daily from 7:00 AM - 10:00 AM</div>\n                    </div>\n                    \n                    <div style=\"background: white; margin: 12px 0; padding: 15px 20px; border-radius: 8px; border-left: 4px solid #2c5aa0; box-shadow: 0 2px 8px rgba(0,0,0,0.05);\">\n                        <div style=\"font-weight: 600; color: #2c5aa0; margin-bottom: 5px;\">Parking</div>\n                        <div style=\"color: #666;\">Available on-site for $15/night</div>\n                    </div>\n                    \n                    <div style=\"background: white; margin: 12px 0; padding: 15px 20px; border-radius: 8px; border-left: 4px solid #2c5aa0; box-shadow: 0 2px 8px rgba(0,0,0,0.05);\">\n                        <div style=\"font-weight: 600; color: #2c5aa0; margin-bottom: 5px;\">Fitness Center</div>\n                        <div style=\"color: #666;\">Open 24/7 for all guests</div>\n                    </div>\n                </div>\n                \n                <!-- Contact Section -->\n                <div style=\"margin: 30px 0;\">\n                    <h2 style=\"font-size: 20px; color: #2c5aa0; margin-bottom: 20px; font-weight: 600;\">\n                        <span style=\"margin-right: 12px; font-size: 24px;\">📞</span>\n                        Contact Us\n                    </h2>\n                    \n                    <table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" width=\"100%\">\n                        <tr>\n                            <td width=\"50%\" style=\"padding-right: 10px;\">\n                                <div style=\"background: linear-gradient(135deg, #f8f9fa 0%, #ffffff 100%); background-color: #f8f9fa; padding: 20px; border-radius: 8px; text-align: center; border: 2px solid #e9ecef;\">\n                                    <div style=\"font-weight: 600; color: #2c5aa0; margin-bottom: 10px;\">Front Desk</div>\n                                    <div style=\"color: #495057; font-weight: 500;\">\n                                        <a href=\"tel:+15551234567\" style=\"color: #2c5aa0; text-decoration: none;\">+1 (555) 123-4567</a>\n                                    </div>\n                                </div>\n                            </td>\n                            <td width=\"50%\" style=\"padding-left: 10px;\">\n                                <div style=\"background: linear-gradient(135deg, #f8f9fa 0%, #ffffff 100%); background-color: #f8f9fa; padding: 20px; border-radius: 8px; text-align: center; border: 2px solid #e9ecef;\">\n                                    <div style=\"font-weight: 600; color: #2c5aa0; margin-bottom: 10px;\">Concierge</div>\n                                    <div style=\"color: #495057; font-weight: 500;\">\n                                        <a href=\"mailto:concierge@yourhotel.com\" style=\"color: #2c5aa0; text-decoration: none;\">concierge@yourhotel.com</a>\n                                    </div>\n                                </div>\n                            </td>\n                        </tr>\n                    </table>\n                </div>\n                \n            </td>\n        </tr>\n        \n        <!-- Footer -->\n        <tr>\n            <td style=\"background: #2c5aa0; color: white; padding: 30px 40px; text-align: center;\">\n                <div style=\"font-size: 18px; margin-bottom: 15px;\">We can't wait to make your stay memorable!</div>\n                <div style=\"opacity: 0.9; font-style: italic;\">\n                    Warm regards,<br>\n                    <strong>The [Hotel Name] Team</strong>\n                </div>\n            </td>\n        </tr>\n        \n    </table>\n    \n</body>\n</html>\n",
        "options": {},
        "subject": "Welcome to Hotel - Your Stay Begins Soon! 🏨"
      },
      "credentials": {
        "gmailOAuth2": {
          "id": "NaIYTcsDtoNYLBYA",
          "name": "Gmail account"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "1e7320e3-3824-4151-833c-77c8565852d8",
      "name": "Demande d'avis",
      "type": "n8n-nodes-base.gmail",
      "position": [
        1712,
        848
      ],
      "webhookId": "0ad03fe4-6be0-4c11-8087-9c62cfeab4b1",
      "parameters": {
        "sendTo": "={{ $('Filter Upcoming Guest').item.json['Guest Email'] }}",
        "message": "=<!DOCTYPE html>\n<html lang=\"en\">\n<head>\n    <meta charset=\"UTF-8\">\n    <meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\n    <title>Thank You for Your Stay - Share Your Experience</title>\n</head>\n<body style=\"font-family: 'Segoe UI', Tahoma, Geneva, Verdana, sans-serif; line-height: 1.6; background-color: #f4f7fa; margin: 0; padding: 20px 0;\">\n    \n    <table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" width=\"100%\" style=\"max-width: 600px; margin: 0 auto; background: white; border-radius: 12px; box-shadow: 0 4px 20px rgba(0,0,0,0.1);\">\n        \n        <!-- Header -->\n        <tr>\n            <td style=\"background: linear-gradient(135deg, #2c5aa0 0%, #1e3a5f 100%); background-color: #2c5aa0; color: white; padding: 30px 40px; text-align: center;\">\n                <h1 style=\"font-size: 28px; margin: 0 0 10px 0; font-weight: 300;\">{{ $('Edit Fields').item.json['Hotel Name'] }}</h1>\n                <p style=\"font-size: 16px; opacity: 0.9; margin: 0;\">Thank You for Choosing Us</p>\n            </td>\n        </tr>\n        \n        <!-- Main Content -->\n        <tr>\n            <td style=\"padding: 40px;\">\n                \n                <!-- Greeting -->\n                <div style=\"font-size: 18px; color: #333; margin-bottom: 20px;\">\n                    Dear <strong>{{ $json['Guest Name'] }}</strong>,\n                </div>\n                \n                <!-- Thank You Message -->\n                <div style=\"background: linear-gradient(135deg, #e8f5e8 0%, #f0f8f0 100%); background-color: #e8f5e8; border-left: 4px solid #28a745; padding: 20px; margin: 25px 0; border-radius: 8px;\">\n                    <p style=\"color: #155724; font-weight: 500; margin: 0;\">🙏 Thank you for staying with us from {{ $json['Check-in Date'] }} to {{ $json['Check-out Date'] }}. We hope you had a wonderful experience!</p>\n                </div>\n                \n                <!-- Review Request Section -->\n                <div style=\"margin: 30px 0;\">\n                    <h2 style=\"display: flex; align-items: center; font-size: 20px; color: #2c5aa0; margin-bottom: 20px; font-weight: 600;\">\n                        <span style=\"margin-right: 12px; font-size: 24px;\">⭐</span>\n                        Share Your Experience\n                    </h2>\n                    \n                    <div style=\"background: #f8f9fa; border-radius: 8px; padding: 25px; text-align: center;\">\n                        <p style=\"color: #495057; font-size: 16px; margin-bottom: 25px;\">Your feedback helps us improve and helps future guests make informed decisions. Would you mind taking a moment to share your experience?</p>\n                        \n                        <!-- Google Review Button -->\n                        <div style=\"margin: 20px 0;\">\n                            <a href=\"https://g.page/r/[YOUR_GOOGLE_BUSINESS_ID]/review\" style=\"display: inline-block; background: linear-gradient(135deg, #4285f4 0%, #1a73e8 100%); background-color: #4285f4; color: white; padding: 15px 30px; text-decoration: none; border-radius: 8px; font-weight: 600; font-size: 16px; box-shadow: 0 4px 12px rgba(66, 133, 244, 0.3);\">\n                                📝 Write a Google Review\n                            </a>\n                        </div>\n                        \n                        <p style=\"color: #666; font-size: 14px; margin-top: 15px;\">It only takes 2 minutes and means the world to us!</p>\n                    </div>\n                </div>\n                \n                <!-- Stay Summary Section -->\n                <div style=\"margin: 30px 0;\">\n                    <h2 style=\"display: flex; align-items: center; font-size: 20px; color: #2c5aa0; margin-bottom: 20px; font-weight: 600;\">\n                        <span style=\"margin-right: 12px; font-size: 24px;\">🏨</span>\n                        Your Recent Stay\n                    </h2>\n                    \n                    <table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" width=\"100%\" style=\"background: #f8f9fa; border-radius: 8px; padding: 25px;\">\n                        <tr>\n                            <td style=\"padding: 12px 0; border-bottom: 1px solid #e9ecef;\">\n                                <table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" width=\"100%\">\n                                    <tr>\n                                        <td style=\"font-weight: 600; color: #495057;\">Reservation ID:</td>\n                                        <td style=\"color: #2c5aa0; font-weight: 500; text-align: right;\">{{ $json['Booking ID'] }}</td>\n                                    </tr>\n                                </table>\n                            </td>\n                        </tr>\n                        <tr>\n                            <td style=\"padding: 12px 0; border-bottom: 1px solid #e9ecef;\">\n                                <table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" width=\"100%\">\n                                    <tr>\n                                        <td style=\"font-weight: 600; color: #495057;\">Room Type:</td>\n                                        <td style=\"color: #2c5aa0; font-weight: 500; text-align: right;\">{{ $json['Room Type'] }}</td>\n                                    </tr>\n                                </table>\n                            </td>\n                        </tr>\n                        <tr>\n                            <td style=\"padding: 12px 0; border-bottom: 1px solid #e9ecef;\">\n                                <table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" width=\"100%\">\n                                    <tr>\n                                        <td style=\"font-weight: 600; color: #495057;\">Stay Duration:</td>\n                                        <td style=\"color: #2c5aa0; font-weight: 500; text-align: right;\">{{ $json['Check-in Date'] }} to {{ $json['Check-out Date'] }}</td>\n                                    </tr>\n                                </table>\n                            </td>\n                        </tr>\n                        <tr>\n                            <td style=\"padding: 12px 0;\">\n                                <table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" width=\"100%\">\n                                    <tr>\n                                        <td style=\"font-weight: 600; color: #495057;\">Guests:</td>\n                                        <td style=\"color: #2c5aa0; font-weight: 500; text-align: right;\">{{ $json['Guest Count'] }}</td>\n                                    </tr>\n                                </table>\n                            </td>\n                        </tr>\n                    </table>\n                </div>\n                \n                <!-- Special Offers Section -->\n                <div style=\"margin: 30px 0;\">\n                    <h2 style=\"font-size: 20px; color: #2c5aa0; margin-bottom: 20px; font-weight: 600;\">\n                        <span style=\"margin-right: 12px; font-size: 24px;\">🎁</span>\n                        Exclusive Offers for Our Valued Guests\n                    </h2>\n                    \n                    <div style=\"background: linear-gradient(135deg, #fff3cd 0%, #fef7e3 100%); background-color: #fff3cd; border-left: 4px solid #ffc107; padding: 20px; margin: 15px 0; border-radius: 8px;\">\n                        <div style=\"font-weight: 600; color: #856404; margin-bottom: 5px;\">🎯 Return Guest Discount</div>\n                        <div style=\"color: #856404;\">Book your next stay and enjoy 15% off with code: WELCOME_BACK</div>\n                    </div>\n                    \n                    <div style=\"background: linear-gradient(135deg, #d1ecf1 0%, #e8f4f7 100%); background-color: #d1ecf1; border-left: 4px solid #17a2b8; padding: 20px; margin: 15px 0; border-radius: 8px;\">\n                        <div style=\"font-weight: 600; color: #0c5460; margin-bottom: 5px;\">📧 Stay Updated</div>\n                        <div style=\"color: #0c5460;\">Follow us on social media for exclusive deals and updates</div>\n                    </div>\n                </div>\n                \n                <!-- Contact Section -->\n                <div style=\"margin: 30px 0;\">\n                    <h2 style=\"font-size: 20px; color: #2c5aa0; margin-bottom: 20px; font-weight: 600;\">\n                        <span style=\"margin-right: 12px; font-size: 24px;\">📞</span>\n                        Stay Connected\n                    </h2>\n                    \n                    <table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" width=\"100%\">\n                        <tr>\n                            <td width=\"50%\" style=\"padding-right: 10px;\">\n                                <div style=\"background: linear-gradient(135deg, #f8f9fa 0%, #ffffff 100%); background-color: #f8f9fa; padding: 20px; border-radius: 8px; text-align: center; border: 2px solid #e9ecef;\">\n                                    <div style=\"font-weight: 600; color: #2c5aa0; margin-bottom: 10px;\">Questions?</div>\n                                    <div style=\"color: #495057; font-weight: 500;\">\n                                        <a href=\"tel:+15551234567\" style=\"color: #2c5aa0; text-decoration: none;\">+1 (555) 123-4567</a>\n                                    </div>\n                                </div>\n                            </td>\n                            <td width=\"50%\" style=\"padding-left: 10px;\">\n                                <div style=\"background: linear-gradient(135deg, #f8f9fa 0%, #ffffff 100%); background-color: #f8f9fa; padding: 20px; border-radius: 8px; text-align: center; border: 2px solid #e9ecef;\">\n                                    <div style=\"font-weight: 600; color: #2c5aa0; margin-bottom: 10px;\">Email Us</div>\n                                    <div style=\"color: #495057; font-weight: 500;\">\n                                        <a href=\"mailto:guest.services@yourhotel.com\" style=\"color: #2c5aa0; text-decoration: none;\">guest.services@yourhotel.com</a>\n                                    </div>\n                                </div>\n                            </td>\n                        </tr>\n                    </table>\n                </div>\n                \n            </td>\n        </tr>\n        \n        <!-- Footer -->\n        <tr>\n            <td style=\"background: #2c5aa0; color: white; padding: 30px 40px; text-align: center;\">\n                <div style=\"font-size: 18px; margin-bottom: 15px;\">Thank you for being our valued guest!</div>\n                <div style=\"opacity: 0.9; font-style: italic;\">\n                    We look forward to welcoming you back soon,<br>\n                    <strong> {{ $('Edit Fields').item.json['Hotel Name'] }}</strong>\n                </div>\n            </td>\n        </tr>\n        \n    </table>\n    \n</body>\n</html>\n",
        "options": {},
        "subject": "= {{ $json['Guest Name'] }}, thank you for staying with  {{ $('Edit Fields').item.json['Hotel Name'] }} ⭐"
      },
      "credentials": {
        "gmailOAuth2": {
          "id": "NaIYTcsDtoNYLBYA",
          "name": "Gmail account"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "a1b1c191-ab75-4b91-821e-c93af3502970",
      "name": "Quotidien à 6h",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        336,
        1520
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "field": "cronExpression",
              "expression": "0 6 * * *"
            }
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "2ad1c6ca-ddc3-4341-a57b-af2cb0b409f2",
      "name": "Note adhésive 2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        336,
        1280
      ],
      "parameters": {
        "color": 6,
        "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 front desk, housekeeping, and management\n\n💼 INCLUDES: Guest details | Room assignments | Housekeeping priorities | Daily statistics"
      },
      "typeVersion": 1
    },
    {
      "id": "a026265f-89b7-4eaf-978e-78da9196bc58",
      "name": "Obtenir réservation hôtelière",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        752,
        640
      ],
      "parameters": {
        "options": {},
        "filtersUI": {
          "values": [
            {
              "lookupColumn": "Welcome Email Sent"
            },
            {
              "lookupColumn": "Write Review Email Sent"
            }
          ]
        },
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1zb-3FQcMOetj4cs1OUOYrpbv-2f3FnQELMPRIyLsNJU/edit#gid=0",
          "cachedResultName": "Reservations"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1zb-3FQcMOetj4cs1OUOYrpbv-2f3FnQELMPRIyLsNJU",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1zb-3FQcMOetj4cs1OUOYrpbv-2f3FnQELMPRIyLsNJU/edit?usp=drivesdk",
          "cachedResultName": "Hotel Bookings"
        },
        "combineFilters": "OR"
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "XruFPA2NpYd9OmBT",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.6
    },
    {
      "id": "4d3de6a5-c629-4441-98ad-72fcc7749d18",
      "name": "Filtrer clients à venir",
      "type": "n8n-nodes-base.filter",
      "position": [
        944,
        640
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "or",
          "conditions": [
            {
              "id": "8dfa9584-8029-48e0-98c7-37c1d5682610",
              "operator": {
                "type": "string",
                "operation": "empty",
                "singleValue": true
              },
              "leftValue": "={{ $json['Welcome Email Sent'] }}",
              "rightValue": ""
            },
            {
              "id": "8b25deed-f37f-4b10-bf77-0dc82ac7c444",
              "operator": {
                "type": "string",
                "operation": "empty",
                "singleValue": true
              },
              "leftValue": "={{ $json['Write Review Email Sent'] }}",
              "rightValue": ""
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "54f73600-b1f4-43e9-8cf1-085c870b2914",
      "name": "Filtrer arrivées du jour",
      "type": "n8n-nodes-base.filter",
      "position": [
        1008,
        1488
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "acd4f2a7-c6a1-4920-8627-481c450d6ff0",
              "operator": {
                "name": "filter.operator.equals",
                "type": "string",
                "operation": "equals"
              },
              "leftValue": "={{ DateTime.fromFormat($json['Check-in Date'], 'M/d/yyyy HH:mm:ss').toFormat('M/d/yyyy') }}\n",
              "rightValue": "={{ DateTime.now().toFormat('M/d/yyyy') }}\n"
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "56671ab0-8308-43be-bba8-9bdb0785876a",
      "name": "Filtrer départs du jour",
      "type": "n8n-nodes-base.filter",
      "position": [
        1008,
        1696
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "47e1f2e5-d620-478e-bd4f-c993c5f4d2e7",
              "operator": {
                "name": "filter.operator.equals",
                "type": "string",
                "operation": "equals"
              },
              "leftValue": "={{ DateTime.fromFormat($json['Check-out Date'], 'M/d/yyyy HH:mm:ss').toFormat('M/d/yyyy') }}",
              "rightValue": "={{ DateTime.now().toFormat('M/d/yyyy') }}"
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "6d4a09b8-e497-4eff-872b-d607502dc134",
      "name": "Ajouter informations",
      "type": "n8n-nodes-base.set",
      "position": [
        512,
        1520
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "0583a748-dcd8-401e-8462-d9cf9920940f",
              "name": "Hotel Name",
              "type": "string",
              "value": "Mr. Wonderful"
            },
            {
              "id": "a61803b1-6de2-4479-85eb-e40a65e12cdf",
              "name": "staff mail a",
              "type": "string",
              "value": "staff@gmail.com"
            }
          ]
        },
        "includeOtherFields": true
      },
      "typeVersion": 3.4
    },
    {
      "id": "f7b35941-581c-4151-bb15-b5819e329bbf",
      "name": "Créer HTML e-mail",
      "type": "n8n-nodes-base.set",
      "position": [
        1280,
        1568
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "a77d772a-a21c-4cf1-be5c-17cdb1e79a06",
              "name": "daily_report",
              "type": "string",
              "value": "=<!DOCTYPE html>\n<html lang=\"en\">\n<head>\n    <meta charset=\"UTF-8\">\n    <meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\n    <title>Daily Hotel Operations Report</title>\n</head>\n<body style=\"font-family: 'Segoe UI', Tahoma, Geneva, Verdana, sans-serif; line-height: 1.6; background-color: #f4f7fa; margin: 0; padding: 20px 0;\">\n    \n    <table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" width=\"100%\" style=\"max-width: 700px; margin: 0 auto; background: white; border-radius: 12px; box-shadow: 0 4px 20px rgba(0,0,0,0.1);\">\n        \n        <!-- Header -->\n        <tr>\n            <td style=\"background: linear-gradient(135deg, #2c5aa0 0%, #1e3a5f 100%); background-color: #2c5aa0; color: white; padding: 30px 40px; text-align: center;\">\n                <h1 style=\"font-size: 26px; margin: 0 0 10px 0; font-weight: 600;\">📅 DAILY OPERATIONS REPORT</h1>\n                <p style=\"font-size: 18px; opacity: 0.9; margin: 0;\">Sunday 27 July 2025</p>\n                <p style=\"font-size: 14px; opacity: 0.8; margin: 5px 0 0 0;\">{{ $('Add Information').item.json['Hotel Name'] }} - Staff Internal Report</p>\n            </td>\n        </tr>\n        \n        <!-- Main Content -->\n        <tr>\n            <td style=\"padding: 30px 40px;\">\n                \n                <!-- Summary Cards -->\n                <div style=\"display: flex; margin-bottom: 30px;\">\n                    <table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" width=\"100%\">\n                        <tr>\n                            <td width=\"50%\" style=\"padding-right: 15px;\">\n                                <div style=\"background: linear-gradient(135deg, #e8f5e8 0%, #f0f8f0 100%); background-color: #e8f5e8; border-left: 5px solid #28a745; padding: 20px; border-radius: 8px; text-align: center;\">\n                                    <div style=\"font-size: 24px; font-weight: bold; color: #155724;\">1</div>\n                                    <div style=\"color: #155724; font-weight: 600;\">🟢 ARRIVALS TODAY</div>\n                                </div>\n                            </td>\n                            <td width=\"50%\" style=\"padding-left: 15px;\">\n                                <div style=\"background: linear-gradient(135deg, #f8d7da 0%, #fde2e4 100%); background-color: #f8d7da; border-left: 5px solid #dc3545; padding: 20px; border-radius: 8px; text-align: center;\">\n                                    <div style=\"font-size: 24px; font-weight: bold; color: #721c24;\">1</div>\n                                    <div style=\"color: #721c24; font-weight: 600;\">🔴 DEPARTURES TODAY</div>\n                                </div>\n                            </td>\n                        </tr>\n                    </table>\n                </div>\n                \n                <!-- Today's Arrivals Section -->\n                <div style=\"margin: 30px 0;\">\n                    <h2 style=\"display: flex; align-items: center; font-size: 22px; color: #28a745; margin-bottom: 20px; font-weight: 600; border-bottom: 2px solid #28a745; padding-bottom: 10px;\">\n                        <span style=\"margin-right: 12px; font-size: 26px;\">🟢</span>\n                        TODAY'S ARRIVALS (1)\n                    </h2>\n                    \n                    <div style=\"background: #f8f9fa; border-radius: 8px; padding: 20px;\">\n                        <div style=\"background: white; margin: 10px 0; padding: 15px 20px; border-radius: 6px; border-left: 4px solid #28a745; box-shadow: 0 2px 4px rgba(0,0,0,0.1);\">\n                                    <table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" width=\"100%\">\n                                        <tr>\n                                            <td style=\"font-weight: 600; color: #2c5aa0; font-size: 16px;\">John Smith</td>\n                                            <td style=\"text-align: right; color: #666; font-weight: 500;\">ID: HTL001</td>\n                                        </tr>\n                                        <tr>\n                                            <td style=\"color: #666; padding-top: 5px;\">2 guests • Standard Double</td>\n                                            <td style=\"text-align: right; color: #28a745; font-weight: 600; padding-top: 5px;\">Check-in: 3:00 PM</td>\n                                        </tr>\n                                    </table>\n                                </div>\n                    </div>\n                </div>\n                \n                <!-- Today's Departures Section -->\n                <div style=\"margin: 30px 0;\">\n                    <h2 style=\"display: flex; align-items: center; font-size: 22px; color: #dc3545; margin-bottom: 20px; font-weight: 600; border-bottom: 2px solid #dc3545; padding-bottom: 10px;\">\n                        <span style=\"margin-right: 12px; font-size: 26px;\">🔴</span>\n                        TODAY'S DEPARTURES (1)\n                    </h2>\n                    \n                    <div style=\"background: #f8f9fa; border-radius: 8px; padding: 20px;\">\n                        <div style=\"background: white; margin: 10px 0; padding: 15px 20px; border-radius: 6px; border-left: 4px solid #dc3545; box-shadow: 0 2px 4px rgba(0,0,0,0.1);\">\n                                    <table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" width=\"100%\">\n                                        <tr>\n                                            <td style=\"font-weight: 600; color: #2c5aa0; font-size: 16px;\">Sarah Johnson</td>\n                                            <td style=\"text-align: right; color: #666; font-weight: 500;\">ID: HTL002</td>\n                                        </tr>\n                                        <tr>\n                                            <td style=\"color: #666; padding-top: 5px;\">4 guests • Suite</td>\n                                            <td style=\"text-align: right; color: #dc3545; font-weight: 600; padding-top: 5px;\">Check-out: 11:00 AM</td>\n                                        </tr>\n                                    </table>\n                                </div>\n                    </div>\n                </div>\n                \n                <!-- Housekeeping Priorities Section -->\n                <div style=\"margin: 30px 0;\">\n                    <h2 style=\"display: flex; align-items: center; font-size: 22px; color: #6f42c1; margin-bottom: 20px; font-weight: 600; border-bottom: 2px solid #6f42c1; padding-bottom: 10px;\">\n                        <span style=\"margin-right: 12px; font-size: 26px;\">🧹</span>\n                        HOUSEKEEPING PRIORITIES\n                    </h2>\n                    \n                    <div style=\"background: linear-gradient(135deg, #f3e8ff 0%, #faf5ff 100%); background-color: #f3e8ff; border-radius: 8px; padding: 20px;\">\n                        <div style=\"background: white; margin: 8px 0; padding: 12px 18px; border-radius: 6px; border-left: 4px solid #6f42c1;\">\n                                    <span style=\"font-weight: 600; color: #6f42c1;\">Suite</span>\n                                    <span style=\"color: #666;\"> - Clean after Sarah Johnson departure (Booking: HTL002)</span>\n                                </div>\n                    </div>\n                </div>\n                \n                <!-- Front Desk Notes Section -->\n                <div style=\"margin: 30px 0;\">\n                    <h2 style=\"display: flex; align-items: center; font-size: 22px; color: #fd7e14; margin-bottom: 20px; font-weight: 600; border-bottom: 2px solid #fd7e14; padding-bottom: 10px;\">\n                        <span style=\"margin-right: 12px; font-size: 26px;\">📋</span>\n                        FRONT DESK NOTES\n                    </h2>\n                    \n                    <div style=\"background: linear-gradient(135deg, #fff3cd 0%, #fefefe 100%); background-color: #fff3cd; border-radius: 8px; padding: 25px;\">\n                        <table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" width=\"100%\">\n                            <tr>\n                                <td style=\"padding: 8px 0; border-bottom: 1px solid #ffeaa7;\">\n                                    <table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" width=\"100%\">\n                                        <tr>\n                                            <td style=\"font-weight: 600; color: #856404;\">Total arrivals expected:</td>\n                                            <td style=\"text-align: right; color: #856404; font-weight: 500;\">1</td>\n                                        </tr>\n                                    </table>\n                                </td>\n                            </tr>\n                            <tr>\n                                <td style=\"padding: 8px 0; border-bottom: 1px solid #ffeaa7;\">\n                                    <table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" width=\"100%\">\n                                        <tr>\n                                            <td style=\"font-weight: 600; color: #856404;\">Total departures to process:</td>\n                                            <td style=\"text-align: right; color: #856404; font-weight: 500;\">1</td>\n                                        </tr>\n                                    </table>\n                                </td>\n                            </tr>\n                            <tr>\n                                <td style=\"padding: 8px 0; border-bottom: 1px solid #ffeaa7;\">\n                                    <table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" width=\"100%\">\n                                        <tr>\n                                            <td style=\"font-weight: 600; color: #856404;\">Peak check-in time:</td>\n                                            <td style=\"text-align: right; color: #856404; font-weight: 500;\">3:00 PM - 6:00 PM</td>\n                                        </tr>\n                                    </table>\n                                </td>\n                            </tr>\n                            <tr>\n                                <td style=\"padding: 8px 0;\">\n                                    <table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" width=\"100%\">\n                                        <tr>\n                                            <td style=\"font-weight: 600; color: #856404;\">Peak check-out time:</td>\n                                            <td style=\"text-align: right; color: #856404; font-weight: 500;\">10:00 AM - 11:00 AM</td>\n                                        </tr>\n                                    </table>\n                                </td>\n                            </tr>\n                        </table>\n                    </div>\n                </div>\n                \n            </td>\n        </tr>\n        \n        <!-- Footer -->\n        <tr>\n            <td style=\"background: #2c5aa0; color: white; padding: 25px 40px; text-align: center;\">\n                <div style=\"font-size: 16px; margin-bottom: 10px;\">🤖 Generated automatically by Hotel Management System</div>\n                <div style=\"opacity: 0.9; font-size: 14px;\">\n                    Report generated at 11:13 PM • Sunday 27 July 2025\n                </div>\n                <div style=\"opacity: 0.8; font-size: 12px; margin-top: 10px;\">\n                    For questions, contact IT Support\n                </div>\n            </td>\n        </tr>\n        \n    </table>\n    \n</body>\n</html>\n"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "af87b761-f185-4b3c-8d2a-6e83739c98c7",
      "name": "Note adhésive 3",
      "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 before check-in)\n⭐ Post-stay review requests (24 hours after checkout)  \n📊 Daily staff reports for arrivals/departures (6 AM daily)\n🔄 Automatic tracking to prevent duplicate communications\n\n🎯 PERFECT FOR: Hotels | B&Bs | Short-term rentals | Guest experience enhancement\n💡 REDUCES: Manual work | Front desk inquiries | Missed follow-ups\n🚀 INCREASES: Guest satisfaction | Online reviews | Operational efficiency\n\n## Who's it for\nHotel managers, property managers, and hospitality businesses wanting to automate guest communications and improve operational efficiency.\n\n## How it works\nThe workflow monitors a Google Sheets reservation database and automatically sends personalized emails at optimal times during the guest journey, while generating daily operational reports for staff.\n\n## How to set up\n1. Replace the Google Sheets ID with your reservation spreadsheet\n2. Update hotel name and contact information in the \"Edit Fields\" nodes\n3. Configure your Gmail credentials for sending emails\n4. Customize email templates with your branding\n5. Set staff email addresses for daily reports\n\n## Requirements\n- Google Sheets with reservation data\n- Gmail account for sending emails\n- n8n instance (self-hosted or cloud)\n\n## How to customize\n- Modify email templates in Gmail nodes\n- Adjust timing in Schedule Trigger nodes\n- Add more data fields in Google Sheets integration\n- Customize report format in \"Create Email HTML\" node\n"
      },
      "typeVersion": 1
    },
    {
      "id": "a7314fef-efc9-4c72-b1b5-b03ac1f7b625",
      "name": "Filtrer e-mails de bienvenue non envoyés",
      "type": "n8n-nodes-base.filter",
      "position": [
        1456,
        608
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "loose"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "c185dcb7-eec6-48c1-b0fb-9662bfdca7b5",
              "operator": {
                "type": "string",
                "operation": "empty",
                "singleValue": true
              },
              "leftValue": "={{ $('Get Hotel Reservation').item.json['Welcome Email Sent'] }}",
              "rightValue": ""
            }
          ]
        },
        "looseTypeValidation": true
      },
      "typeVersion": 2.2
    },
    {
      "id": "84f4af1e-ae12-474b-970b-c72cccaa7e4a",
      "name": "Filtrer demandes d'avis non envoyées",
      "type": "n8n-nodes-base.filter",
      "position": [
        1456,
        832
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "loose"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "c185dcb7-eec6-48c1-b0fb-9662bfdca7b5",
              "operator": {
                "type": "string",
                "operation": "empty",
                "singleValue": true
              },
              "leftValue": "={{ $json['Write Review Email Sent'] }}",
              "rightValue": ""
            }
          ]
        },
        "looseTypeValidation": true
      },
      "typeVersion": 2.2
    },
    {
      "id": "fcc8fcde-b050-41cd-900c-655c222d0fa9",
      "name": "Marquer e-mail de bienvenue comme envoyé",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1952,
        608
      ],
      "parameters": {
        "columns": {
          "value": {
            "Booking ID": "={{ $('Filter Unsent Welcome Emails').item.json['Booking ID'] }}",
            "Welcome Email Date": "={{ DateTime.now().setZone('Asia/Kolkata').toFormat('M/d/yy HH:mm:ss') }}\n",
            "Welcome Email Sent": "yes"
          },
          "schema": [
            {
              "id": "Booking ID",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Booking ID",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Guest Name",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Guest Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Guest Email",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Guest Email",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Check-in Date",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Check-in Date",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Check-out Date",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Check-out Date",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Room Type",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Room Type",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Guest Count",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Guest Count",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Welcome Email Sent",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Welcome Email Sent",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Welcome Email Date",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Welcome Email Date",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "row_number",
              "type": "number",
              "display": true,
              "removed": true,
              "readOnly": true,
              "required": false,
              "displayName": "row_number",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "Booking ID"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "update",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1zb-3FQcMOetj4cs1OUOYrpbv-2f3FnQELMPRIyLsNJU/edit#gid=0",
          "cachedResultName": "Reservations"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1zb-3FQcMOetj4cs1OUOYrpbv-2f3FnQELMPRIyLsNJU",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1zb-3FQcMOetj4cs1OUOYrpbv-2f3FnQELMPRIyLsNJU/edit?usp=drivesdk",
          "cachedResultName": "Hotel Bookings"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "XruFPA2NpYd9OmBT",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.6
    },
    {
      "id": "e868be76-2548-409b-a07f-aecad9c8492d",
      "name": "Marquer e-mail d'avis comme envoyé",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1936,
        848
      ],
      "parameters": {
        "columns": {
          "value": {
            "Booking ID": "={{ $('Get Hotel Reservation').item.json['Booking ID'] }}",
            "Write Review Email Date": "={{ DateTime.now().setZone('Asia/Kolkata').toFormat('M/d/yy HH:mm:ss') }}",
            "Write Review Email Sent": "yes"
          },
          "schema": [
            {
              "id": "Booking ID",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Booking ID",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Guest Name",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Guest Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Guest Email",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Guest Email",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Check-in Date",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Check-in Date",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Check-out Date",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Check-out Date",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Room Type",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Room Type",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Guest Count",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Guest Count",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Welcome Email Sent",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Welcome Email Sent",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Welcome Email Date",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Welcome Email Date",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Write Review Email Sent",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Write Review Email Sent",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Write Review Email Date",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Write Review Email Date",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "row_number",
              "type": "number",
              "display": true,
              "removed": true,
              "readOnly": true,
              "required": false,
              "displayName": "row_number",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "Booking ID"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "update",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1zb-3FQcMOetj4cs1OUOYrpbv-2f3FnQELMPRIyLsNJU/edit#gid=0",
          "cachedResultName": "Reservations"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1zb-3FQcMOetj4cs1OUOYrpbv-2f3FnQELMPRIyLsNJU",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1zb-3FQcMOetj4cs1OUOYrpbv-2f3FnQELMPRIyLsNJU/edit?usp=drivesdk",
          "cachedResultName": "Hotel Bookings"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "XruFPA2NpYd9OmBT",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.6
    },
    {
      "id": "0ca981cf-f1cc-454d-ae86-21a8cd385c0c",
      "name": "Envoyer rapport quotidien au personnel",
      "type": "n8n-nodes-base.gmail",
      "position": [
        1488,
        1568
      ],
      "webhookId": "6e9adac6-1361-470d-89e6-e205dcfe5adc",
      "parameters": {
        "sendTo": "={{ $('Add Information').item.json['staff mail a'] }}",
        "message": "={{ $json.daily_report }}",
        "options": {},
        "subject": "={{ $('Add Information').item.json['Day of month'] }} {{ $('Add Information').item.json.Month }}"
      },
      "credentials": {
        "gmailOAuth2": {
          "id": "NaIYTcsDtoNYLBYA",
          "name": "Gmail account"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "eec36efc-0b64-4c72-9b93-e15d394e9faf",
      "name": "Obtenir toutes les réservations",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        736,
        1520
      ],
      "parameters": {
        "options": {},
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1zb-3FQcMOetj4cs1OUOYrpbv-2f3FnQELMPRIyLsNJU/edit#gid=0",
          "cachedResultName": "Reservations"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1zb-3FQcMOetj4cs1OUOYrpbv-2f3FnQELMPRIyLsNJU",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1zb-3FQcMOetj4cs1OUOYrpbv-2f3FnQELMPRIyLsNJU/edit?usp=drivesdk",
          "cachedResultName": "Hotel Bookings"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "XruFPA2NpYd9OmBT",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.6
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "timezone": "Asia/Kolkata",
    "callerPolicy": "workflowsFromSameOwner",
    "executionOrder": "v1"
  },
  "versionId": "dfc76dc6-5a33-46b3-9af1-689e542ea551",
  "connections": {
    "42dcd64c-0fba-4886-957e-fe6f76ac0171": {
      "main": [
        [
          {
            "node": "a7314fef-efc9-4c72-b1b5-b03ac1f7b625",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "84f4af1e-ae12-474b-970b-c72cccaa7e4a",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "db181591-4b20-4919-acf7-de13edddd5a0": {
      "main": [
        [
          {
            "node": "a026265f-89b7-4eaf-978e-78da9196bc58",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "1e7320e3-3824-4151-833c-77c8565852d8": {
      "main": [
        [
          {
            "node": "e868be76-2548-409b-a07f-aecad9c8492d",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "a1b1c191-ab75-4b91-821e-c93af3502970": {
      "main": [
        [
          {
            "node": "6d4a09b8-e497-4eff-872b-d607502dc134",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "de93fa3f-c28f-4738-95b7-1115f0d2c33e": {
      "main": [
        [
          {
            "node": "fcc8fcde-b050-41cd-900c-655c222d0fa9",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "6d4a09b8-e497-4eff-872b-d607502dc134": {
      "main": [
        [
          {
            "node": "eec36efc-0b64-4c72-9b93-e15d394e9faf",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "c25c0e43-0a84-449a-856f-e0c37d166bc8": {
      "main": [
        [
          {
            "node": "db181591-4b20-4919-acf7-de13edddd5a0",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "f7b35941-581c-4151-bb15-b5819e329bbf": {
      "main": [
        [
          {
            "node": "0ca981cf-f1cc-454d-ae86-21a8cd385c0c",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "eec36efc-0b64-4c72-9b93-e15d394e9faf": {
      "main": [
        [
          {
            "node": "54f73600-b1f4-43e9-8cf1-085c870b2914",
            "type": "main",
            "index": 0
          },
          {
            "node": "56671ab0-8308-43be-bba8-9bdb0785876a",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "4d3de6a5-c629-4441-98ad-72fcc7749d18": {
      "main": [
        [
          {
            "node": "42dcd64c-0fba-4886-957e-fe6f76ac0171",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "a026265f-89b7-4eaf-978e-78da9196bc58": {
      "main": [
        [
          {
            "node": "4d3de6a5-c629-4441-98ad-72fcc7749d18",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "54f73600-b1f4-43e9-8cf1-085c870b2914": {
      "main": [
        [
          {
            "node": "f7b35941-581c-4151-bb15-b5819e329bbf",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "56671ab0-8308-43be-bba8-9bdb0785876a": {
      "main": [
        [
          {
            "node": "f7b35941-581c-4151-bb15-b5819e329bbf",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "a7314fef-efc9-4c72-b1b5-b03ac1f7b625": {
      "main": [
        [
          {
            "node": "de93fa3f-c28f-4738-95b7-1115f0d2c33e",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "84f4af1e-ae12-474b-970b-c72cccaa7e4a": {
      "main": [
        [
          {
            "node": "1e7320e3-3824-4151-833c-77c8565852d8",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}