accounts = [["test", 1, 2, 3,], ["test1", 4, 5, 6], ["test2", 7, 8, 9]];
const response = Sheets.Spreadsheets.batchUpdate({
requests: [
{
updateCells: {
range:
{
sheetId: 0,
startRowIndex: 7,
endRowIndex: 10,
startColumnIndex: 13,
endColumnIndex: 17,
},
rows: accounts.map(e => ({ values: e.map(f => ({ userEnteredValue: (isNaN(f) || f == "" ? { stringValue: f } : { numberValue: f }) })) })),
fields: "userEnteredValue"
}
}
]
}, getID());
GoogleJsonResponseException: API call to sheets.spreadsheets.batchUpdate
failed with error: Invalid JSON payload received. Unknown name
"numberValue" at
'requests[4].update_cells.rows[2].values[2].user_entered_value': Proto
field is not repeating, cannot start list.
Invalid JSON payload received. Unknown name "numberValue" at
'requests[4].update_cells.rows[2].values[3].user_entered_value': Proto
field is not repeating, cannot start list.