Format numbers to google sheet

[nivarz]

when i send this to google sheet

arrives this

leading zeros are lost

in the listviewer its ok

[TIMAI2]

Two ways to handle this:

1. Send your number with leading zeros as a string, not a number.
2. Format the column that holds these numbers (you may need to set the format for each new entry with your script).

If you use a number format on your google sheet, use displayValues in your script to return the values as they appear on the sheet.