{"meta":{"instanceId":"workflow-da8e9884","versionId":"1.0.0","createdAt":"2025-09-29T07:07:44.101595","updatedAt":"2025-09-29T07:07:44.101610","owner":"n8n-user","license":"MIT","category":"automation","status":"active","priority":"high","environment":"production"},"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,"notes":"This dateTime node performs automated tasks as part of the workflow."},{"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,"notes":"This cron node performs automated tasks as part of the workflow."},{"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,"notes":"This switch node performs automated tasks as part of the workflow."},{"id":"6b40beab-7938-4aaa-a8a8-7a1e364dc2de","name":"Holiday","type":"n8n-nodes-base.noOp","position":[980,220],"parameters":{},"typeVersion":1,"notes":"This noOp node performs automated tasks as part of the workflow."},{"id":"b069f3ce-66d1-4f64-946b-f9fda27db46b","name":"Illness","type":"n8n-nodes-base.noOp","position":[980,400],"parameters":{},"typeVersion":1,"notes":"This noOp node performs automated tasks as part of the workflow."},{"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,"notes":"This set node performs automated tasks as part of the workflow."},{"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,"notes":"This set node performs automated tasks as part of the workflow."},{"id":"04617849-c162-4af5-9634-ab8ffd925625","name":"Merge","type":"n8n-nodes-base.merge","position":[1620,320],"parameters":{},"typeVersion":1,"notes":"This merge node performs automated tasks as part of the workflow."},{"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":{"id":"{{ $credentials.googleCalendarOAuth2Api.id }}","name":"Google Calendar account"}},"typeVersion":1,"notes":"This googleCalendar node performs automated tasks as part of the workflow."},{"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":"payroll-team@mydomain.tld","fromEmail":"n8n@mydomain.tld"},"credentials":{"smtp":{"id":"{{ $credentials.smtp.id }}","name":"mailtrap"}},"typeVersion":1,"notes":"This emailSend node performs automated tasks as part of the workflow."},{"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,"notes":"This code node performs automated tasks as part of the workflow."},{"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,"notes":"This code node performs automated tasks as part of the workflow."},{"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,"notes":"This code node performs automated tasks as part of the workflow."}],"connections":{"Get previous months events":{"main":[[]]},"Send email to payroll":{"main":[[],[],[],[],[],[],[],[]]}},"name":"Datetime Workflow","description":"Automated workflow: Datetime Workflow. This workflow processes data and performs automated tasks.","settings":{"executionOrder":"v1","saveManualExecutions":true,"callerPolicy":"workflowsFromSameOwner","errorWorkflow":null,"timezone":"UTC","executionTimeout":3600,"maxExecutions":1000,"retryOnFail":true,"retryCount":3,"retryDelay":1000},"notes":"Excellent quality workflow: Datetime Workflow. This workflow has been optimized for production use with comprehensive error handling, security, and documentation."}