actually using Google Script or using vba to automate excel to refresh a data connection?
the latter has been possible for a long time but i've always felt there is a lot of potential to make it better and less dependent on add-ins, powerquery, unsecured Sheets publishing, etc.
sorry, i looked at the mentioned link but didn't see the code?