I am building my Manychat bot with a lot of effort.
People communicate via WhatsApp and I connect it to Google Sheet to collect the data. As soon as they communicate, I do the first insertion of the data. Then during the flow I update it 3 times. There are no more than 15 columns.
Manychat says on its website that up to 150 requests can be made to the Google Sheet API per minute. I'm pretty sure I don't get over that. However, the messages from my bot to the user stop.
In the "LOGS" part I found 3 warnings from Google Sheet that I had exceeded the limit. But that was yesterday. I did not find any more error messages, however the same thing keeps happening, when inserting or updating the data the bot stops for about 3 to 8 minutes, and then resumes. If I take out the insert data action in Google Sheets, my flow works normally, so the problem is due to that.
Has this happened to you, any recommendations?
Or maybe someone can explain to me how requests to Google Sheet are counted? Does it count 1 request if I update 5 fields at the same time? Or since there are 5 fields, does it count as 5 requests?