4. Append GMail Message Details to Sheet

POST {{baseUrl}}/v4/spreadsheets/:spreadsheetId/values/{{range}}:append?valueInputOption={{valueInputOption}}&insertDataOption={{insertDataOption}}&includeValuesInResponse={{includeValuesInResponse}}&responseValueRenderOption={{responseValueRenderOption}}&responseDateTimeRenderOption={{responseDateTimeRenderOption}}&access_token={{accessToken}}&alt={{alt}}&callback={{callback}}&fields={{fields}}&key={{key}}&oauth_token={{oauthToken}}&prettyPrint={{prettyPrint}}&quotaUser={{quotaUser}}&upload_protocol={{uploadProtocol}}&uploadType={{uploadType}}&$.xgafv={{.Xgafv}}

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 Params

HEADERS

RESPONSES

status: OK