Productivity

Create calendar events from Google Sheets data automatically

5 nodes 129 94 Automatic trigger
Download

Workflow Description

This automation monitors a Google Sheets spreadsheet and creates Google Calendar events when new rows are added, eliminating manual entry and synchronizing scheduling across your workspace data sources.

How it works

  1. 1.Monitor the spreadsheet for new rows containing event information
  2. 2.Extract event details such as title, date, time, and description from sheet columns
  3. 3.Create corresponding events in Google Calendar with full details

Use cases

  • Schedule team meetings and sync them with a centralized spreadsheet
  • Convert project deadlines and milestones into calendar events automatically
  • Manage event registrations and scheduling from a shared data table

Requirements

  • Edit access to a Google Sheets document with event data
  • Active Google Calendar account with proper authorization for event creation

Service Value

Ready-made workflow template for automation delivery and service execution.

Apps Used

Google Sheets Google Calendar

Details

Trigger Automatic trigger
Nodes 5
Apps 2
Views 129
Downloads 94

How to Use

  1. 1.Click "Download Template"
  2. 2.Open your n8n dashboard
  3. 3.Go to Workflows > Import from File
  4. 4.Select downloaded file and configure credentials

Nodes Used (5)

Sticky Note

Sticky Note

#1

Sticky Note1

Sticky Note

#2

Event Date Formatter

Code

#3

New Event Entry Listener

Google Sheets Trigger

#4

Google Calendar Event Creator

Google Calendar

#5