Email Scraper — 3PL Stock Updates

2020 · BeautifulSoup, Gmail API, Python, openpyxl

---

Problem

The logistics partner sent stock updates via email in HTML format — tables embedded in the email body. The operations team would manually copy these into Excel, once per warehouse, for multiple warehouses. It was time-consuming, error-prone, and done repeatedly across teams in different countries.

---

Solution

A local application with a single button. On click: authenticate with Gmail, find the relevant emails, parse the HTML tables with BeautifulSoup, format the data, and write it to a structured Excel file — one sheet per warehouse, correctly formatted for the operations workflow.

No server, no infrastructure, no maintenance overhead. Just a button that replaces 20 minutes of copy-paste.

---

Architecture

---

Impact & Scale

• Time savings and quality improvements for daily operations workflows
• Presented to operations managers in Singapore, Australia, US, and the Netherlands
• Helped integrate the tool into each team's local workflow