Recently, I have been delving into Google Sheets formats. My approach involves utilizing fetch and tokens for writing data.
rows: [{
values: [
{
userEnteredValue: { numberValue: Math.round(new Date().getTime() / 1000) },
userEnteredFormat: {
numberFormat: {
type: 'DATE', pattern: 'ddd dd hh:mm'
}
}
}],
fields: 'userEnteredValue, userEnteredFormat'
}]
However, after posting the data, when I click on the cell, a calendar pops up displaying the time in epoch format instead of the correct format.