This project creates a web service that can get kanban team metrics from Google Sheet spreadsheet and display charts for cycle time and throughput for one or multiple teams.
The sheet name must be equal to the team name (see example sheet)
- Go to this link to enable Google Sheets API and get the credentials JSON file.
- Compile with
go build ./...
export CREDENTIALS=(path to the credentials JSON file)
export SHEET_ID=(google sheet id)
. You can get the id from the Sheet URL- Run the program and authenticate with your Google account (the program will create another authentication JSON file
The service is available at http://localhost:8080
.
Check out the example sheet that was exported to example.xlsx
. You can
import that into your Google Sheets.