DUPATANE← Back to hands-on labs

GOOGLE WORKSPACE · AUTOMATION

Automating event registration end to end

A tested workflow using Google Forms, Sheets, Apps Script, Calendar, Meet and email to score eligibility, invite participants, send reminders and close registration automatically.

Google FormsGoogle SheetsApps ScriptCalendarEmailPower Automate design

Workflow architecture

Participant submits Form
        ↓
Response stored in Sheet
        ↓
Apps Script onFormSubmit
        ↓
Calculate eligibility score
   ↙                 ↘
Not qualified       Qualified
   ↓                   ↓
Result email       Add Calendar guest
                       ↓
                 Qualification email
                       ↓
              Scheduled reminder
                       ↓
              Registration closes

What was implemented

01

Event-driven scoring

Responses are evaluated as they arrive, with pass/fail state written back to the response sheet.

02

Invitation automation

Qualified participants are added to an existing Calendar event while duplicate invitations are avoided.

03

Scheduled operations

Time-driven triggers send reminders and close the registration form at the configured deadline.

04

Cross-platform design

The same behavior is mapped to Microsoft Forms, Power Automate, Outlook Calendar and Teams.

Validation performed

Form submission
→ Sheet entry created
→ Eligibility calculated
→ QUALIFIED status written
→ Qualification email received
→ Calendar guest added
→ Meeting invitation received

The fail path is also documented to verify that non-qualified users receive only the result notification and are not invited.

The public portfolio intentionally excludes participant data, private calendar IDs, OAuth details, live meeting URLs and organization-specific secrets.

Engineering outcomes