Spreadsheet value updater

[sdk/google/spreadsheet/Spreadsheet value updater]

---

Writes data to a single range of a given spreadsheet. Example:

1. session Id receives "spreadsheet_session"@0

2. spreadsheet Id receives "1_ewweewweFileID"@0

3. update meta data receives { "range": "Sheet1!A1:B10"", "valueInputOption": "RAW" }@0

4. 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"

• spreadsheet Id: string

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

• update meta data:

  {"range": string, "valueInputOption": ("RAW" or "USER_ENTERED")}

  Receives the metadata of the update values. range: The A1 notation of the values to update. More: https://developers.google.com/sheets/api/guides/concepts valueInputOption: Determines how input data should be interpreted. More: https://developers.google.com/sheets/api/reference/rest/v4/ValueInputOption Example: { "range": "Sheet1!A1:B10"", "valueInputOption": "RAW" }

• values: any[][]

  Receives the new cell values to update. It contains arrays of the row values. Example: [ ["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!"}