How do you read a csv from google drive?

MIT App Inventor Help
,
1

my blocks

blocks(8)
blocks(8)783×388 29 KB

2

Here are two ways, the first using lists, the second using dictionaries

blocks
blocks1032×907 106 KB

3

My url is different from your
"https://drive.google.com/file/d/1o1si4kHNhAPMSd6unkK7V_amdOT0JuUT/view?usp=sharing"
I think this is problem, I know how to parse a csv, but I don't know how to get it from gdrive

4

Now you can see how to construct the url to call down a google sheet in csv format :slight_smile:

5

Ok, thank you, but my question was "How to read a csv from googledrive", not how to read a a google sheet

6

I beg your pardon :slight_smile:

  1. Get the File ID for the csv file
  2. Use the following url syntax to replace the one above
https://drive.google.com/uc?export=download&id=15gHEYm1ZIriYF6CtXowTS1h9TXVeG5H0

blocks (2)
blocks (2)1366×234 37.5 KB

You must ensure that your csv file has the correct format. If you don't get the results you are expecting, just check what is coming back in responseContent, then amend your file accordingly.

1 Like
7

Many thanks, it runs perfectly, now I have 2 solutions: googlesheet and gdrive.
Attached blocks for gdrive

blocks(10)
blocks(10)783×344 26.9 KB

8

(added to FAQ)

9

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.