Guide

How to automatically create Google Calendar events from new Google Sheet rows

Do you ever spend too much time manually creating Google Calendar events after adding new rows to your Google Sheets? It can be a real hassle, not to mention the possibility of human error and the confusion that arises when multiple team members are involved. But don't worry; Relay.app is here to help! Our integration makes it easy to sync your schedule with your spreadsheet data. Every time you add a new row to your Google Sheets, Relay.app will automatically generate a corresponding event in your Google Calendar. No more juggling between the two platforms! It's a streamlined process that saves you time and ensures accuracy. Follow these four easy steps to set up this integration. Say goodbye to the headaches and hello to a more efficient way of working. Let's get started with Relay.app!
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 "Create Google Calendar events from 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 “Create event” step in Google Calendar

Integrate the Google Calendar automation to instantly create events.

Select "Add Step" and then find the "Create event" automation for Google Calendar. Enter all the required details, including the Title of the event and Description.

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

4

Activate your playbook

Activating your playbook is the last step. Once you turn it on, the playbook automatically creates Google Calendar events from 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