Append to Google Sheets as Numeric


I’m trying to use the “google sheets updater” node to append records to a google sheet, which is working except that numbers and dates are being text-qualified (with an apostrophe added to the start). Any way I can prevent this from happening? It seems to work fine with the Excel Writer, just not having luck with the google sheet updater.

Thank you

Hi @jdubya

I think this thread/answer might solve your problem: Google API: Sheets updater saves values as strings - #5 by oole


Ah, perfect, thank you

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.