cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
The Discovery Summit 2025 Call for Content is open! Submit an abstract today to present at our premier analytics conference.
See how to use to use Text Explorer to glean valuable information from text data at April 25 webinar.
Choose Language Hide Translation Bar
View Original Published Thread

Importing a Gsheet

D_Meakin
Level I

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

2 REPLIES 2
jthi
Super User


Re: Importing a Gsheet

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))
);
-Jarmo
D_Meakin
Level I


Re: Importing a Gsheet

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.