Cleaning up numbers from Google Sheets, to insert into Make

How To
, ,
1

Hi. I have a scenario to take data from Google Sheets, and update it in Airtable. I’ve noticed that fields formatted as currency in google sheets, get passed on to Make say €100.55. This value failes in AirTable, as it expects just 100.55. Same for anything with a percentage, you get the value from Google Sheets as say 15.6%, while AirTable then expects it as 0.156.

Is there an easy way to normalise such values, without having to change the Google Sheet formatting?

1 Like
2

Hello,

You could just try the parseNumber() function. It will take input and return the number portion of it, with the specified separate as a decimal separator.

This should be fine if you know what kind of data to expect. If you don’t know exactly what’s coming, might need to use an if() or switch() function.

Input:
image

Functions:
image

Output:
image

3 Likes