gsheet-updater

Installation

brew tap gogolok/tap
brew install gsheet-updater

Authentication/Authorization

https://developers.google.com/workspace/guides/create-credentials

You can optionally use a service account to modify the Google sheet.

export SERVICE_ACCOUNT="myservice-account@example.iam.gservuceaccount.com"
export PRIVATE_KEY="-----BEGIN PRIVATE KEY----
MII...
-----END PRIVATE KEY-----"

Usage

export SPREADSHEET_ID="1WBAxWCxUQt9HXDWIbPXlQpKydYHvo2LUg5R4A-3d3LQ"
export FILE="hoursbytag.csv"
export TAB_ID="Sprint 25"

gsheet-updater

Manual Release Building

git tag -a v1.0.0
GOOS=darwin GOARCH=amd64 go build -ldflags "-X main.Version=v1.0.0"