The workflow runs on a schedule, pulls reservation rows from a Google Sheet, and filters for guests arriving in the next two days who have not received a welcome note. It builds a personalized Gmail message, sends it, and updates the sheet to prevent duplicates. A similar block watches for guests who checked out the previous day, sends a review request and a discount offer, then marks the row. Every morning a concise arrivals and departures report is generated and emailed to front desk and housekeeping. The design respects Gmail daily send limits by pausing on quota errors, retries failed sends, and logs each step for quick troubleshooting.