I need a google sheets script expert
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
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