Save operations if you can use Apps Script... Also it can be done by Add Row module of Google sheet

In Make to add sharable links from folder in google drive and other data to google sheet (or Microsoft excel)
Use this script.

function getTheFiles () {

var dApp = DriveApp;

var folderIter = dApp.getFoldersByName(“FOLDER-NAME”);

var folder = folderIter.next();

var filesIter = folder.getFiles();

var Sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(“SELECT-SHEET”);

var i=2;

while(filesIter.hasNext()){

var file = filesIter.next();

var filename = file.getName();

var fileUrl = file.getDownloadUrl();

Sheet.getRange(i,1).setValue(fileUrl);

Sheet.getRange(i,2).setValue(filename);



Logger.log(filename);

Logger.log(fileUrl);

i++;

}

}

Replace FOLDER-NAME and SELECT-SHEET as your need respectively with your folder and sheet name. Set Varible i= row number, from where you want to add data to rows and selected columns.

Make your busy schedule free #withMake
Thank to mates at Make, for making this community portal.

1 Like

Hey @Prem_Patel thanks so much for sharing!

We’re very happy that we got the chance to build a space for our awesome community of users to meet, exchange tips and inspire one another :make:

1 Like