Thanks for the feedback, I wasn't aware that UA was still available for historical data until next year. It would be a lot of work to add back the old connector and have them in parallell, so I recommend that you download an older version of SeoTools and add it via the Add-ins menu temporarily (disable new version first) when you need old UA data:
https://releases.seotoolsforexcel.com/SeoTools_64_v9.7.4.0_20230512.zip
https://releases.seotoolsforexcel.com/SeoTools_32_v9.7.4.0_20230512.zip
Download the appropriate version above. Let me know if you need help adding the files via the Add-ins menu.