Write data from Google Spreadsheet into MySQL without 3rd Party tool

You can write data from Google Spreadsheet into MySQL database auto with just click of a button or scheduled time. This is great use for retrieving data in spreadsheet format.

If you have read my Previous article “Pull and Sync Data Between Google Doc Spreadsheet and MySQL” Then you can skip below steps and get final scrip directly form link in Step 2.4.

Step 1: Create a spreadsheet within your Google Drive.

Step 2: Insert script in newly created spreadsheet.

Step 2.1: To insert the script in Google spreadsheet go to Tools > Script Editor.

Step 2.2: On opening script editor you will find a Google Apps Script pop-up Close it. (Old Screenshot Google might not ask now days)