title: Insert data range from Google Sheets to MySQL
body: <p>I'm trying to create a function that takes a data range/specified range in my Google spreadsheet and inserts every row that isn't blank into a MySQL table. 
  I want to take column range A:V in "Sheet One" and insert them to the "mysql_table" table. I'm new to using JDBC google scripts and below is what I've come up with so far, but I can't get it to work with my current knowledge.</p>
  
  <pre><code>function putData() {
  
     var conn = Jdbc.getConnection(dbUrl, user, userPwd);
    conn.setAutoCommit(false);
  
     var ss = SpreadsheetApp.getActiveSpreadsheet(),
        sheet = ss.getSheetByName("Sheet One"),
         range = sheet.getDataRange(),
        values = range.getValues(),
        row;
  
    var start = new Date();
   function writeManyRecords() { 
    for (var r=1; r&lt;values.length; r++) {
      if( values[r].join('') === '' ) return 'Blank row encountered'; 
  
      row = values[r]; 
      var i = 0;
    var stmt = conn.prepareStatement('INSERT INTO mysql_table '
        + '(field1, field2, field3, field4, field5, field6, field7, field8, field9, field10, field11, field12, field13, field14, field15, field16, field17, field18, field19, field20, field21, field22) values (' + start + row[i] + ')');
     stmt.addBatch();
  
  
  
    var batch = stmt.executeBatch();
    conn.commit();
    conn.close();  
  
  
    var end = new Date();
    }
   }
  }
  </code></pre>
  
  <p>Anyone have any ideas on how I can achieve this?</p>