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.