I require a Google Apps Script to send calendar invites via email based on data imported into a google spreadsheet.
1. Import Data from a .csv file located in google drive, or users file system. CSV file will contain: name, email address, Start Date, Start Time, Description, plus others to be determined.
2. All column's included in the .CSV file need to be available as data fields for the email message.
3. Email customised message to recipients including calendar invite.
4. Ability to include interactive google map of location in the email.