Google Sheets Cleanup Automation

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.