Is there a way to edit google sheets file using livecode?

Creating desktop or client-server database solutions?

Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller

Post Reply
Guyd
Posts: 3
Joined: Fri Apr 09, 2021 11:23 am

Is there a way to edit google sheets file using livecode?

Post by Guyd » Wed Apr 14, 2021 8:47 am

I have a google sheets file that I would like to edit using livecode, is it possible?

Mikey
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 755
Joined: Fri Jun 27, 2008 9:00 pm

Re: Is there a way to edit google sheets file using livecode?

Post by Mikey » Wed Apr 14, 2021 2:35 pm

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.

Post Reply

Return to “Databases”