Integration of Google Spreadsheets with Backend Systems

We have a number of processes running over Google Spreadsheets (relevant for the current project are timesheets, vacation planning sheets and expenses).

We now need to consolidate the whole data flow in a MySQL database that is communicated from a MS Access application. (Please note the definition of our constellation: "MySQL - MS Access"! It is a question of adding one more driver, but the discrepancies in terms of SQL syntax vs. MSSQL are at some points rather considerable).

The solution we need has to function over Google Docs API. There is a certain number of predefined functionality that we need:

- The data that is entered in the Google Spreadsheet has to be validated vs. the MySQL data model, and the user working with Google Docs has to receive a notification:

a) the cells in the Google spreadsheets are colored red,

b) user receives an email on the errors she has committed,

c) if a user doesn't fill out the timesheet for the last 72 hours, she will receive a notification email,

d) if a user receives 3 notifications, a notification email is sent to her manager,


We have a lot of stuff to be included here. At the moment we would like to receive a quote on the above points.

Please describe the ways to implement the functionality above. We will not take into consideration any generic bids.

Good luck!

Taidot: Excel, Java, Microsoft Access, Visual Basic, Visual Basic for Apps

Näytä lisää: google spreadsheet database backend, question manager, java notification, generic data access, timesheets, spreadsheet google, google sheets api, good docs, sql integration, spreadsheets, spreadsheet api, java backend, google spreadsheets, google java api, google docs mysql, access google spreadsheet, google api java, access timesheet database, timesheet data access, spreadsheet timesheet, application integration project manager, fill data google spreadsheet, application integration google, access timesheets, java data integration

About the Employer:
( 0 reviews ) Germany

Projektin tunnus: #1708657

5 freelanceria on tarjonnut keskimäärin 1480 $ tähän työhön


Here is our bid according to your main project.

2400 $ USD 60 päivässä
(32 arvostelua)

################### ******************* WE HAVE DONE THE SAME APPLICATION PLEASE CHECK THE PM **************** #############

1000 $ USD 10 päivässä
(3 arvostelua)

Hi, I have nearly 10 years experience with PHP, MySql & SQL based Database processing. Also I am working with Google APIs. I can start your project, I want more details about your project. Please reply via a PM.

1000 $ USD 10 päivässä
(2 arvostelua)

Custom software development - <b><i>Removed by Admin</i></b>

1500 $ USD 1 päivässä
(0 arvostelua)

I am having a good experience in different field .worked for 7 years for different part of the globe now setting my own firm . you will definately like my work. Give me this opportunity to develop your web page so eve Lisää

1200 $ USD 20 päivässä
(0 arvostelua)

Dear Sir, I am expert in vb and writing Macro. I can do easily.please give me a chance.

1300 $ USD 20 päivässä
(0 arvostelua)