Automate Ajio Sales Google Sheet Updating

I keep a master Google Sheet that tracks my Ajio store’s performance, and I want it refreshed every single day without manual copy-paste work. Each morning I download a fresh CSV export from Ajio; your job is to take that file and push three key data points into the sheet—Total sales, Product categories, and Customer details—so the dashboard always shows the latest numbers.

I’m happy to drag the CSV into Drive or place it in a designated folder; from there an Apps Script, Make.com scenario, or any clean approach you prefer can ingest the file, map the columns correctly, and append or overwrite yesterday’s figures. I do need basic validation: required columns must never be blank and obvious typos (e.g., text in a numeric column) should be flagged so the sheet doesn’t break downstream formulas.

Please deliver a working Google Sheet with the import routine wired up, clear field mapping, and short instructions so I can rerun or tweak it later. If you’ve automated CSV-to-Sheet flows before, especially in Google Apps Script, that’s exactly the experience I’m after.