Google API: Sheets updater saves values as strings

Hi @mw

It seems to be a problem with the option that is used to actually write the values into Google Sheets.

There are two options to write to Google Sheets (RAW and USER_ENTERED). RAW is the default and seems to cause the leading ’ problem.

The setting is not exposed in the node dialog, but you can change it using flow variables.

Here is an example workflow, that might solve the problem: google_sheets_change_variable_setting.knwf (12.6 KB)

11 Likes