Home > Software engineering >  Sending an email whenever Google Sheets specific range is edited
Sending an email whenever Google Sheets specific range is edited

Time:09-11

I have a simple app script that will send an email whenever my G-sheet is edited. This works fine but it will send an email for every edit in any cell. So, I need to define a specific range as B3:E7 in my Gsheet and the email should trigger only after B3:E7 range is edited. No emails should send for other edits. Please help me on this. I took this code from this tutorial enter image description here

  • Related