Notify team via email when new supplier is added in Google Sheets, and log details in another sheet

Notify your team via Gmail when a new supplier or contractor is added to your Google Sheets entry. Ensure all necessary information is communicated efficiently, improving collaboration and response times.