Google Sheets OMG Microservice

An OMG service for Google Sheets, it is for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized analogs of paper accounting worksheets.

Direct usage in Storyscript:

Create Spreadsheet

google-sheets createSpreadsheet title:'Spreadsheet title' emailAddress:'email address for drive permission' role:'role of access' type:'type of access'

Find Spreadsheet

google-sheets findSpreadsheet spreadsheetId:'Spreadsheet Id'

Add Sheet

google-sheets addSheet spreadsheetId:'Spreadsheet Id' sheetTitle:'Sheet title'

Find Sheet

google-sheets findSheet spreadsheetId:'Spreadsheet Id' sheetTitle:'Sheet title'

Update Sheet Size

google-sheets updateSheetSize spreadsheetId:'Spreadsheet Id' sheetId:'Sheet Id' row:1 column:2

Update Cell

google-sheets updateCell spreadsheetId:'Spreadsheet Id' sheetTitle:'Sheet title' cellNumber:'A1' content:'any content'

Delete Sheet

google-sheets deleteSheet spreadsheetId:'Spreadsheet Id' sheetId:'sheet Id'

Subscribe Sheet

google-sheets listener newRowUpdate spreadsheetID:'Spreadsheet Id' sheetTitle:'sheet title'

Curious to learn more?

✨🍰✨

Usage with OMG CLI

Create Spreadsheet

$ omg run createSpreadsheet -a title=<SPREADSHEET_TITLE> -a emailAddress=<EMAIL_ADDRESS> -a role=<ROLE_OF_ACCESS> -a type=<TYPE_OF_ACCESS> -e CREDENTIAL_JSON=<BASE64_DATA_OF_CREDENTIAL_JSON_FILE>

Find Spreadsheet

$ omg run findSpreadsheet -a spreadsheetId=<SPREADSHEET_ID> -e CREDENTIAL_JSON=<BASE64_DATA_OF_CREDENTIAL_JSON_FILE>

Add Sheet

$ omg run addSheet -a spreadsheetId=<SPREADSHEET_ID> -a sheetTitle=<SHEET_TITLE> -e CREDENTIAL_JSON=<BASE64_DATA_OF_CREDENTIAL_JSON_FILE>

Find Sheet

$ omg run findSheet -a spreadsheetId=<SPREADSHEET_ID> -a sheetTitle=<SHEET_TITLE> -e CREDENTIAL_JSON=<BASE64_DATA_OF_CREDENTIAL_JSON_FILE>

Update Sheet Size

$ omg run updateSheetSize -a spreadsheetId=<SPREADSHEET_ID> -a sheetId=<SHEET_ID> -a row=<ROW_LENGTH> -a column=<COLUMN_LENGTH> -e CREDENTIAL_JSON=<BASE64_DATA_OF_CREDENTIAL_JSON_FILE>

Update Cell

$ omg run updateCell -a spreadsheetId=<SPREADSHEET_ID> -a sheetTitle=<SHEET_TITLE> -a cellNumber=<CELL_NUMBER> -a content=<CELL_CONTENT> -e CREDENTIAL_JSON=<BASE64_DATA_OF_CREDENTIAL_JSON_FILE>

Delete Sheet

$ omg run deleteSheet -a spreadsheetId=<SPREADSHEET_ID> -a sheetId=<SHEET_ID> -e CREDENTIAL_JSON=<BASE64_DATA_OF_CREDENTIAL_JSON_FILE>

Subscribe Sheet

omg subscribe listener newRowUpdate -a spreadsheetID=<SPREADSHEET_ID> -a sheetTitle=<SHEET_TITLE> -e CREDENTIAL_JSON=<BASE64_DATA_OF_CREDENTIAL_JSON_FILE>

Note: the OMG CLI requires Docker to be installed.

License

MIT License.