Skip to main content

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.

 

This is the error, and it was the 9 that appeared. Then on 10 and 11 I don't get any errors, however the bot stops when inserting information.

--------------------------------------------

Level:warning

Date:9 Jan 2025, 14:04 (UTC -03:00)

Description: 5 or more requests exceeded Google API limit and will be throttled and executed later.

Type:Google Sheet Integration

Subscriber:-

--------------------------------------------

 

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?
 

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.

 

This is the error, and it was the 9 that appeared. Then on 10 and 11 I don't get any errors, however the bot stops when inserting information.

 

Level:warning

Date:9 Jan 2025, 14:04 (UTC -03:00)

Description:5 or more requests exceeded Google API limit and will be throttled and executed later.

Type:Google Sheet Integration

Subscriber:-

 

 

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?
 

I have the same problem! Someone have an explanation? 😪

I had this issue with one of the accounts I was managing. Tried diffrent things like delaying the actions steps so it doesn’t reach the request limit but unfortunately the problem still exists.

Are other tools or even other Manychat automations/ accounts using the same Google Account?

I'm asking this, because the request limitation applies for the whole account, not just one automation.

 

Anyway, if this is not the case, I recommend opening a ticket to the Support Team at Manychat Help

 

Hope it gets resolved! 🙌

Hey ​@CM La Plata if you’re just inserting data and not reading in your flow, then you may consider doing the Google Sheets updates async.

Here’s how this works:

In your main flow, when you want to update a row, instead of using an Action with the Update Row, you simply add a tag.

Then you create a new flow, that triggers when the user gets tagged. And this new flow has one action, to update the Google Sheet.

With this setup your main flow (the one talking to the user) isn’t waiting for the Google Sheet action to finish. It just tags the user and follows along.

The other flow (triggered by the tag) will take care of adding info to the GS. If there are delays, they’re on that specific flow - which only does this specific action and is completely disconnected from your main flow and the user conversation.

You’ll basically have both automations running in parallel, and with that you’ll be able to avoid issues in the conversations.

Reply


Community Terms & ConditionsCookie settings