For me, I had to add users (share) to the permissions part of my google sheet, so the data they were entering on the app was allowed to be modified on the google sheet. That fixed everything.