Online Voting System for Student Elections – Google Sheets

A digital ballot system for student councils, societies and institutional elections. Voters verify against a roll, cast one vote per position, and the results board updates as ballots land — with no paper to count afterwards.

One person, one vote

This is the requirement everything else depends on. Voters are verified against student and staff IDs held in the sheet, and the one-time voting logic blocks a second ballot from the same ID. Without that guarantee an online election is not an election; with it, the count is defensible.

Voting by position

Candidates are filtered by the position they are standing for, so a voter works through each office in turn and sees only the people contesting it. Candidate photos are pulled from Google Drive, which makes the ballot recognisable rather than a list of names.

Results as they happen

A live results dashboard reads from the sheet, so organisers can watch turnout build and announce outcomes the moment polling closes — no counting session, no tallying disputes.

Who it suits

Universities and colleges running student council elections, schools electing prefects and house captains, societies and associations voting on office bearers, and anyone who needs a small, auditable election without commissioning software for it.

Setup

Copy the sheet, load your voter roll and candidates, deploy the script and share the link during the polling window. Google Sheets holds the roll, the candidates and every vote cast. The video covers the full build, and support is free if you get stuck.