Accessing Excel files from Google Drive

[CodeforBros]

First, I apologize if this question has been answered elsewhere but I have exhausted my search efforts and still have nothing to show.

My aim is to export an excel file from a google drive account in order to view and change the excel file, then upload the new, edited file back into my google drive.
My problem is that I am very green and have yet to find material on 1.how to connect to a google drive account and 2.how to utilize an excel document inside my stack.
Any help would be appreciated, if I have posted in the wrong area, please let me know.

Thank you, and long live LiveCode!

[CodeforBros]

After some more investigation I know I will need to use google api code in order to get into GoogleDrive, but once I am able to access the doc, should I convert it to an SQL doc or should i continue to edit it in .xcl?

[Mark]

Hi,

If you are planning to move from a Google-based system to a MySQL-based system then you should convert your data and, also, design a completely new database. However, I don't think this is what you have in mind. Once you are able to talk to the Google API from LiveCode, you probably have all the tools you need to continue to use Google Drive and there is no need to switch to a database platform.

Kind regards,

Mark

[Adrien Bron]

That sounds good