I have a Google Spreadsheet where I enter a row of data with any changes to my office schedule for the day. Is there a way to automatically email this row of data (not a link to the spreadsheet, but the actual row of data) to another person(s)?
Google-sheets – automatically email the row contents I enter in Google Sheets
google sheets
Related Topic
- Google-sheets – Google Spreadsheet partial row transpose and shift, partial row split
- Google-sheets – Quickly scroll to the last row with data in Google Sheets on a Mac
- Google-sheets – Can G Spreadsheet email notify me, which specific person edited the sheet
- Google Sheets – Fix Date and Time Formatting with Google Apps Script
Best Answer
You cannot send emails from the Google Sheet when an edit is made because the the onEdit trigger cannot call the MailApp service.
You can however save the edit in a queue through PropertyService and then use a time-based trigger to flush the queue and send the content via email.