Event ticketing backend: auto QR tickets with Google Sheets & Gmail

Ticketing Backend automates registration, QR-ticket generation, email delivery, and check-in validation using Google Sheets, Gmail, and a webhook scanner — reducing manual ticket prep from ~3 hours to under 5 minutes for 200 attendees.


Why Use This Workflow?

- Time Savings: Automates ticket generation & delivery. reduces manual processing for 200 attendees from ~3 hours to <5 minutes. - Cost Reduction: Removes dependency on paid ticketing platforms for basic events — save up to $150–$300/month for small organizations. - Error Prevention: Single-source truth in Google Sheets with QR-based check-in reduces double-checkin and human errors by >90%. - Scalability: Runs on a schedule and webhooks; scales from dozens to thousands of tickets (watch API/email quotas).

Ideal For

- Event Organizers / Community Managers: Sell & distribute tickets for meetups, runs, and local events with immediate QR delivery. - Operations / Venue Staff: Fast, reliable check-in via mobile scanner POSTing to webhook for instant validation. - Small Agencies & SaaS Teams: Lightweight, low-cost ticketing backend that integrates with existing Google accounts.

How It Works

1. Trigger (Registration): POST /v1/register receives registration payload (nama, email, nohp, jumlahtiket, totalprice, paymentmethod). 2. Data Collection (Registration): Validate input → check existing participant in Register sheet → append registration. 3. Processing (Ticket Generation): Scheduled job (START runs every minute) finds rows with Payment Status = PAID and Email Sent = NO. 4. Intelligence Layer: For each ticket: generate unique Ticket ID (TL-YYYYMMDD-XXXX-N-HASH), build QR payload JSON, create QR image via qrserver API, and build HTML email with embedded base64 QR. 5. Output & Delivery: Send ticket email(s) via Gmail; write one Tickets row per generated ticket and mark Email Sent = YES in Register. 6. Storage & Logging: All participant & ticket records persisted to Google Sheets; check-in events update row (Checked In = YES and Checkin TIme).