Google Sheets script to import JSON data via API with authentication automatically every 30 minutes

Hi, I need a custom Google Sheets script which would import JSON data via API with authentication automatically every 30 minutes. - data should be imported into a google spreadsheet (in a simple table format) - data should be queried automatically even if I don't have the spreadsheet open, and it should be queried every 30 minutes (more frequently is ok, less frequently is not ok) - the only data that needs to be imported is what is available via getBalance from [login to view URL] (requires authentication), documentation here: [login to view URL]) - every time the data is imported, a timestamp should be created - every time the data is imported, the old data should be overwritten Basically the purpose of the script is to always maintain an up-to-date copy of the CoinTracking balance in a google spreadsheet.