How to automatically update a row in Google Sheets whenever a new booking is upcoming on Cal.com

A playbook always starts with a trigger, which is responsible for detecting changes in your connected applications and responding accordingly.

Add the Cal.com trigger to initiate your playbook's actions whenever a new booking is upcoming on Cal.com. Click "Add trigger" in your playbook and choose "Booking upcoming" from the dropdown menu under Cal.com.

If you still need to connect your Cal.com account to Relay.app yet, a prompt will guide you through the process.

Integrate the Google Sheets automation into your playbook to ensure the prompt update of a row in Google Sheets whenever a new booking is upcoming on Cal.com.

Click the "Add step" button, then locate the "Get row" and "Update row" automation for Google Sheets and input the mandatory and relevant details.

If your Google Sheets account isn't already connected to Relay.app, you will be prompted to complete that connection. Make sure to allow the necessary permissions for Relay.app to sync with your Google Sheets account.

Activating your playbook is the last step in the process. Once you turn it on, it will automatically update a row in Google Sheets whenever a new booking is upcoming on Cal.com without requiring manual intervention.

To activate your playbook, click the toggle button at the header. Before activating, we recommend performing a test run of your playbook to ensure all the steps work seamlessly together.