{"id":4447,"date":"2025-05-04T08:47:07","date_gmt":"2025-05-04T08:47:07","guid":{"rendered":"https:\/\/lemondit.com\/?p=4447"},"modified":"2025-05-12T15:10:43","modified_gmt":"2025-05-12T15:10:43","slug":"tour-booking-automation-external-providers","status":"publish","type":"post","link":"https:\/\/lemondit.com\/en\/2025\/05\/04\/tour-booking-automation-external-providers\/","title":{"rendered":"From E-mails to Full Control: How We Automated Civitatis and Guruwalk Bookings Without an API"},"content":{"rendered":"\n<h3 class=\"wp-block-heading\">The Daily Pain of Modern Tour Operators<\/h3>\n\n\n\n<p>If you manage tourism activities, you know what it&#8217;s like to sell on Civitatis, Guruwalk, or any other marketplace that doesn&#8217;t offer an API:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Dozens of daily emails with bookings and cancellations.<\/li>\n\n\n\n<li>Capacities that change by the minute, leading to overbooking or empty seats.<\/li>\n\n\n\n<li>Spreadsheets to reconcile commissions, guide and reseller payments.<\/li>\n\n\n\n<li>Repetitive tasks, risk of error, and time wasted that you could invest in scaling your business.<\/li>\n<\/ul>\n\n\n\n<p>This article explains how we solved that problem for an agency operating in 14 cities by building a custom platform that not only centralizes their operations but turns emails into automated actions. If you&#8217;re a <strong>product manager, operations director, or founder of a tourism company<\/strong>, this is for you.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">The Challenge We Accepted<\/h3>\n\n\n\n<p>Our client needed a solution that:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Centralized inventory, bookings, payments, commissions, reviews, and affiliate systems.<\/li>\n\n\n\n<li>Served multiple subsidiaries under different brands (a <strong>multitenant<\/strong> model with <em>skins<\/em>).<\/li>\n\n\n\n<li>Eliminated the manual burden of integrating bookings that arrive by email from external agents.<\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\">The Platform: A 360\u00b0 View<\/h3>\n\n\n\n<p>Here are some of the implemented modules:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Multitenant with customized skins<\/strong>: one codebase, multiple brands, colors, and business rules.<\/li>\n\n\n\n<li><strong>Catalog and availability<\/strong>: dynamic pricing, quotas, language\/hour-based variations.<\/li>\n\n\n\n<li><strong>Booking engine:<\/strong> omnichannel B2B and B2C flow, secure payments, automatic vouchers.<\/li>\n\n\n\n<li><strong>Planning:<\/strong> guide assignment and customer distribution across tours.<\/li>\n\n\n\n<li><strong>Commissions and settlements:<\/strong> real-time calculations for affiliates, guides, and resellers.<\/li>\n\n\n\n<li><strong>Self-invoicing:<\/strong> automated billing system with automatic payments and collections for guides, providers, etc.<\/li>\n\n\n\n<li><strong>Reviews and reputation:<\/strong> verified review system connected to CRM.<\/li>\n<\/ul>\n\n\n\n<p>Each company, provider, affiliate, and guide logs in with their own role; the <strong>tenant<\/strong> layer applies the corporate branding, adjusting colors, logos, domains, and business rules without duplicating code.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"683\" src=\"https:\/\/lemondit.com\/wp-content\/uploads\/2025\/05\/booking-automation-without-api-1024x683.png\" alt=\"Booking automation without api\" class=\"wp-image-4452\" srcset=\"https:\/\/lemondit.com\/wp-content\/uploads\/2025\/05\/booking-automation-without-api-1024x683.png 1024w, https:\/\/lemondit.com\/wp-content\/uploads\/2025\/05\/booking-automation-without-api-300x200.png 300w, https:\/\/lemondit.com\/wp-content\/uploads\/2025\/05\/booking-automation-without-api-768x512.png 768w, https:\/\/lemondit.com\/wp-content\/uploads\/2025\/05\/booking-automation-without-api.png 1536w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Our Secret Weapon: Reading Emails Like APIs<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\">1. The Problem<\/h4>\n\n\n\n<p>Marketplaces like Civitatis or Guruwalk don\u2019t offer technical integration. They only send emails like this:<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>&#8220;Booking confirmed: Free Tour Madrid \u2013 May 3, 10:00 AM, 4 people, Spanish.&#8221;<\/p>\n<\/blockquote>\n\n\n\n<p>No webhooks, no endpoints. The result: desynchronized inventory, last-minute guide assignments, miscalculated commissions, and lack of traceability.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">2. Our End-to-End Solution<\/h4>\n\n\n\n<p><strong>Secure email connector<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>OAuth\/IMAP; no plain credential storage.<\/li>\n\n\n\n<li>Sender and subject filters with &lt;\u202f30s latency.<\/li>\n<\/ul>\n\n\n\n<p><strong>Lightweight AI engine<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Multilingual transformers trained on 5,000+ email templates.<\/li>\n\n\n\n<li>Extracts: date, time, number of people, language, city.<\/li>\n\n\n\n<li>Cancellation detection through semantic classification.<\/li>\n<\/ul>\n\n\n\n<p><strong>Smart tour matching<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Similarity algorithm between subject and internal catalog (fuzzy + hidden IDs).<\/li>\n\n\n\n<li>Tolerant of different commercial names: \u201cFree Tour Centro\u201d \u2194 \u201cWalking Tour Old Town.\u201d<\/li>\n<\/ul>\n\n\n\n<p><strong>Event orchestration<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Inserts the booking, updates capacity, recalculates commissions, and notifies the guide \u2014 all within seconds.<\/li>\n\n\n\n<li>If a cancellation is detected, it reverses the assignment, adjusts the payout, and frees up the spot.<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">3. Real Impact<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Manual back-office tasks went from 8\u202fh\/week to 1.5\u202fh\/week.<\/li>\n\n\n\n<li>Overbooking dropped from 3% to 0.2% of bookings.<\/li>\n\n\n\n<li>New tour time-to-market reduced from 5 days to 1 day.<\/li>\n\n\n\n<li>Project ROI achieved in under 6 months.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"683\" src=\"https:\/\/lemondit.com\/wp-content\/uploads\/2025\/05\/tour-booking-integration-crm-1024x683.jpg\" alt=\"Tour booking integration crm\" class=\"wp-image-4454\" srcset=\"https:\/\/lemondit.com\/wp-content\/uploads\/2025\/05\/tour-booking-integration-crm-1024x683.jpg 1024w, https:\/\/lemondit.com\/wp-content\/uploads\/2025\/05\/tour-booking-integration-crm-300x200.jpg 300w, https:\/\/lemondit.com\/wp-content\/uploads\/2025\/05\/tour-booking-integration-crm-768x512.jpg 768w, https:\/\/lemondit.com\/wp-content\/uploads\/2025\/05\/tour-booking-integration-crm.jpg 1536w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Lessons Learned and Next Steps<\/h3>\n\n\n\n<p><strong>Email remains the universal API.<\/strong> With well-tuned AI and rules, any channel can be automated.<\/p>\n\n\n\n<p><strong>Same principles, different verticals.<\/strong> We\u2019re already piloting this logic for attractions, transfers, and rentals.<\/p>\n\n\n\n<p><strong>Roadmap 2025:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Automatic post-tour review capture.<\/li>\n\n\n\n<li>Demand prediction for dynamic pricing.<\/li>\n\n\n\n<li>Generative AI to suggest upselling to guides and resellers.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Does This Problem Sound Familiar?<\/h3>\n\n\n\n<p>If you&#8217;re a <strong>director of operations, product manager, or founder<\/strong> using sales channels that \u201cjust\u201d send emails, we can help you turn them into a fully synchronized, error-free flow.<\/p>\n\n\n\n<p><em>Ready to go from copy-paste to scalable growth?<\/em> <strong>Contact us<\/strong> and turn your inbox into an opportunity engine.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>We helped a multi-city tour operator centralize their bookings by turning confirmation emails from platforms like Civitatis and Guruwalk into real-time, API-free integrations\u2014powered by AI. Discover how we eliminated manual tasks and unlocked scalable growth.<\/p>\n","protected":false},"author":1,"featured_media":4450,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[83,66,97,98],"tags":[87,100,99,88],"class_list":["post-4447","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-integracion-de-sistemas","category-process-automation","category-success-stories","category-system-integration","tag-artificial-intelligence-ai","tag-aws-en","tag-java-en","tag-software-development"],"acf":[],"_links":{"self":[{"href":"https:\/\/lemondit.com\/en\/wp-json\/wp\/v2\/posts\/4447","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/lemondit.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/lemondit.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/lemondit.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/lemondit.com\/en\/wp-json\/wp\/v2\/comments?post=4447"}],"version-history":[{"count":2,"href":"https:\/\/lemondit.com\/en\/wp-json\/wp\/v2\/posts\/4447\/revisions"}],"predecessor-version":[{"id":4471,"href":"https:\/\/lemondit.com\/en\/wp-json\/wp\/v2\/posts\/4447\/revisions\/4471"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/lemondit.com\/en\/wp-json\/wp\/v2\/media\/4450"}],"wp:attachment":[{"href":"https:\/\/lemondit.com\/en\/wp-json\/wp\/v2\/media?parent=4447"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/lemondit.com\/en\/wp-json\/wp\/v2\/categories?post=4447"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/lemondit.com\/en\/wp-json\/wp\/v2\/tags?post=4447"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}