How can I find the ID of a google sheet that I've just created with code?

Question

I've just created a copy of a file with a new name using this command:

file.makeCopy(''+newfilename+'');

How can I find the ID of the new file?

score 1 · Accepted Answer · answered Oct 13 '20 at 14:04

1

If you check the official documentation, you will see that makeCopy() returns an object of the class File.

The latter has a method getId() which gives you the id of the File.

const newFile = file.makeCopy('newfilename'); // it returns an object of type File
const newFileID = newFile.getId(); // File has a method .getId()

answered Oct 13 '20 at 14:04

Marios

Sorry to be dense, but I'm not a professional coder. This is what I've just done: file.makeCopy(''+newfilename+''); const newFile=file.makeCopy(''+newfilename+''); const newFileID = newFile.getId() file.makeCopy(''+newfilename+''); I can intuit that this was not what you had in mind but am not sure how to connect my creation of the file with the getID() in this case. – Kenton Sparks Oct 13 '20 at 14:23

score 0 · Answer 2 · answered Oct 13 '20 at 13:37

0

Just use:

SpreadsheetApp.getActiveSpreadsheet().getId()

answered Oct 13 '20 at 13:37

Doom

1

That gives me the ID for the SS I'm in; I need the ID for the NEW SS I've created using code within my current SS. – Kenton Sparks Oct 13 '20 at 13:56

Rubén · Answer 3 · 2020-10-13T14:07:00.790

0

Use the following

var copy = file.makeCopy('Put the new file name here');
var id = copy.getId();

answered Oct 13 '20 at 13:59

Rubén

3 Answers3