Loading...
Plain webhook | Cenit Admin

Basic info

Namespace
Google Sheets API v4
Name
POST V4 Spreadsheets {spreadsheetid} Values {range}:append
Path
/v4/spreadsheets/{{spreadsheetId}}/values/{{range}}:append
Method
post
Description
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](/sheets/guides/values#appending_values) and [sample code](/sheets/samples/writing#append_values) 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.
Id
5b9c01bc25d98509ee00355e
Created at
September 14, 2018 18:45
Updated at
October 01, 2018 19:37

Parameters & Headers

Parameters
NameValueDescriptionUpdated at
access_token - OAuth access token.September 20, 2018 20:49
prettyPrinttrueReturns response with indentations and line breaks.September 20, 2018 20:49
key - API key. Your API key identifies your project and provides you with API access, quota, and reports. Required unless you provide an OAuth 2.0 token.September 20, 2018 20:49
quotaUser - Available to use for quota purposes for server-side applications. Can be any arbitrary string assigned to a user, but should not exceed 40 characters.September 20, 2018 20:49
pptruePretty-print response.September 20, 2018 20:49
fields - Selector specifying which fields to include in a partial response.September 20, 2018 20:49
altjsonData format for response.September 20, 2018 20:49
$.xgafv - V1 error format.September 20, 2018 20:49
callback - JSONPSeptember 20, 2018 20:49
oauth_token - OAuth 2.0 token for the current user.September 20, 2018 20:49
uploadType - Legacy upload protocol for media (e.g. "media", "multipart").September 20, 2018 20:49
bearer_token - OAuth bearer token.September 20, 2018 20:49
upload_protocol - Upload protocol for media (e.g. "raw", "multipart").September 20, 2018 20:49
valueInputOption - How the input data should be interpreted.September 20, 2018 20:49
insertDataOption - How the input data should be inserted.September 20, 2018 20:49
15 Parameters
Template parameters
NameValueDescriptionUpdated at
spreadsheetId - The ID of the spreadsheet to update.September 20, 2018 20:49
range - The A1 notation of a range to search for a logical table of data. Values will be appended after the last row of the table.September 20, 2018 20:49
2 Parameters