How ilgobbo00/aaga works
This Google Apps Script project manages annual athlete registrations submitted through a Google Form. Its main workflow processes a submitted response into a normalized Google Sheets record, adds a health-certificate expiration event to Google Calendar, and sends a registration email. A separate reminder capability covers expiring certificates and payment reminders. The README documents these integrations and responsibilities, but source excerpts were unavailable, so internal call details and trigger setup are not inferred beyond the documented workflow.
Main entry points: manageAnswers.gs Process response · reminders.gs Reminder handling · EmailIscrizione.html Registration email · EmailCompleanno.html Birthday email
Components 15
Registration
- Process response
manageAnswers.gs - Shared utilities
utils.gs - Configuration
constants.gs
Notifications
- Reminder handling
reminders.gs - Registration email
EmailIscrizione.html - Birthday email
EmailCompleanno.html - Payment email
EmailPagamenti.html - Registration reminder
EmailReminderIscrizioni.html - Certificate expiry email
EmailScadenzaCM.html
Google services
- Google Form
- Response sheet
- Google Calendar
- Email service
Other components
- Athlete
- Administrators
Connections 17
- Athlete → Google Form: submits response
- Google Form → Response sheet: records response
- Response sheet → Process response: triggers processing
- Process response → Response sheet: reads and updates
- Process response → Google Calendar: adds expiration event
- Process response → Email service: sends registration email
- Process response → Shared utilities: uses helpers
- Process response → Configuration: uses settings
- Reminder handling → Response sheet: checks records
- Reminder handling → Email service: sends reminders
- Google Calendar → Administrators: notifies
- Email service → Athlete: delivers email
- Registration email → Email service: email content
- Birthday email → Email service: email content
- Payment email → Email service: email content
- Registration reminder → Email service: email content
- Certificate expiry email → Email service: email content