How to get a file name from file url in Apps Scripts

Question

So I am trying to use apps scripts to make a function so that I can provide a file url and get the file name in app scripts. Here is the function that I have that keeps giving me a permission error.

function getSSName(url) {
  var ss = SpreadsheetApp.openByUrl(name);
  return(ss.getActiveSheet().getName());
 }

Are you trying to create a custom functions in Google Sheets? or you plan to call this function from another function in your script? By the way var ss = SpreadsheetApp.openByUrl(name); name is not defined, it should be url — Kristkun
– Kristkun, Commented Jun 21, 2021 at 20:48

PiratePie · Accepted Answer · 2021-06-21 23:10:34Z

1

This should do the trick:

function getSSName(url) {
  return DriveApp.getFileById(url.split('/')[5]).getName();
}

answered Jun 21, 2021 at 23:10

PiratePie

3142 silver badges7 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to get a file name from file url in Apps Scripts

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related