Add new tour bookings to trip info sheet
Add new tour bookings to trip info sheet
Your bookings lack consistent date/time details, leaving guides without clear pickup times. The sheet is populated with guest, date, and time so operations can staff tours ahead of departure.
Overview
Booking timestamps often arrive in different formats and leave dispatch guessing on pickup times, which causes last‑minute scrambling. This flow captures each booking, parses the date and time, and writes them into a single trip sheet so coordinators can staff and prepare reliably the same day.