title: Accessing the contents of a public Google Sheet as CSV using Requests (or other library)
body: <p>I wrote a small python program that works with data from a CSV file. I am tracking some numbers in a google sheet and I created the CSV file by downloading the google sheet. I am trying to find a way to have python read in the CSV file directly from google sheets, so that I do not have to download a new CSV when I update the spreadsheet.</p>
  
  <p>I see that the requests library may be able to handle this, but I'm having a hard time figuring it out. I've chosen not to try the google APIs because this way seems simpler as long as I don't mind making the sheet public to those with the link, which is fine.</p>
  
  <p>I've tried working with the requests documentation but I'm a novice programmer and I can't get it to read in as a CSV.</p>
  
  <p>This is how the data is currently taken into python:</p>
  
  <pre><code>file = open('data1.csv', newline='')
  reader = csv.reader(file)
  </code></pre>
  
  <p>I would like the <code>file = open()</code> to ideally be replaced by the requests library and pull directly from the spreadsheet.</p>