- 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
How to automatically create Google Calendar events from new Google Sheet rows
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.
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.
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.