I’m trying to read a CSV file saved in my Google Drive and copy data to my Google Spreadsheet.
Imagine my CSV file’s name is “singleColumn.csv” and it is located in my Google Drive folder. If you want to get your drive folder id see here; How to find your Google Drive folder ID.
This is how my CSV file looks like;
Go to your Spreadsheet, open your Script Editor, Write functions below.
These functions will search your drive folder for given file name (singleColumn.csv) and read it. Then paste data row by row on your Spreadsheet.
Contact me if you need further improvements and changes.