I am using the following add-on to export chart data directly to my linked google sheet.
https://workspace.google.com/u/0/marketplace/app/amplitude_sync_to_drive_and_sheets/998012258772
The extension gives a interface that requires the user to ‘Refresh All’ charts data manually.
Can someone help me with a way to automate the ‘Refresh All’ button such that is syncs data after a set period of time? I was looking into ways to write a script in google sheets app script but couldn’t find a way.
I also really want this feature! It seems silly that everyone who wants to use the google sheet has to install the chrome extension so they can make sure they’ve clicked Refresh before trying to use it. If I could set up a daily auto-refresh, anyone would be able to use it and trust that the data is fresh.
Yes, this would be very helpful for us as well. Right now the extension is pretty inconvenient, so it largely goes unused. I’d love to be able to get more use out of it.
Mixpanel can do it, so I know it’s possible! https://docs.mixpanel.com/docs/tracking-methods/integrations/google-sheets#runs-and-syncs
If you don't have an Amplitude account, you can create an Amplitude Starter account for free and enjoy direct access to the Community via SSO. Create an Amplitude account. You can also create a Guest account below!
If you don't have an Amplitude account, you can create an Amplitude Starter account for free and enjoy direct access to the Community via SSO. Create an Amplitude account. Want to sign up as a guest? Create a Community account.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.