Automate Monthly Absence Reporting from Google Calendar
This workflow automates the collection and reporting of absences marked as 'Holiday' or 'Illness' from Google Calendar on the first of each month. It aggregates the data and sends a detailed email report to the payroll team.
The workflow triggers at 8 AM on the first day of each month. It retrieves events from the previous month that are marked as 'Holiday' or 'Illness' in their summaries. The workflow calculates the total days for each type of absence per person, merges the data, and sends an email report to the payroll team. Users need to configure Google Calendar and email credentials and can customize the event search criteria in the Switch node.
- Platform
- n8n
- Category
- Business Operations & ERPs
- Price
- $9.99
- Creator
- Emma Rodriguez
- set
- code
- cron
- noOp
- merge
- switch
- dateTime
- emailSend
- googleCalendar
How to import this workflow into n8n
- 1Purchase or download the workflow to get the n8n workflow JSON file.
- 2In your n8n instance, open Workflows and choose "Import from File" (or paste the JSON with Ctrl+V on the canvas).
- 3Open each node marked with a credential warning and connect your own accounts and API keys.
- 4Run the workflow once manually to verify the data flow, then toggle it to Active.
Related Business Operations & ERPs workflows
- Automate Job Applications and Track Status with LinkedIn, Indeed, and Google Sheets$14.99
- Automated Stock Price Monitoring and Alerts for Indian & US Markets$9.99
- Build Custom Workflows Automatically with GPT-4o, RAG, and Web Search$24.99
- AI Chat Agent Receptionist for Clinics$150
- Automatically Archive Zoom Recordings to Google Drive and Log in Airtable$4.99
- Automate Call Scheduling with Voice AI Receptionist Using Twilio, Google Calendar & Airtable$24.99
More from Emma Rodriguez
Need this deployed? We'll set it up for you.
Our automation experts deploy this workflow in your stack, connect your accounts, and verify it works — or build a custom solution from scratch.