The bug with the “get value” and “get row object” was first reported over a year ago: Get value from Google Sheet not updating properly · Issue #1138 · thunkable/thunkable-issues · GitHub.
It’s frustrating that something so integral to using Thunkable is broken.