Importing a Gsheet

[#1]

Has anyone figured out how to import a gsheet from a google drive?

[#2]

One option could be to use Drive API's Files: export , you should be able to export it as xlsx by using correct MIME Type. Export seems seems to have 10MB limit.

Or use methods mentioned here https://www.labnol.org/internet/direct-links-for-google-drive/28356/#google-sheets---export-links 

This will most likely download the whole file but only open one sheet

Names Default To Here(1);

f = New HTTP Request(
	Method("GET"),
	URL("https://docs.google.com/spreadsheets/d/1FH3Y2-vRUgojntPkCSJI5Pd-15rsJ1a0SFCRaT-iqgo/export?format=xlsx")
) << send;

dt = Open(
	f,
	Worksheets("787 Status Snapshot"),
	Worksheet Settings(Headers Start on Row(1), Data Starts on Row(2))
);

[#3]

Jthi,

This solution worked in part. That is I could get it to work with a file for which I could get a URL. However when I use the Pick File function on Google Drive the URL it returns fails spectacularly, where as if I get the URL directly from Google browser address bar it works like a charm.