I receive endorsement orders from my client as CSV files and would like the whole process—from upload to cost calculation for curtains—handled automatically inside Google Sheets. Here is what I have in mind: each time a new CSV arrives, the relevant fields should populate a dedicated Sheet, trigger cost formulas, and give me a clear summary of what the order will actually cost. Right now I only know that I need “the cost as per actual”; whether that ends up being a total, per-item, or discounted view can be settled once you look at the data and suggest the simplest approach. No complex data-prep rules are in place yet, so feel free to recommend any cleaning, validation, or re-formatting steps that will make the workflow bullet-proof. Google Apps Script, Python, Zapier, or any similar tool you trust is fine by me as long as the result is a single-click (or better, no-click) pipeline from incoming CSV to a neatly calculated Sheet. I’m happy to walk through a sample file and the curtain-pricing logic with you so we can lock down formulas and acceptance tests before you dive into the code. Once it’s running smoothly, a quick set of comments or lightweight documentation will be enough for me to maintain it.