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

POST

Appends values to a spreadsheet. The input range is used to search for existing data and find a "table" within that range. Values will be appended to the next row of the table, starting with the first column of the table. See the guide and sample code for specific details of how tables are detected and data is appended. The caller must specify the spreadsheet ID, range, and a valueInputOption. The valueInputOption only controls how the input data will be added to the sheet (column-wise or row-wise), it does not influence what cell the data starts being written to.

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 POST 'https://sheets.googleapis.com//v4/spreadsheets//values/:append' \
--header 'Content-Type: application/json' \
--data-raw '{
    "majorDimension": "DIMENSION_UNSPECIFIED",
    "range": "string",
    "values": [
        [
            null
        ]
    ]
}'

Response Example

{
    "spreadsheetId": "string",
    "tableRange": "string",
    "updates": {
        "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}:clear