Update rows in a Google Sheets spreadsheet when the status of OnceHub bookings changes

First, we need to connect ScheduleOnce and Google Sheets to Zapier.

• 

  Create Zapier account.

  Create Zapier account if you don't have one.

• 

  Connect ScheduleOnce to Zapier.

  Give Zapier access to your ScheduleOnce account, using ScheduleOnce credentials.

• 

  Connect Google Sheets to Zapier.

  Give Zapier access to your Google Sheets account, using Google Sheets credentials.

Next, we need to create a workflow automation scenario using graphical no-code web interface of Zapier.

• 

  Set up a Trigger action for ScheduleOnce

  Choose the following trigger: Booking Lifecycle Event (Triggers when a booking status is changed to one of the following: Scheduled, Rescheduled, Canceled, Completed, or No-show.).

• 

  Then set up an Action for Google Sheets

  Choose this action: Update Spreadsheet Row (Update a row in a specific spreadsheet.).

Finally, we need to test this automation and publish it.

• 

  Customize data flow

  Configure the data that is exchanged between ScheduleOnce and Google Sheets.

• 

  Test the workflow and turn it on for production use

  Test your scenario and publish to production. Now you have an automatic workflow, that will Update rows in a Google Sheets spreadsheet when the status of OnceHub bookings changes!