Guide

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

Do you find it challenging to update Google Sheets for rescheduled Calendly events? Doing it manually can be time-consuming and requires constant monitoring of Calendly, which can be overwhelming. Moreover, it can lead to discrepancies and inaccuracies in the scheduling system. Keeping track of multiple rescheduled events can be a hassle and might result in missed updates. But don't worry, there's an easy solution to all these issues: Relay.app. With Relay.app's seamless integration, syncing every rescheduled Calendly event with a specific row in your Google Sheets becomes a breeze. This means you no longer have to update your spreadsheet manually, risking missed scheduling changes. Every rescheduled event is reflected in its designated row, ensuring your data remains accurate and up-to-date. With Relay.app, managing your schedule becomes easy and efficient. Are you ready to simplify scheduling changes? Follow these four steps to set up this integration effortlessly. Let's get started!
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 certain 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 "Update rows in Google Sheets whenever a Calendly event is rescheduled" and choose a relevant emoji 🗓, to help you quickly identify it.

2

Set the Calendly trigger as “Event rescheduled”

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

To do this, click "Add trigger" in your playbook. Select the "Event rescheduled" trigger option from the dropdown menu under Calendly. It will enable your playbook to identify newly rescheduled 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 “Update row” step in Google Sheets

Integrate the Google Sheets automation into your playbook to ensure prompt updates about rescheduled Calendly events.

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 Start 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.

4

Activate your playbook

Activating your playbook is the last step. Once you turn it on, the playbook automatically updates rows in Google Sheets whenever a Calendly event is rescheduled 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