Sync CSV Reviews to Sheet

I need an automated workflow that pulls the latest customer review data from several CSV files and updates a master Google Sheet. The CSVs already contain every field I care about—customer names, review ratings, and feedback comments—so the job is purely about moving that data quickly and reliably into the sheet without manual copy-paste.

Here’s what has to happen:

• Script (Apps Script or Python + Google Sheets API) reads one or more CSV files stored locally or in Drive and appends or overwrites rows in the target sheet.
• Columns in the sheet must match the three data points exactly: Name, Rating, Comment.
• The process should be re-usable—either one-click inside the spreadsheet or a small command-line trigger—so I can run it whenever new CSVs arrive.
• Error handling: duplicate rows should not be created, and any malformed lines in a CSV must be skipped with a clear note or log.

Acceptance criteria: when the script runs, the Google Sheet shows all customer names, ratings, and comments from every CSV provided, with no duplicates and the columns perfectly aligned.

Share the finished script, brief setup instructions, and a short example log so I can confirm everything works end-to-end.