1

I have a designed a form in sheets. When a row in Column M is edited, I want to automatically send an email to a specific email address - [email protected].

The email layout looks like this:

To: [email protected] cc: (Column Z Value) Subject: (Column A Value) & " - " & " (Column C Value)

Hi (Column M Value)

Please look at this.

"TITLE - " & Column C

"DATE RECEIVED - " & Column D

"FROM - " & Column E

Sample data snapshot

An example of a completed email

Code tried but only does half the job

Improve this question
7
  • 1
    Welcome. This is not an uncommon question, and there are many answers on webapps and also StackOverflow. The solution requires a Apps Script and though you are new to all this, you will have to develop some apps scripts if only to implement an answer. This Google guide is a good place to start.
    – Tedinoz
    Commented Dec 29, 2020 at 11:56
  • 1
    Sorry - also meant to mention that Google has some Apps Tutorials including one on "Sending emails from a Spreadsheet"
    – Tedinoz
    Commented Dec 29, 2020 at 12:04
  • 1
    Does this answer your question? Send email when theres a change in a particular column on a particular sheet
    – Tedinoz
    Commented Dec 29, 2020 at 12:14
  • Oops - "develop some apps scripts"- meant to say "develop some apps skills". In any event, if you are really new to this, let me know and we will try and help you build an answer.
    – Tedinoz
    Commented Dec 29, 2020 at 12:16
  • HiI have had an initial go, from what I can find on the web. Unfortunately, it only does half the job I want it to...
    – surk
    Commented Dec 30, 2020 at 8:56

0

Reset to default

Browse other questions tagged or ask your own question.