Skip to content

Instantly share code, notes, and snippets.

View beaudierman's full-sized avatar

Beau Dierman beaudierman

View GitHub Profile
@beaudierman
beaudierman / Pull-and-Sync-Data-Between-Google-Doc-Spreadsheet-and-MySQL.gs
Created April 19, 2018 18:10
You can pull data from MySQL database to Google doc spreadsheet auto with just click of a button or scheduled time. This is great use for retrieving data in spreadsheet format.
// MySQL to Google Spreadsheet By Pradeep Bheron
// Support and contact at pradeepbheron.com
function myMySQLFetchData() {
var conn = Jdbc.getConnection('jdbc:mysql://127.0.0.1:3306/employee_db', 'username', 'pass'); // Change it as per your database credentials
var stmt = conn.createStatement();
var start = new Date(); // Get script starting time