Google Script To notify with an email to multiple recipients with cell values in tabular formate
What this script does: This script will get the recent changes from the google sheet and will send to multiple recipients given with the data that is entered in the sheet. Simply the last row is targeted and fetched and sent to recipients with the headers in a table formate. Anyone can use this script and change the script names and manipulate the code to run on their google sheet. Instructions: 1. Open the sheet where you want to trigger this code. 2. Click on Tools - > Set notification rules -> shown in below image 3 3.Then save. 4. Again click on Tools -> select "script edtitor" and paste this whole script there. 5. Set the sheet name as your sheet name, and your email ids where you want the mail to be sent. 6. set the trigger when to fire this script select on resources - > current project Trigger and set it as shown in below image. If you want this should be fire on onEdit. you can set trigger as you want...
Comments
Post a Comment