Automate Monthly Absence Reporting from Google Calendar - n8n Workflow | Neura Market
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
Free
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.