title: Importing data into R from google spreadsheet
body: <p>There seems to be a change in the google spreadsheet publishing options. It is no longer possible to publish to the web as csv or tab file (<a href="https://stackoverflow.com/questions/21189665/new-google-spreadsheets-publish-limitation">see this recent post</a>). Thus the usual way to use RCurl to import data into R from a google spreadsheed does not work anymore:</p>
  
  <pre><code>require(RCurl)
  u &lt;- "https://docs.google.com/spreadsheet/pub?hl=en_GB&amp;hl=en_GB&amp;key=0AmFzIcfgCzGFdHQ0eEU0MWZWV200RjgtTXVMY1NoQVE&amp;single=true&amp;gid=4&amp;output=csv"
  tc &lt;- getURL(u, ssl.verifypeer=FALSE)
  net &lt;- read.csv(textConnection(tc))
  </code></pre>
  
  <p>Does anyone have a work-around?</p>