search

mixpanel / sheets

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

No Sync Option #26

Closed pbtaffi closed 6 months ago

pbtaffi commented 6 months ago

Hi,

The import once (run) worked as expected when connected to my google workspace but there is no sync option. I need to sync the google sheet to my mixpanel account periodically. I'm on a paid plan of mixpanel.

Screenshot 2024-03-04 at 12 05 16

Please help. Thank you.

ak--47 commented 6 months ago

@fashionado

events are immutable, so syncs are not support for events.

you can sync profiles + groups, but not events.

pbtaffi commented 6 months ago

ok @ak--47 . Is there a way for me to periodically push newly added rows from a google sheet to mixpanel whenever google sheet is updated ?

I do see a sync option under the extension menu. If I click on it, will it sync only the new data or will create duplicate events for the old data too ? Screenshot 2024-03-04 at 17 57 10

Thank you.

ak--47 commented 5 months ago

@fashionado it will not created duplicate events provided you give an $insert_id with your data (which is like a row identifier)

https://developer.mixpanel.com/reference/import-events#propertiesinsert_id