Pickup Sender: Automated Hotel Communication Workflow by EFE OZAN AKAYPickup Sender: Automated Hotel Communication Workflow by EFE OZAN AKAY

Pickup Sender: Automated Hotel Communication Workflow

EFE OZAN AKAY

EFE OZAN AKAY

Pickup Sender

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
https://github.com/efeozanakay/Pickuptime-sender
Like this project

Posted Aug 14, 2026

Built a tool that turns pickup PDFs into hotel-specific documents, matches recipients, and automates email delivery through Microsoft Outlook.