/v4/spreadsheets/{spreadsheetId}/values/{range}

PUT

Sets values in a range of a spreadsheet. The caller must specify the spreadsheet ID, range, and a valueInputOption.

Request

Path Params

Query Params

Body Params application/json

Examples

Responses

🟢200Successful response

application/json

Body

Request Example

Shell

JavaScript

Java

Swift

curl --location --request PUT 'https://sheets.googleapis.com//v4/spreadsheets//values/' \
--header 'Content-Type: application/json' \
--data-raw '{
    "majorDimension": "DIMENSION_UNSPECIFIED",
    "range": "string",
    "values": [
        [
            null
        ]
    ]
}'

Response Example

{
    "spreadsheetId": "string",
    "updatedCells": 0,
    "updatedColumns": 0,
    "updatedData": {
        "majorDimension": "DIMENSION_UNSPECIFIED",
        "range": "string",
        "values": [
            [
                null
            ]
        ]
    },
    "updatedRange": "string",
    "updatedRows": 0
}

Modified at 2023-08-15 07:09:28

/v4/spreadsheets/{spreadsheetId}/values/{range}

/v4/spreadsheets/{spreadsheetId}/values/{range}:append