Google Form output to remote MySQL database

[bob via StackOverflow]

I have a Google Form I created. I have a website with a remote MySQL database. I would like to embed the Google Form into my site (this I've figured out), however instead of the data from form submission being stored in a Google Spreadsheet(s), I'd like the data to be sent to my MySQL database, to a predefined table designed to accept the data types being collected and validated for in the Google Form.

I have researched and come across Google Apps Scripts (https://developers.google.com/apps-script/guides/jdbc). My issue is that I'm not experienced with Google Apps Scripts and am seeking guidance in setting this up. I have the Google Form, access to a my Google Apps account, and the connection string to my remote MySQL database with administrator privileges. I'm seeking guidance, step-by-step as I have not found any tutorials online yet. If you can guide me to a tutorial, that would be appreciated as well.

Please DO NOT REPLY directly to this email but go to StackOverflow:
http://stackoverflow.com/questions/28655570/google-form-output-to-remote-mysql-database

[Hann via StackOverflow]

Recently you can use a database in Google app script. App script support ( Google Cloud SQL, MySQL, Microsoft SQL Server, and Oracle databases ) with JDBC Class

DOcumentation : https://developers.google.com/apps-script/guides/jdbc

You can add script in Google From.

Please DO NOT REPLY directly to this email but go to StackOverflow:

http://stackoverflow.com/questions/28655570/google-form-output-to-remote-mysql-database/28658705#28658705

[Sandy Good via StackOverflow]

It's possible to create a form that does not send responses to a linked spreadsheet. In the "RESPONSE" menu, choose "CHOOSE RESPONSE DESTINATION". You can create an installable 'Form Submit' trigger to run some code. In the code editor, choose RESOURCES, CURRENT PROJECT TRIGGERS, add a trigger, and set it to run when the form is submitted. Then you'll need to use get item responses:

Google documentation - Forms

Please DO NOT REPLY directly to this email but go to StackOverflow:

http://stackoverflow.com/questions/28655570/google-form-output-to-remote-mysql-database/28660434#28660434

[Andrew Roberts via StackOverflow]

Bruce McPherson offers some step-by-step guides on his site if you use his cDbAbstraction library to access any external DBs.

Please DO NOT REPLY directly to this email but go to StackOverflow:

http://stackoverflow.com/questions/28655570/google-form-output-to-remote-mysql-database/28684611#28684611