`google-sheet spreadsheet` ========================== Manage spreadsheets * [`google-sheet spreadsheet:add`](#google-sheet-spreadsheetadd) * [`google-sheet spreadsheet:get`](#google-sheet-spreadsheetget) ## `google-sheet spreadsheet:add` Add a worksheet with the specified title to the spreadsheet ``` USAGE $ google-sheet spreadsheet:add --spreadsheetTitle [-h] [-r] [-c ] [-p ] [-f ] FLAGS -h, --help Show CLI help. -r, --rawOutput Get the raw output as a JSON string --spreadsheetTitle= (required) Title of the spreadsheet AUTHENTICATION FLAGS -c, --clientEmail= [env: GSHEET_CLIENT_EMAIL] The client email to use for authentication. Uses the GSHEET_CLIENT_EMAIL env variable if not provided. -f, --credentialsFile= [env: GSHEET_CREDENTIALS_FILE] Path to the service account JSON file to read the credentials from. Uses the GSHEET_CREDENTIALS_FILE env variable if not provided. The clientEmail and privateKey flags take precedence. -p, --privateKey= [env: GSHEET_PRIVATE_KEY] The private key to use for authentication. Uses the GSHEET_PRIVATE_KEY env variable if not provided. DESCRIPTION Add a worksheet with the specified title to the spreadsheet EXAMPLES $ gsheet worksheet:add --spreadsheetTitle= Spreadsheet "" () successfully created > https://docs.google.com/spreadsheets/d//edit ``` _See code: [src/commands/spreadsheet/add.ts](https://github.com/jroehl/google-sheet-cli/blob/master/src/commands/spreadsheet/add.ts)_ ## `google-sheet spreadsheet:get` Get info for a specific spreadsheet ``` USAGE $ google-sheet spreadsheet:get -s [-h] [-r] [-c ] [-p ] [-f ] FLAGS -h, --help Show CLI help. -r, --rawOutput Get the raw output as a JSON string -s, --spreadsheetId= (required) [env: SPREADSHEET_ID] ID of the spreadsheet to use AUTHENTICATION FLAGS -c, --clientEmail= [env: GSHEET_CLIENT_EMAIL] The client email to use for authentication. Uses the GSHEET_CLIENT_EMAIL env variable if not provided. -f, --credentialsFile= [env: GSHEET_CREDENTIALS_FILE] Path to the service account JSON file to read the credentials from. Uses the GSHEET_CREDENTIALS_FILE env variable if not provided. The clientEmail and privateKey flags take precedence. -p, --privateKey= [env: GSHEET_PRIVATE_KEY] The private key to use for authentication. Uses the GSHEET_PRIVATE_KEY env variable if not provided. DESCRIPTION Get info for a specific spreadsheet EXAMPLES $ gsheet spreadsheet:get --spreadsheetId= Fetched "" () > https://docs.google.com/spreadsheets/d//edit ``` _See code: [src/commands/spreadsheet/get.ts](https://github.com/jroehl/google-sheet-cli/blob/master/src/commands/spreadsheet/get.ts)_