topic Re: Importing a Gsheet in Discussions

Importing a Gsheet

D_Meakin — Sat, 10 Jun 2023 23:58:57 GMT

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

Re: Importing a Gsheet

jthi — Fri, 23 Dec 2022 06:34:59 GMT

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))
);

Re: Importing a Gsheet

D_Meakin — Wed, 28 Dec 2022 22:45:16 GMT

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.