Skip to content
NEWMarketplace and the trig8n Agent: sell what you build, and get plans and changes that are tested before you see them. See what is new

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

  1. Previous Month
  2. 1st of Every month at 8am
  3. Check Summary for Illness or Holiday
  4. Holiday
  5. Illness
  6. Filter Holiday Days
  7. Filter Illness Days
  8. Merge
  9. Get previous months events
  10. Send email to payroll
  11. Combine Holiday Counts
  12. Combine Illness Counts
  13. Build the message to send
  14. Error Handler for daf227d9

23 steps in total.

Similar automations