How to automatically update rows in Google Sheets whenever a Calendly event is cancelled

Relay.app is an automation tool that lets you automate actions across Calendly, Google Sheets, and many other apps. In this guide, we'll show you how to use Relay.app to automatically run the Google SheetsUpdate row” action for each CalendlyEvent cancelled” event.
Calendly logoCalendly > Google Sheets
Trigger
Last triggered
Calendly logoEvent cancelled
Google Sheets logoUpdate row
1

Set the Calendly trigger as “Event cancelled”

Add the Calendly trigger to initiate your playbook's actions whenever an event is canceled.

To do this, click "Add trigger" in your playbook. Select the "Event canceled" trigger option from the dropdown menu under Calendly. It will enable your playbook to identify newly canceled events and trigger necessary actions automatically.

If you have yet to connect your Calendly account to Relay, a prompt will guide you through the connection process.

2

Add the “Update row” step in Google Sheets

Integrate the Google Sheets automation into your playbook to ensure prompt updates for canceled events in a particular row.

To add a step to your playbook, select "Add Step" and look for the "Get row" automation. Then, choose the database and sheet you want to work with; for example, let's say you want to work with the "Events" table. Once you've chosen the database and sheet, you must select an identifier in the "Add filter" from your sheet data to match the Calendly data. In this example, the identifier is "Event type".

Afterward, add another step to your playbook by selecting "Update row." Next, click on relevant fields that you want to update and fill in the necessary details such as cancellation date, and Guests.

If you still need to connect your Google Sheets account to Relay.app, you will be prompted to complete that connection. Make sure to allow the necessary permissions for Relay.app to update rows through your Google Sheets account.

3

Activate your playbook

Activating your playbook is the final step. Once you switch it on, the playbook will automatically update the rows in Google Sheets when a Calendly event is canceled without you having to do it manually.

To enable your playbook, click the toggle button in the header. Performing a test run of your playbook beforehand is recommended to ensure all the steps work together smoothly.

See all blog posts ➔

More how-to guides featuring Calendly and Google Sheets

See all how-to guides ➔

What will you automate?

Sign up and get started with your first Relay.app playbook today.
Background image