IssueTracker

Description

The Google Apps Script Sheets.newAppendCellsRequest() builder creates an object containing: rows, sheetId and fields. However, in Google Apps Script these are their own parameters. Also note that fields as defined by the property is not used in the append() method.

Sheets Spreadsheets Values Append documentation

Code

Sheets.Spreadsheets.Values.append(
  resource: Sheets_v4.Sheets.V4.Schema.ValueRange, 
  spreadsheetId: string, 
  range: string, 
  optionalArgs: Object
)

Suggestion

It is suggested that the methods query parameters: valueInputOption, insertDataOption, responseValueRenderOption and responseDateTimeRenderOption should replace the current properties along with any valid enumerator values for these parameters.

Adjacent issues.

The example for Append Values in the guides for the Sheets API also does not use the Sheets.newAppendCellsRequest() presumably for this reason. I report an issue on the GitHub page and report it after this (link will be in the reply)

I have reviewed the other possible duplicates and they do not accurately approximate this issue.