The spreedsheet looks like this:
A | B |
---|---|
Woom | 10.23 |
speedi | 12.34 |
Ach | 13.34 |
Tomi | 18.36 |
Create the serivce account credentials from Google API console
Download and rename to credentials.json
and keep under ./backend
Find the client_email
from credentials.json
looks like below
{
"client_email": "leaderboard@<project-12345>.iam.gserviceaccount.com"
}
Share the Google spreadsheet to this email
docker-compose up --build
visit http://localhost:3000