Get data from Google Forms into MYSQL

פרויקט מס' 68285

Job Statistics

8 Bids
תקציב
תקציב לא ידוע
תוקף הפרויקט
דקות
טווח הצעות
80 ₪ - 150 ₪ לשעת עבודה
15,000 ₪ - 15,000 ₪ מחיר קבוע
הצעה ממוצעת
128 ₪ לשעת עבודה
15,000 ₪ מחיר קבוע

Job Info And Actions

תאריך פרסום: 19:52, 6 פברואר, 2015
הצעות תתקבלנה עד: 21:53, 18 מרץ, 2015
Get data from Google Forms into MYSQL
Freelancers please note.. we will accept only responses that actualy say if you can do it how much time and how you plan to attack it.
any reponses that contain your company profile and other marketing non relevant data will not be responded.
so get your tech guys respond and lets do some Action together!

here is how we characterize this solution and its open to discussion if you think you have a better way to accomplish the goal:

Goal:
User submit form on google forms → Forms is saved on google sheet → sync google sheet data to MY SQL Server
Sync process is executed on the server side = Server connect to Google sheets
Once user submit the form, call an event to trigger the sync from MYSQL side.
Optional build out
Setup MYSQL DB table with exact same columns as the Google sheet has.
the first column in that table will be called id and will be auto increased and a Key
setup web service that can receive event and trigger the sync operation
when user submit a form.. google form trigger an event to the web service (this can be done through the script API google form has)
once event triggered web service call the script or operation that initiate the sync
Compile a script or other operation that authenticate and connect to specific sheet on a Google spreadsheet - Query the data in spreadsheet “MYFORM” on sheet forms responses 1
i.e.
Spreadsheet name: MYFORM
Sheet name: Forms Responses 1
get the new rows that was not synched
if there is not option to get the latest updated or new rows.. you may need to keep a record of last known row number on sheet
Compare the number of rows on spreadsheet with number of rows in MYSQL DB table (based on the id column referred above)
Add new row into MYSQL table.
be able to find / alert / fix mismatch such as:
when rows deleted in Google sheets but not from the MYSQL table (ignore)
if script or operation is failed, send an email alert and continue to try
possible failures are when google forms page is not responding or gives error page (403 etc.)
once script was able to connect and complete the operation successfully send another email notification Success.
the script should be run in minimum time (should be configured) i.e.
if script is set to run every minimum 3 minutes.
if google forms triggered the web service 5 times in 1 minute do not execute 5 times.. execute on the 3 minutes window
if there is not triggers within 10 minutes the operation is not executed at all
for more detail explanation: the trigger should be able to execute the operation of sync but within a 3 minutes window.. if there 10 triggers in a minute do not execute 10 times.. but only once in the 3 minutes windows
the 3 minutes windows is reset every time an operation starts/
handle several row data in one operation (not a row by row sync… bulk sync and insert)

קבצי הפרויקט

הלקוח

עדכונים

Private Bid

הצעה פרטית
9 פרויקטים
הצעה מס' 907151
הוגש: 8 מרץ 2015

Private Bid

הצעה פרטית
3 פרויקטים
הצעה מס' 901244
הוגש: 24 פברואר 2015

Private Bid

הצעה פרטית
22 פרויקטים
הצעה מס' 889565
הוגש: 9 פברואר 2015

Private Bid

הצעה פרטית
2 פרויקטים
הצעה מס' 889299
הוגש: 8 פברואר 2015

Private Bid

הצעה פרטית
2 פרויקטים
הצעה מס' 889238
הוגש: 8 פברואר 2015