Google Sheets API: ValueInputOption

April 7, 2019
setValueInputOption

RAW: The values the user has entered will not be parsed and will be stored as-is.

USER_ENTERED: The values will be parsed as if the user typed them into the UI. Numbers will stay as numbers, but strings may be converted to numbers, dates, etc. following the same rules that are applied when entering text into a cell via the Google Sheets UI.

Source

NOTE: To make field to be intepreted as String, use valueInputOption=USER_ENTERED and append ' to the value (e.g. '2018-04-07)

This work is licensed under a
Creative Commons Attribution-NonCommercial 4.0 International License.