1. Configure a Google Sheet for Leaderboards
To run a leaderboard against a Google Sheet the sheet needs to have two specific columns:
- Email Address: This column will contain the email address associated with the Spinify user.
- Score: This column will contain the score the team member currently has in the comp. Note this column could be a formula based on other fields.
The columns can have any names as you will specify which column contains the information when you create the leaderboard.
Simple google sheet setup:
(This google sheet would allow you to create 2 leaderboards. The first would be on the number of sales using "Email" and "Sales #" columns and the second leaderboard would use the "Email" and "Sales $" columns to create a dollar value leaderboard. More information on creating multiple leaderboards from a single Google Sheet here.
2. Create A Leaderboard
When creating a leaderboard on a Google Sheet choose “Google Sheet Data” under the goal option.
You will then be prompted to choose the Sheet from your Google Drive, along with the columns that relate to the Email and Score the team member has.
The rest of the process for creating a leaderboard is the same.
Further details on creating a leaderboard are found here.