Send Preventive Maintenance Schedules with Google Sheets and Gmail ICS Invites β€” n8n Workflow

Low complexity⏰ Scheduled5 nodes🏷️ Project Managementby WeblineIndia

Overview

πŸ—“ Preventive Maintenance Scheduler via ICS Email (n8n | Google Sheets | Gmail)

This workflow automatically reads your daily preventive maintenance schedule from Google Sheets and sends each assigned team member a personalized calendar invite (.ICS) as an email attachment. No more manual reminders or copying events β€” your operations and field teams will always be on schedule with clear, actionable reminders!

Who’s it For

Maintenance teams at plants, renewable sites, factories. Facility and ope

Nodes used

Google SheetsGmailCode

Workflow Preview

Preventive Maintenance Scheduler via ICS Emai
Preventive Maintenance Scheduler (Google Shee
1. Daily Trigger
- Triggers workflow daily at desired time.
2. Read Maintenance Tasks
- Reads maintenance tasks sche
⚑
D
Daily Trigger
Read Maintenance Tasks
Generate ICS Data
C
Create ICS File
Send Calendar Invite Email
5 nodes4 edges

How it Works

  1. 1

    Trigger

    The workflow starts with a scheduled trigger, running on a defined schedule.

  2. 2

    Process

    Data flows through 5 nodes, connecting code, converttofile, gmail.

  3. 3

    Output

    The workflow completes its automation and delivers the result to the configured destination.

Node Details (5)

GO

Google Sheets

googleSheets

#1
GM

Gmail

gmail

#2
CO

Code

code

#3

How to Import This Workflow

  1. 1Click Download JSON button on the right to save the workflow file.
  2. 2Open your n8n instance. Go to Workflows β†’ New β†’ Import from file.
  3. 3Select the downloaded send-preventive-maintenance-schedules-with-google-sheets-and-gmail-ics-invites file and click Import.
  4. 4Set up credentials for each service node (API keys, OAuth, etc.).
  5. 5Click Test Workflow to verify everything works, then activate it.

Or paste directly in n8n β†’ Import from JSON:

{ "name": "Send Preventive Maintenance Schedules with Google Sheets and Gmail ICS Invites", "nodes": [...], ...}

Integrations

codeconverttofilegmailgooglesheetsscheduletrigger

Get This Workflow

Download and import in one click

Download JSONView on n8n.io
Nodes5
Complexitylow
Triggerscheduled
CategoryProject Management

Created by

WeblineIndia

WeblineIndia

@weblineindia

Tags

codeconverttofilegmailgooglesheetsscheduletrigger
⚑

New to n8n?

n8n is a free, open-source workflow automation tool. Self-host it or use the cloud version.

Get n8n Free β†’