Skip to main content

Can someone helpt with issues exporting contacts to google sheets?

  • October 9, 2024
  • 8 replies
  • 86 views

alexdubois

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… 

 

 

8 replies

Fabio Gaulke
Forum|alt.badge.img+3
  • Manychat Community Moderator
  • October 9, 2024

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.


Gustavo Boregio
Forum|alt.badge.img+6
  • Manychat Community Moderator
  • October 9, 2024

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.


Fabio Gaulke
Forum|alt.badge.img+3
  • Manychat Community Moderator
  • October 9, 2024

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:

 


alexdubois
  • Author
  • Chat Surfer
  • October 9, 2024

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. 


alexdubois
  • Author
  • Chat Surfer
  • October 9, 2024

 


alexdubois
  • Author
  • Chat Surfer
  • October 9, 2024

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?


alexdubois
  • Author
  • Chat Surfer
  • October 9, 2024

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

 


Gustavo Boregio
Forum|alt.badge.img+6
  • Manychat Community Moderator
  • October 9, 2024

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.