function myFunction() { var id="1RQqUH2b3QxgcSB1GFYGm92wcEPEj7g4v9KjDrcNd_js"; var ex1 = SpreadsheetApp.openById(id); var sheet = ex1.getSheetByName("data"); var sql = 'SELECT * FROM ' +"1sKBWKimoT7Xmd4xGH_guOR7oyx6FyOEK7W-Qkk3x"; var result = FusionTables.Query.sqlGet(sql, {hdrs: false}); if (result.rows) { r=result.rows; for(s=1;s<5;s++){ ab=r[s][1]; sheet.getRange(s, 1).setValue(ab); } } }