Import data to MT4 from Google spreadsheet file

Hello Developers,

I am writing an EA, I need it to read in some data that I have stored online in a Google Spreadsheet (.gsheet format). I want it to read the data every time a new row is added to the spreadsheet. I have a web link to the Google Spreadsheet, like this:

https://docs.google.com/spreadsheets/d/xyz...

Please could someone create me a solution to read the data into my EA.

Possible ideas I have had so far include:

1. Create an MQL script (or code to insert into my EA) to read the data directly from the location on my Google drive (though not sure this is possible because it is not .csv or .txt format)

2. Create some other script/program to run in windows and copy the data from Google drive to the MT4 sandbox Files folder and save as a .csv. This would need to happen every time to the spreadsheet is updated, or every few seconds. Once the file is in the MT4 Files folder as a .csv I can update my EA to read it from there.

3. Some other solution...

Is it possible to achieve this? Please get in touch if you have any ideas!

Thanks!