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!

We are somewhat puzzled by the current state of the the site: there is a huge amount of bugs!!!

As we understand it: our project is not visible on the portal. We tried to apply to the Support, but no answer yet.

Good developers, we are waiting for your offers! Thx!

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

Näytä lisää: google spreadsheet database backend, question manager, java notification, google. docs, good c vs, generic data access, docs. google, timesheets, t-sql with, spreadsheet google, google sheets api, google google docs, google docs is, 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

Tietoa työnantajasta:
( 0 arvostelua ) Germany

Projektin tunnus: #1708657

5 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% 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 [url removed, login to view] give me a chance.

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