Format "Number" is not found in Google's data sheet

I used a Google Sheets API using Sheety. The data is converted to a JSON file. The secon collum is set to Numbers but when is try to use this Collum the data is seen as text.

Anybody have tips?

Hi @spiering.pluym :wave:

Sorry but I didn’t get it…

You are sending numbers and they are being saved as text in Google Sheets OR; You have numbers in Google Sheets and when you GET them into Bubble, they came as text?

So in Google Sheets I put them as a number. And also in the API in Bubble I changed the format of the collum to Number . Still the input file gives an error when I try to put it there as number / percentage.