My app doesn't refresh sheets data when modified through the app

It seems you have empty columns in your spreadsheet, which confuses Glide. Please try removing those, that should fix the reloading issues.