CODEWITHSUNDEEP
google-sheetsgoogle-apps-scriptgoogle-workspacebuild-automation
Alex Samples
Alex Samples

Reputation: 1

Automatically Send an Email from Google Sheets using Data in Sheet Cells

I have a Google Sheet with Data from a Google Form. I would like to make an Apps Script that when a certain cell is edited in the Sheet, Apps Script will send an email response from me to an email in the sheet and include the message I wrote in a Cell. I have tried a number of codes and seem to be striking out. I had used this in the past but can not get the code to successfully run this time around in the new data sheet.

Upvotes: 0

Views: 85

Answers (1)

doubleunary
doubleunary

Reputation: 18653

The function that sends email needs to run on an installable trigger rather than a simple trigger.

See my sendEmailNotification script for sample code.

Upvotes: 0

Related Questions