egghelp/eggheads community

solved

2021-06-08T20:24:53-04:00

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.

Statistics: Posted by haferbrei — Tue Jun 08, 2021 8:24 pm

2021-06-05T17:58:30-04:00

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

Statistics: Posted by haferbrei — Sat Jun 05, 2021 5:58 pm

2021-06-04T10:28:43-04:00

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

Statistics: Posted by ComputerTech — Fri Jun 04, 2021 10:28 am

2021-06-03T20:52:46-04:00

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

I found only this:

Code:

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

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

Statistics: Posted by haferbrei — Thu Jun 03, 2021 8:52 pm