Blind Booking City Trip

Streamlined email management and data extraction for Blookery, significantly reducing manual workloads for the backend team and enhancing operational efficiency. Enhanced the user experience with a custom payment method for upselling manual transactions.

Collaboration
6 months
Service
Email automation, Payment and AI integration, Code Refactor
Blookery: Blind Booking City Trip

About Blookery

Blookery, a German travel platform launched in 2016, specializes in blind booking for city trips primarily across Europe. It offers a unique travel experience by only revealing customers' destinations shortly before departure. Travelers can specify their preferences, including dates, budget, and type of destination, while the exact location remains a thrilling mystery until a few days before they leave. Blookery provides both flight and hotel packages, as well as hotel-only stays, catering to adventurous travelers seeking curated and spontaneous experiences.

Technology Stack

React

Services Provided

  • •Email Automation
  • •AI-driven Email Data Extraction
  • •Third-party Payment Integration
  • •Code Refactoring

About Project

Blookery's CEO aimed to boost backend operational efficiency by automating email management, including auto-labeling and data extraction from booking emails for seamless CRM integration. Additionally, the project required implementing a payment method for custom client discounts, enhancing sales opportunities.

The Approach

Tackling the challenging requirements necessitated a deep understanding of the Gmail email API for automation and data extraction. Email auto-labeling based on booking IDs was implemented using database queries and Gmail API. The varying email content and language (German, with DB data in English) posed significant challenges, which were met with an LLM-based approach for precise labeling and data extraction.

Custom payment links were crafted using the Ayden payment method, allowing admins to create one-time payment links for clients. This integration included creating new sections in both the app frontend and the admin panel.

The existing project required updates to deprecated libraries, necessitating a code refactor to align with the latest versions and ensure efficiency and stability.

My Delivery Process

Project Setup and Auto-Labeling Emails

Initial setup included a detailed briefing with the CTO to understand project nuances. The objective was to auto-label new emails based on booking IDs extracted from email subjects.

1
Initial call with CTO for project briefing
2
Extract booking IDs from email subjects using Gmail API
3
Cross-verify booking IDs with email content and DB data
4
Auto-label emails with booking IDs

Data Extraction from the Email Body

The diverse content and language of the emails made data extraction complex, addressed using an LLM-based approach.

1
Analyze the structure and content of email bodies
2
Deploy an LLM-based method to extract data
3
Verify extracted data with DB records
4
Upload data to CRM

Third-Party Payment Integration

Creating a custom payment page involved adding functionalities to both the app frontend and the admin panel, using Ayden as the payment gateway.

1
Study the Ayden payment gateway API
2
Develop a new payment page on the app frontend
3
Implement a new admin panel section to generate payment links
4
Test the payment gateway for seamless transactions

Results

75% reduction in manual effort

Frees up backend team for strategic focus

60% boost in operational efficiency

Streamlined processes via automation

15% increase in upsells

Custom payment setup drives additional sales

Seamless CRM integration

Accurate data extraction and labeling