title: New Google Spreadsheets publish limitation
body: <p>I am testing the new Google Spreadsheets as there is a new feature I really need: the 200 sheets limit has been lifted (more info here: <a href="https://support.google.com/drive/answer/3541068">https://support.google.com/drive/answer/3541068</a>).</p>
  
  <p>However, I can't publish a spreadsheet to CSV like you can in the old version. I go to 'File>Publish to the web' and there is no more options to publish 'all sheets' or certain sheets and you can't specify cell ranges to publish to CSV etc.</p>
  
  <p>This limitation is not mentioned in the published 'Unsupported Features' documentation found at: <a href="https://support.google.com/drive/answer/3543688">https://support.google.com/drive/answer/3543688</a></p>
  
  <p>Is there some other way this gets enabled or has it in fact been left out of the new version?</p>
  
  <p>My use case is: we retrieve Bigquery results into the spreadsheets, we publish the sheets as a CSV automatically using the "publish automatically on update" feature which then produces the CSV URL which gets placed into charting tools that read the CSV URL to generate the visuals.</p>
  
  <p>Does anyone know how to do this?</p>