Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Google Form output to remote MySQL database

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.

like image 883
bob Avatar asked Feb 22 '15 07:02

bob


1 Answers

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.

like image 109
Hann Avatar answered Sep 24 '22 03:09

Hann