hi @Hans_Calvin i haven't used google sheets with retool before, but have done a lot of Apps Scripts though...
maybe you can calculate the value you want in a Transformer, then reference its value in the object for updating sheet value?
// Transformer gets updated count
return {{myComponent1.value}} + 1
// Sheets updates with new value
{
"gmv": {{myTransformer1.value}}
}