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

Showcase
1

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
2

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