tag:blogger.com,1999:blog-6799428426680372912.post6478239151093606314..comments2023-11-15T17:26:49.562+05:30Comments on iGoogleDrive: Google Spreadsheet Email Notification when cell contents is above certain valueKishhttp://www.blogger.com/profile/13751098853627072874noreply@blogger.comBlogger9125tag:blogger.com,1999:blog-6799428426680372912.post-75084691436086682102019-10-06T21:05:23.418+05:302019-10-06T21:05:23.418+05:30how to change the name of name that sends the emai...how to change the name of name that sends the email , tried from gmail when i sent email normally im getting the correct name when i sent thru script , im getting Chauzy instead of name i want to be usedAnonymoushttps://www.blogger.com/profile/03380804480792871965noreply@blogger.comtag:blogger.com,1999:blog-6799428426680372912.post-34494176229618116252019-05-14T20:41:35.108+05:302019-05-14T20:41:35.108+05:30Hi,
How we can get alert to an entire column chan...Hi,<br /> How we can get alert to an entire column change rather than just a specific cell and have it email the row numbers? <br />pankajhttps://www.blogger.com/profile/10172957481103246812noreply@blogger.comtag:blogger.com,1999:blog-6799428426680372912.post-28292125083281165392017-04-29T17:59:38.548+05:302017-04-29T17:59:38.548+05:30Spot on, mate! Saved my day!
function sendEmail(v...Spot on, mate! Saved my day!<br /><br />function sendEmail(value) {<br /><br /> MailApp.sendEmail({to: "address@company.com",<br /> subject: "Subject text " + value,<br /> name: "Google_Sheets_Alerter",<br /> replyTo: "noreply@company.com",<br /> htmlBody: "Alerter email Anonymoushttps://www.blogger.com/profile/18199545579421632928noreply@blogger.comtag:blogger.com,1999:blog-6799428426680372912.post-41698007916037101862016-05-15T22:18:28.152+05:302016-05-15T22:18:28.152+05:30Hi there is an error
"Script is using OAuthC...Hi there is an error<br /><br />"Script is using OAuthConfig which has been shut down. Learn more at <br />http://goo.gl/IwCSaV (line 13, file "Code")"<br /><br />Could you please update the script Razmik Badalyanhttps://www.blogger.com/profile/17618854293982249164noreply@blogger.comtag:blogger.com,1999:blog-6799428426680372912.post-5038505302030718912016-05-15T22:17:24.246+05:302016-05-15T22:17:24.246+05:30This comment has been removed by the author.Razmik Badalyanhttps://www.blogger.com/profile/17618854293982249164noreply@blogger.comtag:blogger.com,1999:blog-6799428426680372912.post-63470561376853251622016-02-02T05:20:22.742+05:302016-02-02T05:20:22.742+05:30I'd like to know this as well?I'd like to know this as well? <br />Anonymoushttps://www.blogger.com/profile/01564082415647722563noreply@blogger.comtag:blogger.com,1999:blog-6799428426680372912.post-80617658987189600582014-09-06T03:17:54.582+05:302014-09-06T03:17:54.582+05:30is there a way to apply this to an entire column r...is there a way to apply this to an entire column rather than just a specific cell and have it email the row numbers? <br />thank you wilburhttps://www.blogger.com/profile/16605977981020555491noreply@blogger.comtag:blogger.com,1999:blog-6799428426680372912.post-10096348687666171002014-06-17T03:18:19.108+05:302014-06-17T03:18:19.108+05:30Thank you Kishan,
I am just wondering if it is po...Thank you Kishan,<br /><br />I am just wondering if it is possible to do the following:<br /><br />Let say we have Column "B" as default values let say "1"<br /> So B1 = 1<br /> B2 = 3<br /> B3 = 1<br /> <br />and Column "A" is a Description Example<br /><br />A1 = "SALES" <br />A2 = "Purchase"<br />A3 = "IT"<br /><br />How Eduardo Orozco Mendozahttps://www.blogger.com/profile/06555030117274136583noreply@blogger.comtag:blogger.com,1999:blog-6799428426680372912.post-37432699333726939202014-05-19T10:01:04.062+05:302014-05-19T10:01:04.062+05:30Excellent article Kishan. Won't this email be...Excellent article Kishan. Won't this email be sent every minute as long as the value is greater than 50?Anonymoushttps://www.blogger.com/profile/11730264889304414253noreply@blogger.com