Yes, I'm using an SSRS subscription to export the excel file. The problem is that SSRS exports it badly for some reason and the only way I can get it to convert to a Google Sheet is by opening the file first and saving it back, which I shouldn't have to do manually if I can open it and save it back through my little executable or through a TSQL Script. ALL that's necessary for the Excel export to be compatible with Google Sheets is to open the file and save it, which the executable does perfectly. I just can't get the executable to run from the Agent no matter what I do and I don't know why.
Have you tried what I suggested with SSIS - using a Script Task as the means of running that VBScript code ? You might have to make small changes to make it work, and you'll want to also set all those object variables to Nothing at the end of the script.