I have roughly 14,000 order-confirmation emails stored in Google Workspace. They span several years and multiple storefront systems, so the HTML changes over time—from early custom layouts to the more recent standard Shopify template. I can hand over the entire archive as one or more .mbox files. Your task is to parse each message, identify the relevant blocks no matter the template, and push the results into a single, tidy spreadsheet (CSV or Google Sheet) that I can sort and filter easily. Every row should represent one order and include: • Customer details: name, contact information, shipping address, billing address, and an VAT / CVR number and EAN number (if relevant) • Order details: products purchased (one cell per SKU or Product name, item product and total amount spent, and the order date Accuracy is critical, since this data will feed directly into our analytics. Deliverables 1. The final spreadsheet containing every parsed order I’ll test by spot-checking a sample of orders against the original emails; if everything lines up, we’re done.