c3cvv - 経済統計練習帳

function myFunction() {
 
 
 
    var id="1ywSowVwA5ZphlX2m4nxaVCGoNl0nslF-vgGMbv7L0hE";
 
 
 var ex1 = SpreadsheetApp.openById(id);
  var sheet = ex1.getSheetByName("data");
 
 
   var sql = 'SELECT * FROM ' +"1XFJfkFie3KDVBOf4yKG3achH1BUPlv9MAV5n2EbO";
 
  var result = FusionTables.Query.sqlGet(sql, {hdrs: false});
 
  if (result.rows) {
 
 
    r=result.rows;
 
    ab=r[0][0];
 
    sheet.getRange(2, 2).setValue(ab)
 
 
  }
 
 
}