I need a simple Google app script that does the following thing:
* takes in an email sent to it and writes different things in columns A, B, C etc.
* Email can have some "tail" from prior conversations but contains only text, e.g. 3 lines, with text or dates or numbers, each line == string/number for column A, B, C etc.
* for all that rows generated that contain a "due date" (could be defined as column C), generate a calendar invite to a google calendar which contains the columns A,B,C etc. in the body and is a "full day" invite that shows the day as "free"
Party with friends, bring beer, 03/22/2016, 4pm, 6pm
Then create 3 different versions of this script, since I want to use it for 3 different purposes.
Have only 1 version have the calendar feature
Allow google spreadsheets table to have a header row that allows me to label columns
make sheet flexible, such that it could take in many columns, and that it activates the calendar function only if the sheet behind it has a column called "due date" which effectively activates this function
Ideally all of this gets collected in the same google spreadsheet but in different sheets.
allow me to duplicate the overall functionality so I can feed more than these 3 sheets in the future.