Community Event Reminder Notifier

Thursday General Reminder

Sends to all Dining Hall volunteers regardless of their slot day. Use this on Thursday May 21 to give everyone a heads-up before the event starts.

— pending (not yet sent)

Day-of Reminder

Sends only to volunteers whose slot is today. Run this on May 22, 23, and 24 each morning to notify that day's team.

— pending for today's slots

How to use: Copy the message below → open WhatsApp on your phone → create a Broadcast List with the numbers shown → paste and send. A Broadcast List sends individually to each person (they don't see each other).

Event Details

Event Name

Location

Event Dates

Day 1 (Friday)

Day 2 (Saturday)

Day 3 (Sunday)

Thursday Reminder Date

Sender Contact

Your Name / Team Name

Reply-to Email

Your Phone (shown in messages)

Excel File

Excel File Path

Sheet Name

Service Filter Keyword

Rows containing this text in the Service column will be included.

Email (SMTP)

Gmail Address

App Password

SMTP Port

Use a Gmail App Password (not your regular password). Go to Google Account → Security → 2-Step Verification → App Passwords.

Test Before Sending

Send a test email to yourself to verify everything is configured correctly. Does not touch the volunteer list or update the Excel file.

Test Email 1

Test Email 2

Community Event Reminder Notifier

Volunteers —

Thursday General Reminder

Day-of Reminder

Send Results

Event Details

Sender Contact

Excel File

Email (SMTP)

Test Before Sending

Community Event Reminder Notifier

Volunteers —

Thursday General Reminder

Day-of Reminder

Send Results

Event Details

Sender Contact

Excel File

Email (SMTP)

Test Before Sending

Confirm Send