Closed

Calendar date exchange between Excel and Google Calendar

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'

Skills: Excel

See more: excel google calendar, populate google calendar spreadsheet, excel vba google calendar, api google calendar excel, using google spreadsheet, google calendar api excel, google calendar vba excel, google calendar excel, google excel spreadsheet, excel spreadsheet formula, end vba, master excel, vba projects, vba excel, spreadsheet api, modify calendar, exchange api, excel projects, excel function, excel formula, excel duplicate, excel automate, excel api vba, excel vba, date

About the Employer:
( 0 reviews ) louisville, United States

Project ID: #1115504

9 freelancers are bidding on average $145 for this job

mrbrave

Please See PMB for my solution details..

$160 USD in 2 days
(64 Reviews)
5.3
srinichal

I have experience with google API and can deliver the project asap

$180 USD in 4 days
(3 Reviews)
4.4
tamrakar81

Hi, I have gone through your requirement and I am glad that I can accomplish this task, Please give us an opportunity to work with you. Thanks, Tamrakar

$200 USD in 3 days
(13 Reviews)
4.3
ceejay21

Dear Hiring Manager, I was excited to read about your administrative job opening. I have several years of experience in a variety of fields such as accounting, finance, insurance and including Human resource and wri More

$100 USD in 5 days
(0 Reviews)
0.0
ashik00007

I can type fast and can do your work quickly and perfectly

$155 USD in 3 days
(0 Reviews)
0.0
Infinity25

Would You Like To Check Your PM Please ?

$100 USD in 5 days
(0 Reviews)
0.0
roktitu

I am ready to start this work

$140 USD in 10 days
(0 Reviews)
0.0
PremaJosephine

I have a pretty good hands on with VB, VBA, Microsoft technologies and Internet applications. MS Excel has/is been my daily routine. I can cover all the three options Must/Nice/Neat within the price that is quoted in More

$180 USD in 3 days
(0 Reviews)
0.0
sabihasultana

sir i am ready to start this work plz give me a chance thanks

$90 USD in 7 days
(0 Reviews)
0.0