(Made for Bethel <3>)
Bethel Leaderboard is a simple and publicly accessible leaderboard application that fetches data from a Google Sheet. It allows users to create and share leaderboards with teams and their respective points.
-
Real-Time Data Refresh: Utilizes JavaScript's
setInterval
function to periodically refresh data from a publicly shared Google Sheet. -
Automatic Sorting: Scores are automatically sorted and displayed on the frontend after each refresh.
-
Styling with Tailwind CSS: Styling is implemented using Tailwind CSS for a clean and responsive user interface.
-
No User Authentication: The app does not require user authentication since it relies on a publicly shared Google Sheet. This makes it easy to share and view leaderboards.
-
Metadata Sheet: Uses a metadata sheet in the Google Sheet document to convey information to the frontend, including leaderboard name, subtext, and image.
-
Share a Publicly Accessible Google Sheet:
- To get started, you need to share a Google Sheet with public access. Follow these steps:
- Open your Google Sheet document.
- Click on the "Share" button located in the top right corner.
- Set the general access to "Anyone with this link" and choose "Viewer" to allow public viewing.
- Copy the link to the Google Sheet.
- To get started, you need to share a Google Sheet with public access. Follow these steps:
-
Copy Google Sheet Format:
- Copy the Google Sheet format from this link.
-
Open the App:
- Open the Bethel Leaderboard app by visiting leaderboard.bethelcarnival.fun, paste the Google Sheet link on the home page, and press the open button.
The Google Sheet should contain two sheets:
- Board: Where you update team names and points.
- Metadata: Used to provide frontend information like the leaderboard name, subtext, and image.
The source code for Bethel Leaderboard is publicly available on GitHub. Feel free to contribute, create your own version, or suggest improvements.
If you encounter any issues or have suggestions for improvements, please open an issue on the GitHub repository.
This project is licensed under the ISC License.
Note: For the most up-to-date information and detailed instructions, please refer to the GitHub repository.