I'd like someone to write a Google App Script to do the following : I have a flight confirmation from United Airlines (there are multiple passengers with multi-hop flight). Upon receipt of such an email, I'd like to do the following : for each flight, for each passenger, send a calendar invite to that passenger for the duration of the flight. The email address of a passengers is available in the Google Spreadsheet. Extra credit if you can do a proximity match between the name of the passenger in the email and his/her actual full names (emails sometimes truncate the name etc). Emails from United Airlines are HTML formatted so you can basically DOM parse them. Extra credit if you can make the template of the invite configurable (E.g. I should be able to specify the fields I want to be sent as a the *description* of the invite in another column in the spreadsheet e.g. Confirmation Number, Or Gate Number etc). For someone who knows Google App Scripts, this should be less than an hour of work. You need to show it working on a test email.
Hello,
I understood the initial scope of this project.
Although i want to discuss further this job in order to
prepare the final concept for this project.
After Complete discussion over the call or in chat, i
will prepare following things for you
- Technical Project Proposal
- Flow chart for this Project
- Execution plan (Step by step procedure with explanation how and at what that we are going to execute a particular task)