How to Use a Single Google Sheet with Multiple Leaderboards

With Spinify, it's possible to use a single Google Sheets as a data source for multiple leaderboards. To do this, follow the steps below. Alternatively, create a new Google Sheet for each leaderboard.

1. Make sure Google Sheets is Integrated.

Make sure you have integrated Google Sheets with Spinify. The easiest way to do this is to go to the Integrations page and make sure it says Connected.

 If you haven't please follow the instructions in the How to link Google Sheets article

2. Create a Google Sheet

If you haven't already created at least one Google Sheet, you can find an example in the How To Setup Google Sheets for Spinify Leaderboards article.

For each leaderboard, you'll need to add an additional column to use for the relevant scores on each leaderboard. For example, you may want to track the number of deals made and the total value of the deals.

So, the GoogleSheet could look like this:

image.png

Note: You cannot create multiple leaderboards using separate spreadsheets within the same Google Sheets document, you must either use separate columns in a single sheet or create a new sheet for each leaderboard. 

3. Create Leaderboards using Different Google Sheet Columns

When creating a leaderboard on a Google Sheet choose “Google Sheet Data” under the goal option.

For each leaderboard, choose a different column. For additional help with this you can follow How To Setup Google Sheets for Spinify Leaderboards or reach out to us on chat.

Note: If you have not created MySpinify users yet you can follow this Article about How To Add Users.

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.