In this how-to guide

How to automatically create Google Calendar events from new Google Sheet rows
1. Set the Google Sheets trigger as “New row added”
2. Add the “Create event” step in Google Calendar
3. Activate your playbook
Learn more about integrating with Google Calendar and Google Sheets
Related blog posts
More how-to guides featuring Google Calendar and Google Sheets

Homearrow_forwardIntegrationsarrow_forwardGoogle Calendar Integrationsarrow_forwardGoogle Calendar + Google Sheets Integrationsarrow_forward

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

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

Relay.app is an automation tool that lets you automate actions across Google Calendar, Google Sheets, and many other apps. In this guide, we'll show you how to use Relay.app to automatically run the Google Calendar “Create event” action for each Google Sheets “Row added” event.

Try it in Relay.app

Google Sheets > Google Calendar

Trigger

Last triggered

Row added

Create event

1

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.

2

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.

3

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.

Learn more about

See all appsarrow_forward

Google Calendar

More information

Google Sheets

More information

See all blog posts ➔

Start multiple Playbook runs at once with Batch Triggers

Batch riggers in Relay.app let you start multiple runs at once for the same Playbook. For example, you may use batch triggers to set off mail merge campaigns, or kick off a playbook on a weekly periodic schedule that checks in with the Account Executives for all stale Deals in sales pipeline in HubSpot.

Thijs van As

The Best Form Automation Software in 2024

Looking to streamline your workflow and reduce your workload? Form automation software transforms tedious manual processes into streamlined, automatic workflows, saving time and reducing errors

How to Automate Calendly (3 Easy Methods)

In this article we break down the three main methods of automating Calendly: workflows, native integrations, and through third-party software like Relay.app.

How to Automate Google Calendar in 2024

Run your work-life on autopilot with these Google Calendar automations.

How to Automate Coda

This article covers everything you need to know about Coda automation—from setting them up natively to buying "packs" or connecting with a third-party workflow tool like Relay.app.

14 Ways to Automate Google Sheets

An automated Google Sheet can often replace multiple business processes and tools. Here's a guide—and a bunch of examples—to show that sometimes a simple spreadsheet is all you need.

Jacob Bank

How to Use Zapier with Google Sheets

Wondering how to connect your Google Sheet with Zapier? You've come to the right place.

Jacob Bank

How to Build a Custom CRM in Google Sheets

Avoid complex solutions and build your own simple, automated CRM in Google Sheets.

Jacob Bank

More how-to guides featuring Google Calendar and Google Sheets

See all how-to guides ➔

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.

Automatically add guests to a Google Calendar meeting from new Google Sheet rows

Are you tired of the tedious and time-consuming task of manually adding guests to your Google Calendar every time you add a new row to Google Sheets? Let's face it - it's not just dull but can also lead to errors, missed appointments, and scheduling conflicts. But don't worry, we have great news for you! With Relay.app's seamless integration, you can finally say goodbye to the hassle of manual data entry and hello to effortless scheduling and communication. Relay.app's automated workflows will ensure that every guest added to a Google Sheets row is automatically incorporated into your Google Calendar. You won't have to worry about typos, missed entries, or incorrect data input anymore. Plus, you'll save valuable time and ensure you never miss an appointment again. In this guide, we'll show you how to set up this integration in four easy steps. Get ready to streamline your scheduling process and experience the power of automation with Relay.app!

What will you automate?

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

Try Relay.app for free

Background image