Reputation: 1
hellow guys, i have some problem here. I have an application that uses Google Sheet API requests for around 200 requests per second into 1 sheet. I use 5 service account credentials to work on 1 sheet. I have problems with my Google Sheet account service. so when (number 1 service account) has entered data into the range/rows. than another like (google service account 4) actually updates/changes the data into the range that has been filled in. instead of adding a new row after the data is filled in. This happens when write requests occur very quickly. How do I prevent the bot/Google service account from making changes/updates after the range/rows are filled in, but it will always add a new row after the row/range is filled in? this just do when hight traffic request, when low traffic apps run perfectly
this is example the problemexample image
Upvotes: 0
Views: 23