Guide

How to automatically update Google Calendar events with new Google Sheets rows

Are you tired of manually updating your Google Calendar whenever a row is added to your Google Sheet? This tedious task can be time-consuming and prone to human error. But imagine if you could streamline your scheduling process and elevate your data management game with a more automated and efficient solution. With Relay.app's seamless integration, you can say goodbye to the tiresome task of manual updates and orchestrate a symphony of efficiency and organization. Every addition to your Google Sheet is not just recorded but celebrated with precision and simplicity, thanks to automated workflows. Picture the ease of having every addition to your spreadsheet automatically reflected in your calendar, ensuring that your schedule remains up-to-date without missing a beat. In this guide, we'll show you how to set this integration up in four easy steps. So, get ready for the Relay.app revolution and streamline your scheduling process with automated workflows that simplify your workflow and save you time.
Google Calendar logoGoogle Sheets logo
1

Create your Relay.app playbook

To start coordinating between Google Sheets and Google Calendar 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 Google Calendar events with new Google Sheets rows" and choose a relevant emoji 🗓, to help you quickly identify it.

2

Set the Google Sheets trigger as “New row added”

Add the Google Sheets trigger to initiate your playbook's actions before adding rows.

To do this, click "Add trigger" in your playbook. Select the "New row added" trigger option from the dropdown menu under Google Sheets. It will enable your playbook to identify newly added rows and trigger necessary actions automatically.

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

3

Add the “Update event” step in Google Calendar

Integrate the Google Calendar automation into your playbook to ensure prompt updates on events.

To add a step to your playbook, select "Add Step" and look for the "Get event" automation. Then, choose the calendar that you want to work with. Once you've chosen a calendar, you must select an identifier in the "Add filter" from your calendar data to match the Google Sheet data. In this example, the identifier is "Title".

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

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

4

Activate your playbook

Activating your playbook is the last step. Once you turn it on, the playbook automatically updates Google Calendar events with new Google Sheets rows 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