Webhook -> Google Sheet wrong comission

I’m receiving the commission amount via webhook, but it comes without formatting, without a comma. The value comes 4122, the right value is 41.22 when I play it for the google sheet without a comma it turns 4122.00… How can I solve this?

This is funny but you can handle it like this;

  1. Use Replace function to remove the Comma.

  2. Divide it by 100 (do it in the destination field where you are mapping it)

Like this:

1 Like