The month headings go from cell B2 to the right.
Each month's results are in a column starting at row 3.
The month columns do not get overwritten, just added to (inserted in chronological order).
The NodePing check names go from A3 down.
Each row has the results for one NodePing check (beginning at column B, one column per run of this app).
New rows for NodePing checks are inserted in alphabetical order. (If the existing checks are out of order, they will not be corrected.)

Setup

NodePing

Ensure that all the NodePing Checks you want included in the Google Sheet have a notification set to the group you will be polling for (e.g. "MyTeam Alerts").

Google API

Set up a Google API project and authentication credentials using a service account by following the instuctions at https://flaviocopes.com/google-api-authentication/
Give that service account edit permissions on your Google Sheet.

Note: There is a 100 writes per 100 seconds rate limit on Google Sheets.

Set environment variables

$ export NODEPING_TOKEN=EG123ABC
$ export GOOGLE_AUTH_CLIENT_EMAIL=example@myaccount-123.iam.gserviceaccount.com
$ export GOOGLE_AUTH_PRIVATE_KEY_ID=abc123
$ export GOOGLE_AUTH_PRIVATE_KEY=-----BEGIN PRIVATE KEY-----\nMIIE...\n...\nabc=\n-----END PRIVATE KEY-----\n
$ export GOOGLE_AUTH_TOKEN_URI=https://oauth2.googleapis.com/token

Note that these GOOGLE_AUTH_* variable values can be found in the json that Google provides when creating a services account. Also note that the Go code itself will convert "\n" to EOL in the GOOGLE_AUTH_PRIVATE_KEY value.

Run from command line

$ go run main.go run --help
$ go run main.go run -g "MyTeams Alerts" -s EG123ABC

The SPREADSHEET_ID is the middle part of the url for the target Google Sheet when you just browse to it.

# Packages

cmd

No description provided by the author

lib

No description provided by the author