title: Python reading a public google spreadsheet with no share option
body: <p>Can I read a google spreadsheet which is open to people, but doesn't have a <code>share</code> option? There's a discussion <a href="https://stackoverflow.com/questions/34399729/python-reading-a-google-spreadsheet">here</a>, but it's I need to have an authorization to click the <code>share</code> option.</p>
  
  <p>Even copying by URL to my own Google spreadsheet may serve the purpose.</p>
  
  <h3>Update:</h3>
  
  <p>The idea was once I create a Google API, I should be able to create a .json file with a client email. In the share option, I'm supposed to provide the client email of .json file. You may see: <a href="https://towardsdatascience.com/accessing-google-spreadsheet-data-using-python-90a5bc214fd2" rel="nofollow noreferrer">Accessing Google Spreadsheet Data using Python</a>.</p>
  
  <p>This is the spreadsheet page where I'm not finding any Share option: <a href="https://docs.google.com/spreadsheets/d/e/2PACX-1vSc_2y5N0I67wDU38DjDh35IZSIS30rQf7_NYZhtYYGU1jJYT6_kDx4YpF-qw0LSlGsBYP8pqM_a1Pd/pubhtml#" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/d/e/2PACX-1vSc_2y5N0I67wDU38DjDh35IZSIS30rQf7_NYZhtYYGU1jJYT6_kDx4YpF-qw0LSlGsBYP8pqM_a1Pd/pubhtml#</a></p>