Make a leaderboard

Your participants enter their revenue numbers (or whatever it is you're tracking) into a Google Form. This page compiles what they submit into a live scoreboard. Free, nothing to install.

A Google Form titled Cohort Leaderboard: Demo Form with name, revenue, and outreach questions
1. You send the form to your participants
A Google Sheet with form responses landing as rows: names, revenue, and outreach numbers
2. Entries land in a Google Sheet, automatically
A live cohort leaderboard ranking teams by revenue and outreach, with medals for the top three
3. The leaderboard updates itself

First, three steps in Google (about 10 minutes):

1. Get your form

Copy the template form. In your copy, click Publish in the top right corner. Clicking Publish is what lets your participants submit their numbers.

The Publish button in the top right corner of the Google Forms editor, circled in red
2. Create the spreadsheet where answers land

In your form, click the Responses tab, then Link to Sheets, then Create. Google opens a new spreadsheet. From now on, every form submission automatically appears as a row there. It fills itself.

The Responses tab in Google Forms with the Link to Sheets button circled in red
3. Get the link that feeds the scoreboard

In that spreadsheet: File > Share > Publish to web. In the dialog, change the first dropdown to Form Responses 1 and the second dropdown to Comma-separated values (.csv). Click Publish and copy the long link it gives you. That link goes in the first box below. (A link like that is exactly what feeds the demo board.)

Google Sheets' Publish to the web dialog with the two dropdowns, set to Form Responses 1 and Comma-separated values, outlined in red
In your form: the Publish or Send dialog has a responder link. It contains "forms", not "spreadsheets".