How do you read a csv from google drive?

my blocks

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

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

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

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

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

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

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

(added to FAQ)

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