Import data from a CSV file to your Google Spreadsheet

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;

csv

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.

Cheers!

Advertisements

Your JIRA issues to Google spreadsheet

I was wondering how could I get my all unresolved JIRA issues to my spreadsheet. I made a research and find this simple way to get all my issues.I used JIRA REST API. 

Here, In my JIRA I have this in progress issue;

jirra-open-issues
Unresolved JIRA Issues

I wanted to get this open issue data to my spreadsheet as this;

spreadsheet
Final Result

I opened script editor and wrote this code;

Have fun !