Google Cloud SQL Query in Sheets App Script

googleCloudSql_query_sheets_appscript.js

function connectToCloudSQL() {
  
  var params = {
    ip: "INSERT IP",
    user: "INSERT USER",
    password: "INSERT PASSWORD",
    database: "INSERT DATABASE"
  }
  
  var dbUrl = 'jdbc:mysql://' + params.ip + '/' + params.database;
  var conn = Jdbc.getConnection(dbUrl, params.user, params.password);
  
  var stmt = conn.createStatement();
  var sql = "desc mytable"; //WRITE YOUR QUERY HERE
  
  stmt.setMaxRows(100);
  
  var results = stmt.executeQuery(sql);
  var mapping = {};
  
  var doc = SpreadsheetApp.getActiveSpreadsheet();
  var cell = doc.getRange('a2');
  var row = 0;
  while (results.next()) {
    for (var col = 0; col < results.getMetaData().getColumnCount(); col++) {
      cell.offset(row, col).setValue(results.getString(col + 1));
    }
    row++;
  }

  
  while (results.next()) {
    Logger.log(results.getString(1));
    Logger.log(results.getString(2));
    Logger.log(results.getString(3));
    
  }
    
  results.close();
  stmt.close();
  
}