Scrape Gmail Messages for HTML Data in a table and PDF attachments - put into google sheets.

I have a dedicated gmail address that receives two types of messages - Sales Orders (PDF attachment) and Roast Reports (HTML Tabels) I need specific data in those two messages automatically scraped (can also be each morning at 6 AM) and brought into a google sheet. From there i will work with the data further.
Here are the data examples https://wise-cobweb-402.notion.site/Data-Examples-e09c4f6a05e34e018da817cbbfba623d