Jonathan This workflow corresponds to n8n.io template #1465 — we link there as the canonical source.
The workflow JSON
Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →
{
"nodes": [
{
"id": "6f869392-1501-49b9-be86-4b767f7ec597",
"name": "Previous Month",
"type": "n8n-nodes-base.dateTime",
"position": [
360,
420
],
"parameters": {
"value": "={{Date()}}",
"action": "calculate",
"options": {},
"duration": 1,
"timeUnit": "months",
"operation": "subtract"
},
"typeVersion": 1
},
{
"id": "1446eb44-bd1e-4dad-9ecc-c2a1e8cb2ca6",
"name": "1st of Every month at 8am",
"type": "n8n-nodes-base.cron",
"position": [
180,
420
],
"parameters": {
"triggerTimes": {
"item": [
{
"hour": 8,
"mode": "everyMonth"
}
]
}
},
"typeVersion": 1
},
{
"id": "a044ac76-49d9-4046-b008-2b4adf6512b1",
"name": "Check Summary for Illness or Holiday",
"type": "n8n-nodes-base.switch",
"position": [
760,
420
],
"parameters": {
"rules": {
"rules": [
{
"value2": "Holiday",
"operation": "contains"
},
{
"output": 1,
"value2": "Illness",
"operation": "contains"
}
]
},
"value1": "={{$json[\"summary\"]}}",
"dataType": "string"
},
"typeVersion": 1
},
{
"id": "6b40beab-7938-4aaa-a8a8-7a1e364dc2de",
"name": "Holiday",
"type": "n8n-nodes-base.noOp",
"position": [
980,
220
],
"parameters": {},
"typeVersion": 1
},
{
"id": "b069f3ce-66d1-4f64-946b-f9fda27db46b",
"name": "Illness",
"type": "n8n-nodes-base.noOp",
"position": [
980,
400
],
"parameters": {},
"typeVersion": 1
},
{
"id": "5725626b-2bfd-47a0-947e-efd28f0c29fe",
"name": "Filter Holiday Days",
"type": "n8n-nodes-base.set",
"position": [
1180,
220
],
"parameters": {
"values": {
"string": [
{
"name": "Name",
"value": "={{$json[\"description\"].split(\",\")[0]}}"
},
{
"name": "Days",
"value": "={{(new Date($json[\"end\"][\"date\"]).getTime() - new Date($json[\"start\"][\"date\"]).getTime()) / (1000 * 3600 * 24)}}"
},
{
"name": "Type",
"value": "Holiday"
}
]
},
"options": {},
"keepOnlySet": true
},
"typeVersion": 1
},
{
"id": "3114eb4f-a5be-452c-9729-b94d2904eb4b",
"name": "Filter Illness Days",
"type": "n8n-nodes-base.set",
"position": [
1180,
400
],
"parameters": {
"values": {
"string": [
{
"name": "Name",
"value": "={{$json[\"description\"].split(\",\")[0]}}"
},
{
"name": "Days",
"value": "={{(new Date($json[\"end\"][\"date\"]).getTime() - new Date($json[\"start\"][\"date\"]).getTime()) / (1000 * 3600 * 24)}}"
},
{
"name": "Type",
"value": "Illness"
}
]
},
"options": {},
"keepOnlySet": true
},
"typeVersion": 1
},
{
"id": "04617849-c162-4af5-9634-ab8ffd925625",
"name": "Merge",
"type": "n8n-nodes-base.merge",
"position": [
1620,
320
],
"parameters": {},
"typeVersion": 1
},
{
"id": "daf227d9-938d-4110-9a47-5bf8bb661586",
"name": "Get previous months events",
"type": "n8n-nodes-base.googleCalendar",
"position": [
560,
420
],
"parameters": {
"options": {
"timeMax": "={{new Date().toISOString()}}",
"timeMin": "={{$json[\"data\"]}}"
},
"calendar": "[Select Cal]",
"operation": "getAll",
"returnAll": true
},
"credentials": {
"googleCalendarOAuth2Api": {
"name": "<your credential>"
}
},
"typeVersion": 1
},
{
"id": "19ec862a-e71a-49f9-b799-26f73a410553",
"name": "Send email to payroll",
"type": "n8n-nodes-base.emailSend",
"position": [
1980,
320
],
"parameters": {
"text": "={{$json[\"message\"]}}",
"options": {},
"subject": "Absences from last month",
"toEmail": "user@example.com",
"fromEmail": "user@example.com"
},
"credentials": {
"smtp": {
"name": "<your credential>"
}
},
"typeVersion": 1
},
{
"id": "5805b2e1-e723-4803-a7e0-8df5fd4cf84d",
"name": "Combine Holiday Counts",
"type": "n8n-nodes-base.code",
"position": [
1380,
220
],
"parameters": {
"jsCode": "let names = $input.all().map(e => e.json.Name);\nlet unique_names = [...new Set(names)];\nlet results = [];\n\nfor (thisName of unique_names) {\n let result = {\n \"Name\": thisName,\n \"Days\": 0,\n \"Type\": \"Holiday\"\n }\n\n for (matching_item of $input.all().filter(e => e.json.Name === thisName)) {\n result.Days += parseInt(matching_item.json.Days);\n }\n \n results.push(result);\n}\n\nreturn results.map(e => { return {json: e} });"
},
"typeVersion": 1
},
{
"id": "c30345ae-1a19-4453-a67b-eda71cb7326e",
"name": "Combine Illness Counts",
"type": "n8n-nodes-base.code",
"position": [
1380,
400
],
"parameters": {
"jsCode": "let names = $input.all().map(e => e.json.Name);\nlet unique_names = [...new Set(names)];\nlet results = [];\n\nfor (thisName of unique_names) {\n let result = {\n \"Name\": thisName,\n \"Days\": 0,\n \"Type\": \"Illness\"\n }\n\n for (matching_item of $input.all().filter(e => e.json.Name === thisName)) {\n result.Days += parseInt(matching_item.json.Days);\n }\n \n results.push(result);\n}\n\nreturn results.map(e => { return {json: e} });"
},
"typeVersion": 1
},
{
"id": "7bac2604-ca55-4300-a7a5-38fc96830ba6",
"name": "Build the message to send",
"type": "n8n-nodes-base.code",
"position": [
1800,
320
],
"parameters": {
"jsCode": "let illnessMessage = \"\";\nlet holidayMessage = \"\";\nlet message = \"Here is a breakdown of absences for the last month.\\n\\n\";\n\n// Loop the input items\nfor (item of $input.all()) {\n if (item.json.Type == \"Holiday\") {\n holidayMessage += item.json.Name + \" had \" + item.json.Days + \" days\\n\";\n }\n if (item.json.Type == \"Illness\") {\n illnessMessage += item.json.Name + \" had \" + item.json.Days + \" days\\n\";\n }\n}\n\nif (holidayMessage != \"\") {\n message += \"Holiday Events\\n\";\n message += holidayMessage + \"\\n\";\n} else {\n message += \"No Holiday Events\\n\";\n}\n\nif (illnessMessage != \"\") {\n message += \"Illness Events\\n\";\n message += illnessMessage;\n} else {\n message += \"No Illness Events\\n\";\n}\n\n// Return our message\nreturn [{json: {message}}];"
},
"typeVersion": 1
}
],
"connections": {
"Merge": {
"main": [
[
{
"node": "Build the message to send",
"type": "main",
"index": 0
}
]
]
},
"Holiday": {
"main": [
[
{
"node": "Filter Holiday Days",
"type": "main",
"index": 0
}
]
]
},
"Illness": {
"main": [
[
{
"node": "Filter Illness Days",
"type": "main",
"index": 0
}
]
]
},
"Previous Month": {
"main": [
[
{
"node": "Get previous months events",
"type": "main",
"index": 0
}
]
]
},
"Filter Holiday Days": {
"main": [
[
{
"node": "Combine Holiday Counts",
"type": "main",
"index": 0
}
]
]
},
"Filter Illness Days": {
"main": [
[
{
"node": "Combine Illness Counts",
"type": "main",
"index": 0
}
]
]
},
"Combine Holiday Counts": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 0
}
]
]
},
"Combine Illness Counts": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 1
}
]
]
},
"1st of Every month at 8am": {
"main": [
[
{
"node": "Previous Month",
"type": "main",
"index": 0
}
]
]
},
"Build the message to send": {
"main": [
[
{
"node": "Send email to payroll",
"type": "main",
"index": 0
}
]
]
},
"Get previous months events": {
"main": [
[
{
"node": "Check Summary for Illness or Holiday",
"type": "main",
"index": 0
}
]
]
},
"Check Summary for Illness or Holiday": {
"main": [
[
{
"node": "Holiday",
"type": "main",
"index": 0
}
],
[
{
"node": "Illness",
"type": "main",
"index": 0
}
]
]
}
}
}
Credentials you'll need
Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.
googleCalendarOAuth2Apismtp
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
This workflow checks a Google Calendar at 8am on the first of each month to get anything that has been marked as a Holiday or Illness. It then merges the count for each person and sends an email with the list.
Source: https://n8n.io/workflows/1465/ — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
Perfect for content publishing with organic scheduling patterns, social media automation, API systems that need to avoid rate limiting, or any automation requiring randomised timing control across mul
Complete backup solution that saves both workflows and credentials to local/server disk with optional FTP upload for off-site redundancy.
This automated n8n workflow checks daily travel itineraries, syncs upcoming trips to Google Calendar, and sends reminder notifications to travelers via email or SMS. Perfect for travel agencies, tour
This automated n8n workflow checks daily class schedules, syncs upcoming classes to Google Calendar, and sends reminder notifications to students via email or SMS. Perfect for educational institutions
This n8n workflow automates the secure transfer of files between FTP servers on a scheduled basis, providing enterprise-grade reliability with comprehensive error handling and dual notification system