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.
