I need a concise Google Apps Script—written in JavaScript—to super-charge one of my Google Sheets. The sheet currently relies on manual data entry and occasional copy-pastes from other systems, so the script must: • validate every row as it is added (type checks, mandatory-field checks, custom rules) and stop bad data in its tracks • pull and push information to external services through HTTP API calls; authentication tokens and endpoint details will be provided • keep a clean log (timestamp, user, action, status) and send email or in-sheet notifications whenever something goes wrong or when an integration finishes successfully Behind the scenes I expect the usual best practices—named functions, onEdit/onChange triggers, try/catch blocks with meaningful error messages, and a way to toggle verbose logging. When you deliver, please share: • a copy-of-the-sheet with the script attached • a brief install/run guide so I can deploy it in another spreadsheet • notes on any quotas or Advanced Service activations you had to enable If your solution meets the above and passes a quick test import to a second sheet, I’ll mark the project complete.