Skip to main content

I have my google sheets integration and created a broadcast. I had this working before to export all my contact data but now it doesn’t work somehow. It says broadcast sent but no contacts are appearing on google sheets…

i’ve been trying for 2 days now… 

 

 

Hi, @alexdubois!

 

It's hard to say without seeing your automation/integration.

Do other automations with Google Sheets integration work? Maybe it's something with the integration. I would recommend to check it out.


You cannot send 5000+ contacts at once @alexdubois, you need to slow it down.

The Google Sheets integration has a throttling limit of 150 requests every 60 seconds - more details here: https://help.manychat.com/hc/en-us/articles/14281248811292-Google-Sheets-integration

 

If you send them all at once, Google Sheets will throttle you and most of the requests will not run.


You cannot send 5000+ contacts at once @alexdubois, you need to slow it down.

The Google Sheets integration has a throttling limit of 150 requests every 60 seconds - more details here: https://help.manychat.com/hc/en-us/articles/14281248811292-Google-Sheets-integration

 

If you send them all at once, Google Sheets will throttle you and most of the requests will not run.

 

👆 This!

 

You can still create a series of randomizers with smart delays to sort and send data to Google within the 150 requests per minute. It will look something like this monstrosity:

 


I read about this. then tested on small batches e.g. 5 users (manually selecting them via a tag) but it is still not exporting them to google sheets. 


 


I just tried exporting 5 users and keep getting such messages.. seems one of my previous exports is stuck on a loop trying to get them to google sheets?


i now disconnected google sheets and seems it keeps trying to send data

 


Give it some time to see if it ‘finishes’, and until then stop sending things to Google Sheets.

You can also open at ticket with support at https://help.manychat.com to see if they can stop it in the backend.


Reply