HTTP Google Sheets API v4 how to access without OAuth 2.0? : <p>my idea is to create a google sheet, make it public and then access it from my work computer linux/bash to read/write values on a daily basis.  </p>

<p>i have a public google doc sheet that anyone can find/edit.
this is the sheet ID: <code>1F6jh6756xNDlDYIvZm_3TrXb59EFEFHGEC7jdWz-Nx0</code>  </p>

<p>doing it by the book <a href="https://developers.google.com/sheets/api/samples/reading" rel="noreferrer">https://developers.google.com/sheets/api/samples/reading</a>  </p>

<p><code>curl 'https://sheets.googleapis.com/v4/spreadsheets/1F6jh6756xNDlDYIvZm_3TrXb59EFEFHGEC7jdWz-Nx0/values/Sheet1!A1:A3'</code></p>

<p>returns:  </p>

<pre><code>{
  "error": {
  "code": 403,
  "message": "The request is missing a valid API key.",
  "status": "PERMISSION_DENIED"
  }
}
</code></pre>

<p>i've read a lot and especialy here <a href="https://stackoverflow.com/questions/44750946/google-sheet-api-v4">Google Sheet API v4</a> i've found a complicated solution. that is if you want to access your public sheet in a short 1 hour period.  </p>

<p>you browse to <a href="https://developers.google.com/oauthplayground/" rel="noreferrer">https://developers.google.com/oauthplayground/</a> get authorization for the v4 api, then get "Authorization code", then get "Refresh token", and finally "Access token".  </p>

<p>using this "Access token" you can access the public sheet like this<br>
<code>curl 'https://sheets.googleapis.com/v4/spreadsheets/1F6jh6756xNDlDYIvZm_3TrXb59EFEFHGEC7jdWz-Nx0/values/Sheet1!A1:A3' -H "Authorization: Bearer ya29.GlvaBLjrTdsSuSllr3u2nAiC-BOsjvIOE1x5afU3xiafB-FTOdLWDtfabuIMGF1rId5BsZxiTXxrx7VDEtxww4Q1uvW9zRndkfm3I2LZnT1HK2nTWzX_6oXu-NAG"</code>  </p>

<p>returns:  </p>

<pre><code>{
  "range": "Sheet1!A1:A3",
  "majorDimension": "ROWS",
  "values": [
        [
      "a1"
    ],
    [
      "a2"
    ],
    [
      "a3"
    ]
  ]
}
</code></pre>

<p>perfect. in theory the "Access token" expires after an hour, the "Refresh token" never expires. so you would save the tokens, try to read the sheet with the "Access token", if it fails use the "Refresh token" to gain a new "Access token" and carry on.</p>

<p>but, i've had a dozen of "Refresh token"s that were redeemed/expired, "Authorization code"s expired, all in all nothing works after a few hours. why?</p>

<p>how can i access my google sheet form bash with curl without this kind of authorization?
especially since my sheet is public and can be edited by anyone with a browser.</p>

<p>is there another way to do this with some other permanent authorization?
why not use email and pass?</p>

<p>"API key" is mentioned but never explained. can some one please explain this method step by step?</p>
