mailsheet | Send emails from Google Sheets | GCP library
kandi X-RAY | mailsheet Summary
kandi X-RAY | mailsheet Summary
MailSheet integrates with Google Workspace to provide a simple yet powerful email automation solution:.
Support
Quality
Security
License
Reuse
Top functions reviewed by kandi - BETA
Currently covering the most popular Java, JavaScript and Python libraries. See a Sample of mailsheet
mailsheet Key Features
mailsheet Examples and Code Snippets
Community Discussions
Trending Discussions on mailsheet
QUESTION
I’m running some Google Aps Script that intereracts with a Google sheet that extracts and compares some values as the sheet is updated and sends an email if certain criteria are exceeded. It has worked solidly for over a year but recently stopped and I’ve found the problem to be with the new Chrome V8 runtime environment. If I run the legacy java environment – it works, no problem.
The script looks for a condition whereby a threshold, set in the spreadsheet is exceeded – if so it should send an email. I have proven that the script identifies the threshold exceeded condition, that it can write and read values from the spreadsheet and that it can read and write the email address from a cell.
It seems that the MailApp.sendEmail(emailAddress, subject, message); doesn't work. Any suggestions greatly appreciated.
Script extract is as follows:
...ANSWER
Answered 2020-Apr-15 at 11:43I'm not familiar with Google Apps Script, but I can take a guess:
getValue
returns a single value, getValues
returns a two-dimensional array of values. In the line var emailAddress = emailRange.getValues()
, if you switch from the latter to the former, does that make it work?
Community Discussions, Code Snippets contain sources that include Stack Exchange Network
Vulnerabilities
No vulnerabilities reported
Install mailsheet
The complete setup takes 10 more minutes.
Support
Reuse Trending Solutions
Find, review, and download reusable Libraries, Code Snippets, Cloud APIs from over 650 million Knowledge Items
Find more librariesStay Updated
Subscribe to our newsletter for trending solutions and developer bootcamps
Share this Page