I need a small automation that watches my Gmail inbox, opens each new message that contains an online order, pulls the relevant details out of the email body, and drops them straight into a Google Sheet in neat, column-by-column form. My emails arrive in a consistent template, so once the script identifies an order it should parse fields such as order number, customer name, items, quantity, price, and date. Those values then need to be written to the next empty row of a Sheet I’ll provide, with each field in its own column (true tabular format). A lightweight Google Apps Script would fit perfectly because it can live inside the Sheet, run on a time-based trigger, and keep everything inside the Google workspace. If you have another proven approach—Zapier, Make, or similar—that meets the same goal while keeping the Sheet updated in near real time, I’m open to suggestions. Key acceptance points • Only the body content is parsed; subject and sender aren’t required. • Order information must appear in clearly separated columns, not a single cell or JSON blob. • No manual action after setup: once deployed, new orders flow in automatically. Please let me know how you plan to tackle the parsing logic and roughly how long setup will take once you have access to a sample email and the destination Sheet.