Transformation is not working when source is google sheets

It was not working because all fields coming from spreadsheet are by default string.
For any operation, you’ll have to convert them to the correct type.
After converting those fields to number, things started working.

2 Likes