Google Sheets

gs_write_values

Write values to a range. Values are provided as a 2D array (rows of columns). By default uses USER_ENTERED input (formulas and formatting are parsed).

Remote node2flow/google-sheets

Other tools also called gs_write_values? See providers with this name

Input Schema


            {
  "type": "object",
  "properties": {
    "range": {
      "type": "string",
      "description": "A1 notation range to write to (e.g. \"Sheet1!A1:C3\")"
    },
    "values": {
      "type": "array",
      "items": {
        "type": "array",
        "items": {}
      },
      "description": "2D array of values. Each inner array is a row. Example: [[\"Name\",\"Age\"],[\"Alice\",30],[\"Bob\",25]]"
    },
    "spreadsheet_id": {
      "type": "string",
      "description": "The spreadsheet ID"
    },
    "value_input_option": {
      "type": "string",
      "description": "How input is interpreted: \"USER_ENTERED\" (default, parses formulas) or \"RAW\" (stored as-is)"
    }
  }
}