function myFunction() { id="1tVWgSievdx3ri9xJYeFtZHqoyppu7bQQtRXYrJi4"; var sql = 'SELECT ROWID FROM ' +id; sql =sql+ " WHERE a='d'"; var result = FusionTables.Query.sqlGet(sql); var r=result.rows; z=r[0][0]; Logger.log(r[0][0]); var upd = "update "+id+" set b = 824 where rowid ='"+z+"'"; FusionTables.Query.sql(upd); }