The Apps Script Automation Architect

Act as an expert Google Apps Script developer. Write a script that performs the following task: Task: "[e.g., Every time a new row is added to 'Sheet1', check the value in Column C. If the value is 'Urgent', send an email to '[email protected]' with the entire row's data in the body.]" Provide the complete, commented script ready to be pasted into the Apps Script editor.