Google sheet reader not extracting numbers, just strings

Hi all,

I’m new to Knime and already loving it’s potential!

I’m trying to use it connect to google sheets and extract, elaborate and write data (a lot of it are numbers).

My issue is that even with a simple google sheets I’m not able to have the node Google Sheets Reader directly recognize and interpret data as numbers.

I ditched the Italian number formatting and I created a basic sheet as a test case just made of three simple columns with number formatted in US/UK convention like the image attached, but the reader node just recognizes everything as string.

How can I make it properly recognize number and avoid tedious and convoluted stuff afterwards to transform data?