I am part of a large group of users that share a Google spreadsheet and would appreciate if anyone can help me figure a way to set up immediate notifications specifically only for when someone adds a new sheet to the spreadsheet.
I've tried setting up a notification rule through the sheet's tools for when any changes are made and when a new form is submitted but this will prove troublesome even with both the immediate email and daily digest email options as the spreadsheet is being shared by a large group who edit individual cells frequently in a day and also because the rules available currently will result in me receiving a throng of emails but I'm only interested in getting notifications (imperative for it to be immediate) from only two specific users in the group.
I do understand that it might be possible to write a script for this but I have no background or understanding of scripts and also I could not find a script for this in the Google script bank or the new add-ons feature. I have also done an intensive internet search on forums and backlog stack questions but to no avail. Would it also be possible to set notification email to be only sent to me personally and not anyone else on the list?
I hope I've been clear with my questions and would appreciate any help in this matter.