Automate Google Calendar Event Creation from Google Sheets

Name: Automate Google Calendar Event Creation from Google Sheets
Rating: 5.0 (1 reviews)
Author: Free N8N

Beginner

0 nodes connected

detail.loadingPreview

Free N8N Temples

17 views

0 downloads

Google Calendarautomationevent creationgoogle calendargoogle sheetsspreadsheet integration

Streamline Google Calendar event creation by automating the process from Google Sheets data.

🚀Ready to Deploy This Workflow?

⚡Deploy on Zeabur 🎁Get $200 Credit on DigitalOcean

About This Workflow

Overview

This workflow automates the creation of events in Google Calendar by reading event details from a Google Sheet. It fetches the latest event entry, formats the date correctly, and then creates a new event in Google Calendar with specified details like title, description, date, and location.

Key Features

Automatically creates Google Calendar events from new rows in a Google Sheet.
Fetches the most recent event entry from Google Sheets.
Formats event dates to ensure compatibility with Google Calendar.
Allows customization of event details including summary, description, start date, location, and background color.
Supports setting event availability status (Busy/Available).

How To Use

Import this workflow into your n8n instance.
Configure the New Event Entry Listener node with your Google Sheets credentials and specify the correct Document ID and Sheet Name.
Ensure your Google Sheet has columns named 'Event Name', 'Event Description', 'Event Start Date', and 'Location'.
Configure the Google Calendar Event Creator node with your Google Calendar credentials and select the target calendar.
Map the output fields from the Event Date Formatter node to the corresponding fields in the Google Calendar node.
Activate the workflow.

Apps Used

automation

event creation

google calendar

google sheets

spreadsheet integration

Workflow JSON

{
  "id": "82a81a43-11c2-4973-a434-0645aaa34919",
  "name": "Automate Google Calendar Event Creation from Google Sheets",
  "nodes": 0,
  "category": "Google Calendar",
  "status": "active",
  "version": "1.0.0"
}

Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.