Please note that as of May 2014 there is still a known issue with accessing sheet names via api functions shown below - where it only returns the first sheet name. [1] If/when Google fixes the issue this method could be an easy solution.