Skip to content
Scoring system for contests and competitions using Google Spreadsheet API and PHP
Branch: master
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
css
fonts
image
js
results
vendor
README.md
composer.json
composer.lock
form.php
index.php
post.php

README.md

ScoringSystem

Google Spreadsheet-based online scoring system for contests and competitions using Google Drive API and PHP

System Structure

  • index.php: page to be shared to judges
  • form.php: each judge inputs their scores in their individual page
  • post.php: updates Google Spreadsheet with the input scores using Google's Drive API
  • results/index.php: collects data from Google Spreadsheet to show top 3 teams

Requirements

  • In Google Cloud Console
    • Create a new project
    • Enable Drive API
    • "Create Credentials" -> Service Account Key -> Create P12 Key under "App Engine default sevice account" -> Save that P12 key safely
  • Create a new spreadsheet and share it with the App Engine default service account (usually it's "********@appspot.gserviceaccount.com", you can check in Google Cloud Console under "IAM & Admin")
  • replace ***** with yours in post.php
$G_CLIENT_ID = 'xxxxxxxxxxxxxxxxxxxxxxxx.apps.googleusercontent.com';
$G_CLIENT_EMAIL = 'xxxxxxxxxxxxxxxxxxxxx@appspot.gserviceaccount.com';
$G_CLIENT_KEY_PATH = 'xxxxxxxxxxxxxxxxxx.p12';
You can’t perform that action at this time.