Automated hotel communication workflow for tourism operations
Turn multi-hotel pickup documents into organized, hotel-specific communications with minimal manual work.
Overview
Pickup Sender is a workflow automation tool built around a real tourism operations https://github.com/efeozanakay/Pickuptime-senderprocess.
The application reads a multi-page pickup PDF, identifies tour operators and hotels, separates the document into hotel-specific PDFs, matches each hotel with its configured email recipients, and prepares the documents for automated delivery through Microsoft Outlook.
Instead of manually separating files, finding hotel contacts, creating attachments, and sending dozens of individual emails, the workflow is handled from a single interface.
Features
Upload and process multi-page pickup PDFs
Detect tour operators and hotel records
Generate hotel-specific PDF documents
Match hotels with stored email recipients
Detect missing hotel contact information
Add and save missing recipients directly from the workflow
Prepare individualized hotel emails
Send documents through Microsoft Outlook
Track delivery progress and failures
Support test and live delivery modes
Workflow
Upload the pickup PDF.
Detect operators and hotel sections.
Generate individual hotel PDFs.
Match hotels with their email recipients.
Flag missing contact information for correction.
Prepare hotel-specific messages and attachments.
Send through Microsoft Outlook.
Review delivery status and failures.
Operational Result
In a production-scale run, the workflow processed:
77 hotels
77 hotel-specific PDF documents
250 matched email addresses
77 successful deliveries
0 failed deliveries
Tech Stack
Application
Python
Streamlit
Document Processing
PDF parsing and generation
CSV / Excel contact data
Automated hotel matching
Communication
Microsoft Outlook desktop automation
Dynamic recipients and attachments
Test and live delivery modes
Problem
A single pickup operation can involve dozens of hotels. Each hotel needs to receive only the pages relevant to its guests.
Handling this manually requires separating a large PDF, identifying each hotel, finding the correct recipients, preparing individual emails, attaching the correct document, and tracking whether every message was sent.
At scale, this becomes repetitive, time-consuming, and prone to human error.
Solution
Pickup Sender converts that process into a structured workflow.
The operator uploads the source document once. The system handles document separation and recipient matching, highlights anything that requires human attention, and prepares the resulting communications for delivery.
The goal is not to remove operational oversight, but to automate the repetitive work around it.
Case Study Context
Pickup Sender was designed around an actual recurring tourism-operations workflow rather than as a demonstration project.
It shows how a relatively focused internal tool can remove a large amount of repetitive administrative work without requiring a complex enterprise system.
Author
Efe Akay — AI Automation & Digital Product Builder