Monthly Absence Report Generator
detail.loadingPreview
Generates a monthly report of employee holidays and illnesses from Google Calendar and emails it to payroll.
🚀Ready to Deploy This Workflow?
About This Workflow
Overview
This workflow automates the process of generating a monthly absence report. It retrieves holiday and illness events from a specified Google Calendar for the previous month, calculates the total days for each type of absence per employee, and then compiles and sends this information as an email to the payroll team.
Key Features
- Triggers monthly on the 1st at 8 AM.
- Fetches events from Google Calendar for the previous month.
- Differentiates between 'Holiday' and 'Illness' events.
- Calculates the number of days for each absence.
- Aggregates absence days by employee name for each type.
- Formats a clear summary message.
- Sends the report via email to a designated payroll address.
How To Use
- Import this workflow into your n8n instance.
- Configure the 'Google Calendar' node with your credentials and the specific calendar to monitor.
- Set the 'Send email to payroll' node with your SMTP credentials and the correct recipient email address for payroll.
- Ensure the Google Calendar events are consistently formatted to allow for accurate parsing of names and dates.
- Run the workflow manually to test or wait for the scheduled monthly trigger.
Apps Used
Workflow JSON
{
"id": "968d811a-f0c6-43d7-9656-745dc66fa09e",
"name": "Monthly Absence Report Generator",
"nodes": 0,
"category": "Reporting & Notifications",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: 968d811a-f0c6...
About the Author
SaaS_Connector
Integration Guru
Connecting CRM, Notion, and Slack to automate your life.
Statistics
Verification Info
Related Workflows
Discover more workflows you might like
Robust Concurrency Control for n8n Workflows with Redis
Prevent simultaneous execution of critical n8n workflows or tasks using a centralized, Redis-backed locking mechanism. This reusable utility workflow ensures data integrity and resource management by allowing other workflows to acquire, check, and release locks.
Telegram Profanity & Toxicity Filter
This n8n workflow automatically monitors incoming Telegram messages for profanity and toxic language. It leverages Google's Perspective API to analyze message content, and if a message is deemed inappropriate, the workflow sends an automated warning response back to the sender.
Automated Multi-Platform Social Media Publisher
Streamline your social media content creation and publishing with this n8n workflow. Simply fill out a web form with your caption, media (image or video), and target platforms, and let n8n automate the posting process across multiple social networks.
Universal CSV to JSON API Converter
Effortlessly transform CSV data into structured JSON with this versatile n8n workflow. Integrate it into any application as a custom API endpoint, supporting various input methods including file uploads and raw text.
Automate DOCX to PDF Conversion and Save Locally
This workflow automates the process of converting a Microsoft Word DOCX file to a PDF document. It downloads a source DOCX file, uses ConvertAPI to perform the conversion, and then saves the resulting PDF file directly to your local disk.
Convert Any Webpage to PDF and Save Locally
This n8n workflow provides a simple way to convert any public webpage URL into a PDF document. Once converted, the PDF file is automatically saved to your local disk, making it easy to archive or share web content offline.