search

dcycle / google-sheets-to-csv

0 stars 0 forks source link

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

Open alberto56 opened 1 week ago

alberto56 commented 1 week ago

In https://github.com/alberto56/dcycle-suresh-kumara/issues/76 the PR https://github.com/dcycle/starterkit-node/pull/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.