Is there a way to edit google sheets file using livecode?
Posted: Wed Apr 14, 2021 8:47 am
I have a google sheets file that I would like to edit using livecode, is it possible?
There is a LC plugin, mergGoogle, that allows google sheets manipulation.
I don't know if it is currently functioning, as it was deprecated by LC. The plugin is probably still available as an inclusion in LC. I think it only runs on mac and ios.
The source is archived in my github repo, if you want that: https://github.com/macMikey/merggoogle
You can also use Google's REST API. We wrote an entire library for another IDE that uses that API to manipulate google sheets and calendars. It is straightforward once you make the authentication (Oauth2) work.