List of my successful experiments in digital world :



Under construction


Translate our YouTube videos (required google account login) to help other language speaking community at



Enlist names of google drive folder in spreadsheet

Link code for google script :

Code is given below. (replace my drive with name of your folder)


// replace your-folder below with the folder for which you want a listing
function listFolderContents() {
var foldername = ‘my drive‘;
var folderlisting = ‘listing of folder ‘ + foldername;

var folders = DriveApp.getFoldersByName(foldername)
var folder =;
var contents = folder.getFiles();

var ss = SpreadsheetApp.create(folderlisting);
var sheet = ss.getActiveSheet();
sheet.appendRow( [‘name’, ‘link’] );

var file;
var name;
var link;
var row;
while(contents.hasNext()) {
file =;
name = file.getName();
link = file.getUrl();
sheet.appendRow( [name, link] );


Place this script and allow google drive for permission. You will be able to save them in automatic spreadsheet in google drive parent folder. Example of my drive test (for files list) given below. You can replace circled areas according to your need- i.e. name of folder, and whether you need to enlist files names only or folder names only. (This script doesn’t work on hybrid, i.e. both file and folder names, so arrange them in drive accordingly. And ya, ignore cursor pipe sign preceding parenthesis.;-)





In dissertation / research studies, in place of filling hard copy of proforma; one can use Google form. This gives following advantages

1. It directly generates excel sheet
2. Investigator doesn’t have to spend separate time for data entry
3. It can be operated by mobile.
4. No need of carrying hard copies of proforma in field
5. Google form itself generates primary analysis of data like percentage, pie chart
6. Investigator can anytime view primary analysis during the study up to entry made in form.

All the types of questions can be generated in google form e.g. date, multiple option type, short text, long text etc.



Leave a Reply

Your email address will not be published. Required fields are marked *