link to a google page about this
go to https://console.developers.google.com/ and create a project
project name does not matter
within this project, click on libraries on the left side of the screen
search for "google sheets api", click on the result and click enable
now go to the credentials tab on the left side of the screen
click "Create credentials" at the top of the screen
select "API key"
this API key can be copied into leaderboard page
DO NOT SHARE THIS API KEY WITH ANYBODY. THE API KEY IS ONLY USED BY THE SITE TO MAKE A REQUEST TO GOOGLE'S SERVERS FROM YOUR OWN COMPUTER. SEE LINE 89 IN "script.js"
click the newly underlined API key under the API Keys heading on the credentials page
if you know your public IP address, you can add it to the application restrictions to ensure only you can use the key
under API restrictions, click "Restrict key" and then select "Google Sheets API" in the dropdown
hit save once you are done here
to be maximally safe, disable/delete the API key once you're done with it
additionally, consider making your API key on a google account with nothing attached to it (or at least no google sheets that could be read from/written to if the key is restricted to the sheets API)
if you have a question dm me on discord if they're open, same username