egghelp.org community Forum Index
[ egghelp.org home | forum home ]
egghelp.org community
Discussion of eggdrop bots, shell accounts and tcl scripts.
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

google sheets api

 
Post new topic   Reply to topic    egghelp.org community Forum Index -> Scripting Help
View previous topic :: View next topic  
Author Message
haferbrei
Voice


Joined: 08 Apr 2020
Posts: 21

PostPosted: Thu Jun 03, 2021 8:52 pm    Post subject: google sheets api Reply with quote

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 Sad
Back to top
View user's profile Send private message
ComputerTech
Master


Joined: 22 Feb 2020
Posts: 374

PostPosted: Fri Jun 04, 2021 10:28 am    Post subject: Reply with quote

https://developers.google.com/sheets/api/quickstart/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
Back to top
View user's profile Send private message Send e-mail Visit poster's website
haferbrei
Voice


Joined: 08 Apr 2020
Posts: 21

PostPosted: Sat Jun 05, 2021 5:58 pm    Post subject: Reply with quote

I tried with the customsearch but I can only add web pages and not custom google sheets to the search.
Back to top
View user's profile Send private message
haferbrei
Voice


Joined: 08 Apr 2020
Posts: 21

PostPosted: Tue Jun 08, 2021 8:24 pm    Post subject: solved Reply with quote

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.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    egghelp.org community Forum Index -> Scripting Help All times are GMT - 4 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Forum hosting provided by Reverse.net

Powered by phpBB © 2001, 2005 phpBB Group
subGreen style by ktauber