Google App Script Function: Return Drive Filename from File URL-CodePudding

I've searched extensively for an answer to this, but have not had much luck. I think it should be a fairly simple answer. Here's what I'm trying to do:

I have a list of (other) Google Sheets document URLs in a Google Sheet.
I'd like to have a simple function that loads the URL in each line and returns the file name.
To illustrate, if the URLs are in A2:A10, a user could input a custom function like =GetFileName(A2) and it would return the file name corresponding to the Google Sheet URL that is in A2.

Here's the code that I have thus far, but it's returning an error, " TypeError: SpreadsheetApp.openByURL is not a function (line 3)."

function getFileName(fileURL) {
  
  var GetFile = SpreadsheetApp.openByURL(fileURL);
  var GetName = GetFile.getName();
  return GetName;

}

Any suggestions?

CodePudding user response：

Custom Functions Cannot open other spreadsheets (SpreadsheetApp.openById() or SpreadsheetApp.openByUrl()).

Here is how you assign a script function to an image: