I would like to have a Google Apps script in my account which checks a Google Spreadsheet file for certain data in a cell. There are dates in each cell in a certain column and the script should check if the current data is 1 day before the date in the cell. If it is 1 day before the one in the cell then the script should use the Google Mail api to send an email to an emailadress in our apps account with data from a cell next to the date (text field).
Please let me know if you can create this script which is a combination of a Google Spreadsheet function and Google Mail API.