Automation Systems
Airbnb Invoicing & Payment Automation - Zapier, Guesty & Stripe
Built an automation system connecting Guesty, Stripe, Google Sheets, and Slack using multi-step Zapier workflows for real-time invoicing and payment synchronization.
Zapier Automation Specialist
Business summary
- Automated invoicing and payment tracking across hospitality operations.
- Eliminated manual reconciliation between booking, billing, and accounting systems.
- Improved payment visibility and reduced missed transactions.
- Added structured error handling across multi-system workflows.
What I built
Designed multi-step Zapier workflows that process Guesty booking events into structured Google Sheets invoices, normalize line items and totals, and sync Stripe payment events into Slack for real-time financial visibility. Implemented formatting layers using Formatter by Zapier to ensure consistent currency, date, and numerical data across systems.
Reduced manual accounting work and improved real-time visibility of bookings and payments.
Architecture
A simple operating path with explicit ownership.
01Guesty booking event ingestion
02Zapier multi-step workflow engine
03Google Sheets invoice generation layer
04Stripe payment event listener
05Slack notification pipeline
06Formatter normalization layer
Challenges
- Cross-platform data consistency (Guesty ↔ Stripe ↔ Sheets)
- Handling multi-account Stripe event streams
- Ensuring idempotent invoice creation
- Edge-case handling in booking modifications and refunds
Results
- Reduced manual invoice processing
- Improved payment tracking visibility
- Fewer missed or duplicated transactions
- Faster financial reconciliation workflow
Tech Stack
Zapier
Guesty
Stripe
Google Sheets
Slack
Formatter by Zapier
Multi-Step Zaps
Payment Automation
Invoicing Systems
Hospitality Operations
Gallery
