Relative Content

Tag Archive for google-sheetsgoogle-apps-scriptgmail-api

Google script to Pull Data Range of Emails into Gsheet

I have frankensteined this code a little, and it gets me 95% of what I want, but I can’t figure out how to have it pull just a specific date range. Right now it grabs the whole inbox, and I don’t need that each time I run it.

onEdit to send e-mail using Gmail

I am trying to write a script to send an E-mail, upon certain column gets edited on google spreadsheet.
its a vacation request (submitted by google forms), when an employee asks for a vacation, the google sheet checks his available balance, if its sufficient or not, if not sufficient i need to send an automated e-mail without interference from the user. and if sufficient balance is available then upon editing (droplist) i want to send e-mail with the result.
Here is the sheet :
https://docs.google.com/spreadsheets/d/18sLrOtzfFsdl0j74W7Iiym4Tg63cSFSWL94i148EA0E/edit?gid=1472164239#gid=1472164239
TAB (REQUESTS)
COLUMN k : the droplist
column S: is the final status whether the balance is sufficient or not , and if sufficient what is the response of the user (Admin) on the vacation.
column Q: subject of e-mail.
column R : body of e-mail.
column A: e-mail address.