I receive an HTML file as an attachment to an email. Sometimes it is accompanied by other PDF files, but I only want to parse and extract data from the HTML File. When I open the file in the browser it looks like this.

I want to extract: Line number, Description, Maker Ref (if any) and Qty. To do so, I:
- I poll GMAIL
- Filter by attachment Mime Type text/html.
- Upload to Drive (extra step) to see that this file looks good.

- I can either try the Formatter by Zapier or AI by Zapier, or both in succession

AI by Zapier does not recognise the Attchamnet


What can I do to successfully read this HTML FILE?


