google sheets api

[haferbrei]

Have any of you used TCL to search a Google Sheet for a string via Google api?

I found only this:

Code: Select all

POST https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/developerMetadata:search

I would like to query this via tcl, but I am getting nowhere

[ComputerTech]

https://developers.google.com/sheets/ap ... art/python

^ Although python, it will help give you a idea of how it works.


http://forum.egghelp.org/viewtopic.php?t=20947

^ My Google search script which uses Google custom search API Key, "May" give you a idea of how google API's work

[haferbrei]

I tried with the customsearch but I can only add web pages and not custom google sheets to the search.

[haferbrei]

I have not found a search function in the api.
So I download the sheet as json and then do a simple search in the text file.