Will need skills with Excel, VBA and Google Calendar API
We use a spreadsheet to track our contracted projects. Among other things, the spreadsheet includes project start and end date and times. We also generate 'calendar event detail' using a simple formula (project name, project type, etc). Today we manually create Google calendar events for each project entry in the spreadsheet. We need to automate this process. The project scope is fairly limited:
Must Have: if a column has an 'x' in it, use the data in that row to 1) search the Google calendar to see if the event is already scheduled and 2) create or modify the Google calendar entry based on the data from the 3 columns in that row (date/time/event name)
Nice to have: Create an 'update spreadsheet' function to search a date range in Google Calendar and then populate 3 columns for each Google Calendar event that isn't in the excel spreadsheet
Be really neat: In addition to creating a calendar event in a master Google calendar, it would be great if a duplicate calendar event could be created for the individual associated with the event in their personal calendar.
Please specify if your bid includes 'Must Have', 'Nice to have', 'Be really neat'