Library / Reports, Analytics & Dashboards
Reports, Analytics & Dashboards
Email Monthly Attendance Reports from Google Calendar
On the first of every month at 8am, the workflow reads last month's Google Calendar entries, counts holiday and illness days and emails a summary via SMTP.
What it does
# Datetime Workflow ## Overview Automated workflow: Datetime Workflow. This workflow processes data and performs automated tasks. ## Workflow Details - Total Nodes: 16 - Node Types: 11 - Error Handling: ✅ Implemented - Security: ✅ Hardened (no sensitive data) - Documentation: ✅ Complete ## Node Breakdown - Previous Month: dateTime - 1st of Every month at 8am: cron - Check Summary for Illness or Holiday: switch - Holiday: noOp - Illness: noOp - Filter Holiday Days: set - Filter Illness Days: set - Merge: merge - Get previous months events: googleCalendar - Send email to payroll: emailSend - ... and 6 more nodes ## Usage Instructions 1. Configure Credentials: Set up all required API keys and credentials 2. Update Variables: Replace any placeholder values with actual data 3. Test Workflow: Run in test mode to verify functionality 4. Deploy: Activate the workflow for production use ## Security Notes - All sensitive data has been removed or replaced with placeholders - Error handling is implemented for reliability - Follow security best practices when configuring credentials ## Troubleshooting - Check error logs if workflow fails - Verify all credentials are properly configured - Ensure all required services are accessible
The steps
- Previous Month
- 1st of Every month at 8am
- Check Summary for Illness or Holiday
- Holiday
- Illness
- Filter Holiday Days
- Filter Illness Days
- Merge
- Get previous months events
- Send email to payroll
- Combine Holiday Counts
- Combine Illness Counts
- Build the message to send
- Error Handler for daf227d9
23 steps in total.
Similar automations
Tasks & Project ManagementTrack Work Attendance by Location in Google Sheets7 stepsTasks & Project ManagementLog Work Attendance from Location Triggers20 stepsData Sync & ETLLog Zoom Attendance with Claude and OpenAI11 stepsReports, Analytics & DashboardsWrite Monthly Expense Reports with Claude RAG11 steps