Guide

How to automatically track canceled Calendly events into a Google Sheets document

Do you ever feel like manually tracking canceled events on Calendly is a never-ending and error-prone task? We understand how frustrating it can be to keep up with cancellations when you have many other things to focus on. That's why we have some great news for you! Relay.app can help you simplify this process. With our seamless automation, canceled Calendly events are automatically logged into a Google Sheets document, ensuring that your records are always accurate and well-organized without any manual effort. We know how important it is to have reliable records, and we want to ensure you can devote more time to the things that matter most to you. Manually tracking canceled Calendly events can be inefficient, unreliable, and time-consuming, and we want to help you overcome these challenges. This guide will show you how to set up this integration in four easy steps. Trust us, you will love how effortless it is!
Calendly logoGoogle Sheets logo
1

Create your Relay.app playbook

To start coordinating between Calendly and Google Sheets for your workflow, you must set up specific steps.

Firstly, sign up for Relay.app and visit your dashboard. Click the "New playbook" button to start creating a playbook.

Give your playbook a unique name like "Track canceled Calendly events into a Google Sheets document," and choose a relevant emoji 🗓 to help you quickly identify it.

2

Set the Calendly trigger as “Event canceled”

Add the Calendly trigger to initiate your playbook's actions before canceling an event.

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.app, a prompt will guide you through the connection process.

3

Add the “Add row to sheet” step in Google Sheets

Integrate the Google Sheets automation to instantly track Calendly events.

Select "Add Step" and then find the "Add row to sheet" automation for Google Sheets. Enter all the required details, including the Cancelation date, End date/time, Event type, Guest, ID of event in synced, Invitee email, Invitee first name, Invitee last name, Invitee name, Invitee time zone, Name, Organizer email, Organizer name, Organizer time zone, and Start date.

If you still need to connect your Google Sheets account to Relay.app, you will be prompted to complete that connection. Ensure that you allow the necessary permissions for Relay.app to add a row to a sheet through your Google Sheets account.

4

Activate your playbook

Activating your playbook is the last step. Once you turn it on, the playbook automatically tracks canceled Calendly events into Google Sheets without manual intervention.

To enable your playbook, click the toggle button located in the header. It is advisable to perform a test run of your playbook beforehand to ensure all steps work seamlessly together.

Get started with Relay.app

Sign up now and get started with your playbook today