I'm building a Zapier automation for a self-catering client using Bookster that sends personalised pre-arrival emails/SMS 6 days before guest check-in. Due to Zapier's 30-day delay limit, I'm using Google Sheets as an intermediary to store booking data and trigger reminders.
Current setup: Daily Zap pulls all future calendar events → loops through each booking → filters by date/property → sends reminders
The problem: This approach is generating thousands of tasks monthly because it processes every future booking daily, even though only a fraction need reminders sent.
Specific issues I'm facing:
- Massive task waste - looping through hundreds of bookings daily for just a few actual reminders
- Missing email addresses from OTA bookings (Airbnb/Booking.com) breaking the flow
- Update detection failures when I manually add missing guest emails
What I need help with:
- Strategies to dramatically reduce task count while maintaining reliability
- Alternative architectures that don't require daily processing of all records
- Whether I should switch to Make.com or any other tool for this use case
Has anyone solved similar high-volume, date-sensitive booking workflows more efficiently?