dataset provides for importing from and export to a Google spreadsheet (i.e. GSheet). This does require some setup for this to work. dataset needs to beable to access the Google Sheets API for reading and writing. You can find documentation on setting up access in “step 1” at https://developers.google.com/sheets/api/quickstart/go.
You’ll need a “client_secret.json” file and OAuth authorization for access to be permitted.
If credentials for the OAuth part are usually stored in your $HOME/.credentials
directory
as sheets.googleapis.com-dataset.json. If this file doesn’t exist then the first time you
run the dataset command with a GSheet option it’ll prompt you to use your web browser
to authorize dataset to access your Google spreadsheet.