function myFunction() { var id="1SAZJKC_9hEsz9y9ehaohTtYDzFctLiGi4rKS62XTFlQ"; 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(1, 1).setValue(ab) }
