Hey samliew,
I appreciate your help. In between I happened to find a workaround that was practically free in terms of ops usage.
I did HTML to text parsing on make.com, exported the output to Google Sheets and did all the regex extraction with the =REGEXEXTRACT formula in Google Sheets.
Wishing you a nice rest of your day.