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. POST //sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values/{range}:append The URL uses gRPC Transcoding syntax. string The ID of the spreadsheet to update. string The A1 notation of a range to search for a logical table of data. Values are appended after the last row of the table. enum (ValueInputOption) How the input data should be interpreted. enum (InsertDataOption) How the input data should be inserted. boolean Determines if the update response should include the values of the cells that were appended. By default, responses do not include the updated values. enum (ValueRenderOption) Determines how values in the response should be rendered. The default render option is FORMATTED_VALUE. enum (DateTimeRenderOption) Determines how dates, times, and durations in the response should be rendered. This is ignored if responseValueRenderOption is FORMATTED_VALUE. The default dateTime render option is SERIAL_NUMBER. The request body contains an instance of ValueRange. If successful, the response body contains data with the following structure: The response when
updating a range of values in a spreadsheet. string The spreadsheet the updates were applied to. string The range (in A1 notation) of the table that values are being appended to (before the values were appended). Empty if no table was found. object (UpdateValuesResponse) Information about the updates that were applied. Requires one of the following OAuth scopes: For more information, see the OAuth 2.0 Overview. Determines how existing data is changed when new data is input.HTTP request
Path parameters
Parameters spreadsheetId
range
Query parameters
Parameters valueInputOption
insertDataOption
includeValuesInResponse
responseValueRenderOption
responseDateTimeRenderOption
Request body
Response body
JSON representation {
"spreadsheetId": string,
"tableRange": string,
"updates": {
object (UpdateValuesResponse)
}
}
Fields spreadsheetId
tableRange
updates
InsertDataOption
Enums OVERWRITE
The new data overwrites existing data in the areas it is written. (Note: adding data to the end of the sheet will still insert new rows or columns so the data can be written.)
INSERT_ROWS
Rows are inserted for the new data.
If you keep data in separate Google Sheets, copy a range of data from one spreadsheet to another with the IMPORTRANGE function. For example, you may track quarterly sales data for a product in a different spreadsheet for each region. To combine all that quarterly sales data, copy the data from each region's spreadsheet into a single spreadsheet using IMPORTRANGE. *Note: If you are in a Spanish-speaking country, use the semicolon as a separator instead of the comma. For example: To import cells A1 through C10
from sheet 1 of the abcd123abcd123 spreadsheet, you enter: =IMPORTRANGE("//docs.google.com/spreadsheets/d/abcd123abcd123", "sheet1!A1:C10") Was this helpful? How can we improve it?Use the IMPORTRANGE function