Google Sheets Cleanup Automation

PHP, JavaScript, Visual Basic, Data Processing, Excel, Scripting, Data Analysis, Google Sheets, Automation, Data Management · II need help cleaning and automating a Google Sheets workbook. The work includes removing duplicate rows, fixing formatting issues, correcting incomplete or incorrect entries, and standardizing the data. I also need basic and conditional formulas for calculations, along with Google Apps Script automation so the cleanup rules can run automatically when new data is added. The final sheet should be clean, accurate, easy to use, and require minimal manual work.