"Failure to submit to convention precedes success due to innovation"

Code Snippets (Google Apps Scripts)

Posted by Jeremy D. Stakich on January 20, 2016

Google Apps Scripts for Sheets and Google Apps

Here are some App Scripts I wrote that you can use behind a Google Sheet or in a Google App to interact with MySQL

Update one row of a MySQL Table with Google Apps Script
Here is the code on GitHub.

Update multiple rows of a MySQL Table with Google Apps Script
Here is the code on GitHub.

Insert one row of a MySQL Table with Google Apps Script
Here is the code on GitHub.

Insert multiple rows of a MySQL Table with Google Apps Script
Here is the code on GitHub.

Select MySQL data into a Google Sheet
Here is the code on GitHub.

Fill a Specific Google Sheet with MySQL data
Here is the code on GitHub.

Delete data from a MySQL database within a Google Sheet
Here is the code on GitHub.

Clear range within a Google Sheet
Here is the code on GitHub.

More to come.....

Photographs and ScreenShots by Jeremy Stakich.