scriptbit 0 Posted April 1, 2017 Report Share Posted April 1, 2017 I need to pull data from a Google spreadsheet into Ubot and then paste it into Gmail to search. Can this even be done? I just checked the forums and I see hardly any information on any of you actually attempting this. Quote Link to post Share on other sites
HelloInsomnia 1103 Posted April 3, 2017 Report Share Posted April 3, 2017 I am sure this can be done. I wouldn't bother trying to get the data out of the sheet on Google though, instead try to download the file or get the data via the API and then use it. 1 Quote Link to post Share on other sites
scriptbit 0 Posted April 5, 2017 Author Report Share Posted April 5, 2017 Please tell me where I can learn how I can use Ubot to use the Google API to create a temporary sheet and then add, modify, delete, and pull data from this. I would highly appreciate this. Thank you. Quote Link to post Share on other sites
HelloInsomnia 1103 Posted April 5, 2017 Report Share Posted April 5, 2017 Please tell me where I can learn how I can use Ubot to use the Google API to create a temporary sheet and then add, modify, delete, and pull data from this. I would highly appreciate this. Thank you. You would have to read the API Docs, this should be where you start: https://developers.google.com/sheets/api/ Also, I'm guessing you would need to setup an App and API key the same way you do for their other APIs so that would be here: https://console.developers.google.com Quote Link to post Share on other sites
sheiku 1 Posted April 21, 2017 Report Share Posted April 21, 2017 Hi, i also try to work with google spreadsheet....but now chance..It constantly crashes in the Ubot browser.Finaly as a compromise i try to read the file in Autoit , pass the values to ubot and so on...but is so ...nasty. I do not know how to work with api s.. Any better method? Quote Link to post Share on other sites
jason 101 Posted April 22, 2017 Report Share Posted April 22, 2017 The Sheets API is a good idea Quote Link to post Share on other sites
sheiku 1 Posted April 24, 2017 Report Share Posted April 24, 2017 I agree that API is a very good idea, but i do not know how to use it.. Ubot was developed with the idea in mind that nonprogrammers will be able to use it...i resolved the problem using windows command in Ubot, a used shell to open firefox browser, clicked in url tab, entered the url of sheet, and after that i use extensively the keyboard event...tab, tab, Ctrl c...and store the values in clipboard, transfer them in variable ...and use them ....Not to elegant but it is working, Quote Link to post Share on other sites
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.