STEP 1 — Understand the Request Your goal is clear: Automatically send an email notification whenever a new row is added to a Google Sheet. Before generating production-ready code, I need only one essential clarification because it changes how the script should work. Please answer these questions: How do you determine who should receive the email? A. A fixed email address (e.g. manager@company.com) B. The email address is stored in a column of the newly added row (Which column?) C. Something else How are new rows added? A. Users manually type into the sheet B. Google Form submissions C. Another Apps Script D. API / external system E. Other Once I have these two answers, I'll provide: ✅ A production-ready Google Apps Script ✅ Error handling and logging ✅ Configuration section ✅ Automatic trigger setup instructions ✅ Mermaid workflow diagram ✅ Deployment guide ✅ Beginner-friendly explanation ✅ Learning notes about triggers, Spreadsheet service, Mail service, and event objects ✅ Suggestions for future enhancements (HTML email, multiple recipients, conditional notifications, attachments, Slack/Teams integration, etc.) Please reply in this format, for example: 1. B — Column E contains the manager's email. 2. A — Users manually add rows. or 1. A — Send every notification to qa_manager@company.com 2. B — The sheet receives Google Form submissions. After that, I'll generate the complete production-ready solution following all 10 steps.