How to get the value of a cell through a query?

Question

Google Sheets

I have, for example, a table:
https://docs.google.com/spreadsheets/d/1d2UU5VcbgF...
How can I get the value of a certain cell through a GET / POST request? For example, B4?

Answer 1

GET https://sheets.googleapis.com/v4/spreadsheets/1d2UU5VcbgF6iDW58WA242BdIisRd7pqDoENm963YCcM/values/B4 HTTP/1.1

Authorization: Bearer [YOUR_ACCESS_TOKEN]
Accept: application/json

Where [YOUR_ACCESS_TOKEN]is the Google OAuth 2.0 token

Answer 2

As an option - make a script, publish as an application, specify the address of the book / sheet / range in the parameter. But perhaps there is an easier API access.