Free Lottery Management System – Google Sheets Apps Script

A lottery and raffle management system built on Google Sheets, with two front doors: an admin panel for whoever runs the draw, and a public checker where anyone can verify a ticket without an account. That split is the whole point — participants should be able to check a ticket without being given a login.

What it does

The organiser signs in and sets up prizes, manages the draw and watches the activity log, which records every action taken so a disputed result has a trail behind it. Participants open the public page and verify a ticket using their phone number and ticket number; the check runs against the sheet in real time and tells them immediately whether they have won. Lists export to CSV or PDF, or print, when the draw has to be reported to someone.

Highlights

• Admin panel plus a public ticket checker
• Prize management and real-time winner checking
• Ticket verification by phone number and ticket number
• Activity logs and audit trail of every action
• Profile image upload to Google Drive
• Dark mode and custom theme colours
• Mobile responsive with bottom navigation
• Export to CSV and PDF, or print

Who it is for

Raffle draws, prize giveaways, contest and fundraising organisers, and community groups who need the draw to look credible and be checkable. It also works as a reference build for a Google Apps Script app that serves both a logged-in dashboard and a public page from the same project.