Daily CSV to Google Sheet

I keep a master Google Sheet that records each day’s sales and purchase activity. Every evening a fresh CSV is placed in a shared cloud folder (Google Drive/Dropbox link). I need a small automation that, on a set schedule, pulls the newest CSV, runs a few sanity checks, and then injects the cleaned data into the correct tab of my Google Sheet.

The checks I rely on are simple but critical:
• flag and skip duplicate rows
• confirm each column’s data type matches the sheet’s format (dates, numbers, text)
• catch any missing values and log them for review

If the file passes these validations, the script should append or update the sheet seamlessly; if not, it should create a clear error report—an email or a separate “Errors” tab is fine.

A Google Apps Script that lives inside the spreadsheet would be ideal, but I’m open to a lightweight Python or Node solution that uses the Google Sheets API if that’s faster for you to maintain. What matters is that the update runs hands-free every day and I can trace any issues quickly.

Please set up the code, schedule the trigger, and provide brief instructions so I can tweak the cloud-folder link or sheet ID later on.