This is the new home of the egghelp.org community forum.
All data has been migrated (including user logins/passwords) to a new phpBB version.


For more information, see this announcement post. Click the X in the top right-corner of this box to dismiss this message.

google sheets api

Help for those learning Tcl or writing their own scripts.
Post Reply
h
haferbrei
Voice
Posts: 23
Joined: Wed Apr 08, 2020 8:57 pm

google sheets api

Post by 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 :-(
User avatar
ComputerTech
Master
Posts: 399
Joined: Sat Feb 22, 2020 10:29 am
Contact:

Post by 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 :wink:
ComputerTech
h
haferbrei
Voice
Posts: 23
Joined: Wed Apr 08, 2020 8:57 pm

Post by haferbrei »

I tried with the customsearch but I can only add web pages and not custom google sheets to the search.
h
haferbrei
Voice
Posts: 23
Joined: Wed Apr 08, 2020 8:57 pm

solved

Post by 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.
Post Reply