Automate Daily Product Sales Summary

Every evening I export raw product-sales numbers and drop them into a spreadsheet, but I still have to add formulas and tidy up the view by hand. I would like you to turn this into a simple, repeatable workflow that gives me one clean summary line per day showing:

• Total units sold
• Total revenue
• Average sale price

Please build the solution directly in Google Sheets or Excel—whichever you feel is faster—using formulas, pivot tables, or a small script if that keeps the file maintenance-free for me. All I want to do is paste the new day’s data (or let it sync from a CSV) and instantly see the updated daily summary. Deliver the finished sheet, the logic behind it clearly annotated, and a short set of instructions so I can keep it running without you.