Google Sheets

gs_read_values

Read cell values from a range using A1 notation (e.g. "Sheet1!A1:C10", "A1:Z", "Sheet1"). Returns a 2D array of values.

Remote node2flow/google-sheets

Other tools also called gs_read_values? See providers with this name

Input Schema


            {
  "type": "object",
  "properties": {
    "range": {
      "type": "string",
      "description": "A1 notation range (e.g. \"Sheet1!A1:C10\", \"Sheet1\", \"A:C\")"
    },
    "spreadsheet_id": {
      "type": "string",
      "description": "The spreadsheet ID"
    },
    "major_dimension": {
      "type": "string",
      "description": "How values are organized: \"ROWS\" (default) or \"COLUMNS\""
    },
    "value_render_option": {
      "type": "string",
      "description": "How values are rendered: \"FORMATTED_VALUE\" (default), \"UNFORMATTED_VALUE\", \"FORMULA\""
    },
    "date_time_render_option": {
      "type": "string",
      "description": "How dates are rendered: \"SERIAL_NUMBER\" or \"FORMATTED_STRING\" (default)"
    }
  }
}