Back to Templates

Automate Zoom Attendance Follow-ups with Recordings & Google Sheets Tracking

Created by

Created by: 荒城直也 || naoya-495

荒城直也

Last update

Last update 6 hours ago

Share


Workflow Overview
Zoom Attendance Evaluator with Follow-up is an n8n automation workflow that automatically evaluates Zoom meeting attendance and sends follow-up emails to no-shows and early leavers with recordings and materials.
Who's it for

  • Companies and organizations that regularly host online seminars and webinars
  • Educational institutions conducting online classes
  • Anyone looking to streamline participant attendance management and follow-up processes
    How it works
  1. Scheduled execution: Runs automatically every hour
  2. Fetch meeting data: Retrieves recent Zoom meetings and participant information
  3. Evaluate attendance: Automatically classifies participants into four categories:
    • No-show: 0 minutes attended
    • Early-leaver: Less than 50% attendance
    • Partial attendance: 50-80% attendance
    • Full attendance: Over 80% attendance
  4. Automatic follow-up: Sends automated emails with recording links and materials to no-shows and early leavers
  5. Record keeping: Logs all follow-ups to Google Sheets for tracking
    Requirements
  • Zoom account: OAuth2 authentication setup required
  • SMTP email server: Configuration needed (Gmail, SendGrid, etc.)
  • Google Drive: For storing handout materials
  • Google Sheets: For attendance logging
  • Credentials for each service configured in n8n
    How to customize the workflow
  • Adjust attendance thresholds: Modify the 50% and 80% values in the "Evaluate Attendance" node code
  • Change execution frequency: Configure the time interval in the "Schedule Trigger" node
  • Customize email template: Edit subject and body in the "Prepare Email Data" node
  • Next session registration link: Replace the placeholder URL in the code with your actual registration link
    This workflow completely automates post-meeting follow-up tasks, helping improve participant engagement and reduce manual work.