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

Question

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.

Welcome to Stack Overflow. See How do I ask a good question? — doubleunary
– doubleunary, Commented Sep 6, 2024 at 7:27

doubleunary · Accepted Answer · 2024-09-06 07:25:22Z

0

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

See my sendEmailNotification script for sample code.

answered Sep 6, 2024 at 7:25

doubleunary

21.9k13 gold badges38 silver badges84 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

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

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related