- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Importing a Gsheet
Has anyone figured out how to import a gsheet from a google drive?
2 REPLIES 2
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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.