I need a google sheets script expert

Job ID: 33360253

Budget: $30 – $50 USD

I am trying to build a live leaderboard using the importhtml function. I have set a trigger to run every 1 minute and the trigger appears to be working but the data isn't updating. However, when I manually run the script the data refreshes and updates. Need help getting the trigger to correctly work.

Leaderboard is located on Leaderboard & Payouts tab. Cell formula is located in cell K8. Script is under Google Appscript.

https://docs.google.com/spreadsheets/d/1nma66PjypEE7kSAl7V74yLyd-wDohCbzAPSofErR32A/edit#gid=499877542