mixpanel / sheets

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

Sync feature stop working after a while #11

Open raffa-elk opened 1 year ago

raffa-elk commented 1 year ago

Hello,

We we were able to properly set the import Mixpanel --> Sheets very easily and one-off sync worked smoothly.

However, when switching from "run" to recurring "sync", I noticed that after a while the hourly sync put on hold. And the way to resume the sync is forcing a manual "Sync Now!" in the extension menu.

Here a screen recording to better report the issue: https://www.screencast.com/t/NaBAbYXinj3

Is there any way to avoid that the sync goes into sleep mode? Is this a bug or potential issue on our end (e.g. with API calling)? Is there any alternative way to trigger the function behind the "Sync Now!"

Thank you in advance for any idea to solve this.

Best

ak--47 commented 1 year ago

hey @raffa-elk thanks for writing in.

i'm looking at your event stream and i see syncs running with no errors over the last few days.... is this resolved? syncs

we can't touch your syncs, but you can see your active triggers and executions here: https://script.google.com/home/triggers

do you see any execution errors there?

raffa-elk commented 1 year ago

Hello

Thanks for getting back to me and better investigating the issue.

I currently have 6 sheets syncing from Mixpanel to 6 different google sheets.

The success rate is 50% (3 yes and 3 not syncing).

See here: https://www.screencast.com/t/t0XGszw68

I checked the Triggers but I am not able to link each trigger with each of the 6 sheets (see below)

Any suggestions?

Thanks R

image

On Wed, 31 May 2023 at 16:58, AK @.***> wrote:

hey @raffa-elk https://github.com/raffa-elk thanks for writing in.

i'm looking at your event stream and i see syncs running with no errors over the last few days.... is this resolved? [image: syncs] https://user-images.githubusercontent.com/3978760/242317787-c8bacf9b-fdbc-4680-b500-f98a6f767e6d.png

we can't touch your syncs, but you can see your active triggers and executions here: https://script.google.com/home/triggers

do you see any execution errors there?

— Reply to this email directly, view it on GitHub https://github.com/mixpanel/sheets/issues/11#issuecomment-1570400212, or unsubscribe https://github.com/notifications/unsubscribe-auth/BAABNUKRWOKTTMSEJ7KGTHTXI5MANANCNFSM6AAAAAAYJQZNK4 . You are receiving this because you were mentioned.Message ID: @.***>

kdvkalash05 commented 1 year ago

@raffa-elk I am facing the same problem. Has this been resolved?