search

mixpanel / sheets

🔄 integrate mixpanel with google sheets
3 stars 1 forks source link

Sync failing with "too many time-based triggers in this document" message #25

Closed kochajkiewicz closed 6 months ago

kochajkiewicz commented 6 months ago

Clicking "run" – one-time sync works well.

Clicking "sync" results in the following message:

Exception: This add-on has created too many time-based triggers in this document for this Google user account

I changed service accounts in that particular spreadsheet settings before trying to switch on sync again.

ak--47 commented 6 months ago

@kochajkiewicz thanks for writing in. this message occurs when too many syncs have been scheduled for single sheet...

if you go here: https://script.google.com/u/1/home/triggers

do you see a long list of triggers? (time based) if so, you may have to delete some of them.

a user may only have 30 triggers associated with a google account.

for the sheets extension, i would try pressing the delete button in the UI; this clears out any syncs associated with the document. as a last resort, you can uninstall and reinstall the extension.

closing for now, but reopen if you are still blocked.