'Google Sheets API. How to return result as a cell data only?
I'm complete newbie.
I have a 3rd party bot that can use APIs. The bot can understand links only. So I've made a link https://sheets.googleapis.com/v4/spreadsheets/(my spreadsheetID)/values/A12?key=(My key). But it returns me a lot of unnecessary info { "range": "'Sheet1'!A12", "majorDimension": "ROWS", "values": [ [ "My text is here" ] ]} And I want my bot to show me just "My text is here". Can I do that?
I tried to search. As I found, only parameters are majorDimension, valueRenderOption, dateTimeRenderOption. None of it gets rid of my problem. And other search results are with some coding, that my bot can't understand. Is there no way?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|