Sistema de reservas de hoteles
Avanzado
Este es unSocial Mediaflujo de automatización del dominio deautomatización que contiene 22 nodos.Utiliza principalmente nodos como Set, Gmail, Filter, Switch, GoogleSheets. Automatización del viaje del huésped del hotel usando Gmail y Google Sheets
Requisitos previos
- •Cuenta de Google y credenciales de API de Gmail
- •Credenciales de API de Google Sheets
Nodos utilizados (22)
Categoría
Vista previa del flujo de trabajo
Visualización de las conexiones entre nodos, con soporte para zoom y panorámica
Exportar flujo de trabajo
Copie la siguiente configuración JSON en n8n para importar y usar este flujo de trabajo
{
"id": "FgamqYDVNixmK2gV",
"meta": {
"instanceId": "f080fafc9937b6b383f471ad8cc35ad1727032832bd16212f900e0577db46644",
"templateCredsSetupCompleted": true
},
"name": "Hotel Booking System",
"tags": [],
"nodes": [
{
"id": "7befd68e-1976-4e76-a283-f00955b26582",
"name": "Nota Adhesiva",
"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": "Activador Programado",
"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": "Editar Campos",
"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": "Switch",
"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": "Nota Adhesiva1",
"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": "Correo de Bienvenida",
"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": "Escribir Reseña",
"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": "Diariamente a las 6 AM",
"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": "Nota Adhesiva2",
"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": "Obtener Reserva de Hotel",
"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": "Filtrar Huésped Próximo",
"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": "Filtrar Llegadas de Hoy",
"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": "Filtrar Salidas de Hoy",
"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": "Agregar Información",
"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": "Crear Correo HTML",
"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": "Nota Adhesiva3",
"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": "Filtrar Correos de Bienvenida No Enviados",
"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": "Filtrar Solicitudes de Reseña No Enviadas",
"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": "Marcar Correo de Bienvenida como Enviado",
"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": "Marcar Correo de Reseña como Enviado",
"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": "Enviar Reporte Diario al Personal",
"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": "Obtener Todas las Reservas",
"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
}
]
]
}
}
}Preguntas frecuentes
¿Cómo usar este flujo de trabajo?
Copie el código de configuración JSON de arriba, cree un nuevo flujo de trabajo en su instancia de n8n y seleccione "Importar desde JSON", pegue la configuración y luego modifique la configuración de credenciales según sea necesario.
¿En qué escenarios es adecuado este flujo de trabajo?
Avanzado - Redes sociales
¿Es de pago?
Este flujo de trabajo es completamente gratuito, puede importarlo y usarlo directamente. Sin embargo, tenga en cuenta que los servicios de terceros utilizados en el flujo de trabajo (como la API de OpenAI) pueden requerir un pago por su cuenta.
Flujos de trabajo relacionados recomendados
Desarrollo de leads y flujos de correo electrónico
Usar Google Maps, SendGrid e IA para automatizar el desarrollo de leads B2B y el marketing por correo electrónico
If
Set
Code
+
If
Set
Code
141 NodosEzema Kingsley Chibuzo
Generación de leads
Series de anuncios Meta Ads basadas en informes periódicos
✨ Informe de campañas de anuncios Meta Ads por ciclo - Envío automático a través de WhatsApp y correo electrónico
If
Set
Code
+
If
Set
Code
28 NodosAmanda Benks
Marketing
Automatización de campañas de marketing por correo electrónico personalizadas
Automatizar campañas de marketing por correo electrónico personalizado con Google Docs, Hojas de cálculo y SMTP
Set
Wait
Merge
+
Set
Wait
Merge
21 NodosStéphane Heckel
Redes sociales
Envío masivo automatizado de correos con seguimiento y respuesta
Envío masivo automatizado de correos con seguimiento y respuesta de seguimiento
If
Gmail
Switch
+
If
Gmail
Switch
11 NodosOneclick AI Squad
Redes sociales
Sistema automatizado de reactivación de usuarios basado en Supabase, Google Sheets y Gmail
Sistema automatizado de reactivación de usuarios utilizando Supabase, Google Sheets y Gmail
Set
Code
Gmail
+
Set
Code
Gmail
14 Nodosiamvaar
Redes sociales
Mi Flujo 79
Construye un sistema CRM de correo electrónico completo usando Google Sheets y MailerSend
If
Set
Wait
+
If
Set
Wait
34 NodosNima Salimi
Redes sociales
Información del flujo de trabajo
Nivel de dificultad
Avanzado
Número de nodos22
Categoría1
Tipos de nodos7
Descripción de la dificultad
Autor
Gaurav
@ramseEnlaces externos
Ver en n8n.io →
Compartir este flujo de trabajo