`google-sheet worksheet` ======================== Manage worksheets * [`google-sheet worksheet:add`](#google-sheet-worksheetadd) * [`google-sheet worksheet:get`](#google-sheet-worksheetget) * [`google-sheet worksheet:remove`](#google-sheet-worksheetremove) * [`google-sheet worksheet:rename`](#google-sheet-worksheetrename) ## `google-sheet worksheet:add` Add a worksheet with the specified title to the spreadsheet ``` USAGE $ google-sheet worksheet:add -t -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 -t, --worksheetTitle= (required) [env: WORKSHEET_TITLE] Title of the worksheet 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 Add a worksheet with the specified title to the spreadsheet EXAMPLES $ gsheet worksheet:add --spreadsheetId= --worksheetTitle= Worksheet "" () successfully created ``` _See code: [src/commands/worksheet/add.ts](https://github.com/jroehl/google-sheet-cli/blob/master/src/commands/worksheet/add.ts)_ ## `google-sheet worksheet:get` Get info for a specific worksheet ``` USAGE $ google-sheet worksheet:get -t -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 -t, --worksheetTitle= (required) [env: WORKSHEET_TITLE] Title of the worksheet 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 worksheet EXAMPLES $ gsheet worksheet:get --spreadsheetId= --worksheetTitle= Fetched "" () ``` _See code: [src/commands/worksheet/get.ts](https://github.com/jroehl/google-sheet-cli/blob/master/src/commands/worksheet/get.ts)_ ## `google-sheet worksheet:remove` Remove a worksheet with the specified title from the spreadsheet ``` USAGE $ google-sheet worksheet:remove -t -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 -t, --worksheetTitle= (required) [env: WORKSHEET_TITLE] Title of the worksheet 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 Remove a worksheet with the specified title from the spreadsheet EXAMPLES $ gsheet worksheet:remove --spreadsheetId= --worksheetTitle= Worksheet "" successfully removed ``` _See code: [src/commands/worksheet/remove.ts](https://github.com/jroehl/google-sheet-cli/blob/master/src/commands/worksheet/remove.ts)_ ## `google-sheet worksheet:rename` Add a worksheet with the specified title to the spreadsheet ``` USAGE $ google-sheet worksheet:rename -t --newWorksheetTitle -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 -t, --worksheetTitle= (required) [env: WORKSHEET_TITLE] Title of the worksheet to use --newWorksheetTitle= (required) New title of the worksheet 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 Add a worksheet with the specified title to the spreadsheet EXAMPLES $ gsheet worksheet:rename --spreadsheetId= --worksheetTitle= --newWorksheetTitle= Worksheet "" successfully renamed to "" ``` _See code: [src/commands/worksheet/rename.ts](https://github.com/jroehl/google-sheet-cli/blob/master/src/commands/worksheet/rename.ts)_