Google sheets: adding a row or inserting a cell in the command line

[alberto56]

No description provided.

[alberto56]

In https://github.com/alberto56/dcycle-suresh-kumara/issues/76 the PR dcycle/starterkit-node#59 which allows node starterkit to add rows and insert cells in google sheets.

Please provide the same functionality in the command line for https://github.com/dcycle/google-sheets-to-csv

Something like this:

GOOGLE_SHEETS_API_KEY={api_key}
GOOGLE_SHEETS_SPREADSHEET_ID={spread_sheet_id}
GOOGLE_SHEETS_SHEET_ID={sheet1}

./scripts/modify-cell-value.sh "$GOOGLE_SHEETS_API_KEY" "$GOOGLE_SHEETS_SPREADSHEET_ID" "$GOOGLE_SHEETS_SHEET_ID" B2 "new value"
./scripts/insert-rows-after-row.sh "$GOOGLE_SHEETS_API_KEY" "$GOOGLE_SHEETS_SPREADSHEET_ID" "$GOOGLE_SHEETS_SHEET_ID" 40 10 #insert 10 blank rows after row 40

The idea is to do it within Python, not Node, and in the command line from within a Jenkins job.