Capability Sources

Append rows after a Google Sheets table found in a bounded range; inserts rows, RAW by default

Changed on

Uses the calling member's selected Google account. Perform mutations only when explicitly requested; selecting or discovering a connector does not authorize a write. Do not automatically retry an uncertain mutation.

post/v1/capabilities/google-workspace/spreadsheets/{spreadsheetId}/values/append

Request

  • Base URL
    https://api.openworklabs.com
  • URL
    https://api.openworklabs.com/v1/capabilities/google-workspace/spreadsheets/{spreadsheetId}/values/append
  • Auth
    • API key in header x-api-key
    • or HTTP bearer

Path parameters

spreadsheetIdstring required

Request body

rangestring required
valueInputOption'RAW' | 'USER_ENTERED'

RAW stores strings literally, including =formulas. USER_ENTERED parses formulas/dates and can execute formulas or fetch external data; requires explicit approval via confirmUserEntered.

confirmUserEnteredboolean

Response

Google-confirmed result.

oktrue required
spreadsheetIdstring required
updatedRangestring required
updatedRowsnumber required
updatedColumnsnumber required
updatedCellsnumber required
valueInputOption'RAW' | 'USER_ENTERED'

RAW stores strings literally, including =formulas. USER_ENTERED parses formulas/dates and can execute formulas or fetch external data; requires explicit approval via confirmUserEntered.

tableRangestring required

Changes

  • c93387179b31Revision changes
    • info

      response property details/items/path/items/ list-of-types was narrowed by removing types number from media type application/json of response 400

  • df3754993784Revision changes
    • info

      added the optional property to the response with the status