title: Fetch google sheets data and store into a data frame
body: <p>I have a link to the <a href="https://docs.google.com/spreadsheets/d/1M_S3iR5u7Ef5teNXWXVWH-EuokFNQ3Kd5dGt_T0YeH8/pubhtml" rel="nofollow noreferrer">Google sheets</a>:</p>
  
  <pre><code>https://docs.google.com/spreadsheets/d/1M_S3iR5u7Ef5teNXWXVWH-EuokFNQ3Kd5dGt_T0YeH8/pubhtml
  </code></pre>
  
  <p>I want to link this data directly with R and store it in a data frame .</p>
  
  <p>Tried many things shared on the internet but nothing worked at all .</p>
  
  <p>In fact here is the <a href="https://stackoverflow.com/questions/22873602/importing-data-into-r-from-google-spreadsheet">link</a> to the stackoverflow question, it is quite long and confusing and doesn't work in this case .</p>
  
  <p>Any ideas  ?</p>