I have a Google spreadsheet where new appointments from Acuity populate a new row. If someone reschedules, I want to be able to update the appointment date in the existing spreadsheet row. However, the data pulled from Acuity only includes the rescheduled appointment date, not the original.
How do I look up the old appointment to change the date? People may schedule multiple appointments, so I can’t use the email as the sole lookup.
Ex: Joe schedules 3 appointments - Jan 1, Jan 2, and Jan 3. He later reschedules the Jan 1 appointment to Jan 4 instead. The rescheduled appointment trigger only shows the date he rescheduled to (Jan 4), not the original appointment date (Jan 1). How do I get the zap to look up the Jan 1 row in Google Sheets?