Authenticated spreadsheet value updater

[sdk/google/spreadsheet/Authenticated spreadsheet value updater]

---

Authenticates the service user and updates dedicated spreadsheet. Example:

1. session Id receives "spreadsheet_session"@0

2. auth data receives { "email": "[e-mail]", "key": "TopSecretKey!" }@0

3. spreadsheet Id "1_ewweewweFileID"@0

4. update data receives { "update meta data": { "range": "Sheet1!A1:B10" }, "values": [ ["A1 value", "B1 value"], ["A2 value", "B2 value"] ] }}@0

5. done sends null@0

---

Keywords: google, drive, authentication, sdk, spreadsheet, update

Input ports

• session Id: string

  Receives the session id of the spreadsheet action. Example: "spreadsheet_session"

• auth data: {"email": string, "key": string}

  Receives the authentication data of service account. Example: { "email": "[e-mail]", "key": "TopSecretKey!" }

• spreadsheet Id: string

  Receives the id of the spreadsheet to be updated. Example: "1_ewweewweFileID"

• update data:

  {"update meta data": {string: any}, "values": any[][]}

  { "update meta data": { "range": "Sheet1!A1:B10" }, "values": [ ["A1 value", "B1 value"], ["A2 value", "B2 value"] ] }

Output ports

• done: null

  Sends null if the action was successful. Example: null

• error: {"error": string}

  Sends the error which happened during the execution of the action. Example:. {error: "Something went wrong!"}