a way to connect microsoft Excell (or Numbers) with Google Calendar - a date, or a task with a date, set on a spreadsheet to become an appointment in the google calendar.

Closed Posted Jan 23, 2013 Paid on delivery
Closed Paid on delivery

I manage several projects at the same time in a "Funnel Report". There are several steps for each project to get to completion. All of these steps depend on the Due Date of the project itself. I would like to "link" the dates from my Excell spreadsheet to the calendar - as appointments - to serve as reminders for each task needed for each job. I also have other people working with me so the google calendar I think is good, because email addresses can be added to each appointment to send invitations to other ppl.

I also need to have the flexibility to customize the spreadsheet in any way i need.

I envision that for each task I write for every job, to be able to have a "Link" button that can send the information directly as an appointment in google calendar.

Please see the attached numbers file as an example of how the funnel report looks like. What i need is whenever i set a task date for one of the projects to have an option question " make this a calendar appointment ?", if yes then to ask the hours of the day, invite email... and then to send all info into the google calendar...

"automatize" the excel spread sheet to create events into the calendar on its own as needed?

I my excel spreadsheet (funnel report) I have anywhere between 40-50 projects. each project has multiple steps of progress (different tasks, meetings with clients, additional information for clients, drawings and plans...)
For example if for one of the projects, project #1 i need to make myself a note, with a date and time, that i need to meet the client next week to finalize all details before production, can Excel send all the information to google calendar to create an appointment on its own? to include the date, the project name, reason for the meeting, invite client as well to the appointment by adding the email address? And then for project #3 i need I have a due date for drawings, If i punch in all my info in my funnel report, then I need excel to do his work and create that reminder on the calendar.

Let me know if you think its possible

Excel

Project ID: #4168757

About the project

7 proposals Remote project Active Mar 2, 2013

7 freelancers are bidding on average $108 for this job

SigmaVisual

I can help in your project, please check PMB and our ratings/reviews to get idea of our experience. Please let me know if you have any queries.

$199 USD in 5 days
(7 Reviews)
4.7
srinichal

I can deliver an automated solution for the project

$250 USD in 8 days
(3 Reviews)
4.4
cosconeaionut

Hi, I can do this in few hours. If you need me contact me.

$60 USD in 1 day
(6 Reviews)
3.6
amol9999

I am professional and experienced writer here available to undertake your project immediately. You will have detail bio and writing samples on PM.

$50 USD in 4 days
(0 Reviews)
0.0
lico19ls

i'm a home working housewife

$50 USD in 2 days
(0 Reviews)
0.0
dkumar041988

i can do this...

$50 USD in 3 days
(0 Reviews)
0.0
mawnch

I want to do this

$100 USD in 14 days
(0 Reviews)
0.0