function myFunction() { var id="1bUL-tGD-BzGsKD6nj9oa-Oq7Rml9miLlRcXT4Xvojng"; var ex1 = SpreadsheetApp.openById(id); var sheet = ex1.getSheetByName("data"); var sql = 'SELECT * FROM ' +"15s2geLPfvIyz5HWDE-pS9AwrwMkP3bD-kC8w2y-x"; var result = FusionTables.Query.sqlGet(sql, {hdrs: false}); if (result.rows) { r=result.rows; ab=r[0][0]; sheet.getRange(1, 1).setValue(ab) } }