How to refer to other sheet in google app script?

Question

i can access the current sheet using :

var SS = SpreadsheetApp.getActiveSheet();

But how to access other sheets from the same spreadsheet file ?

Answer 1

var SS = SpreadsheetApp.openById("");

In between quotes, enter the ID of the Spreadsheet you want to use.

How to get the ID of a spreadsheet? The red arrow in this image points to the spreadsheet id.

Answer 2

There are different ways to get sheets in a spreadsheet:

• Get them by their name: getSheetByName()
• Retrieve all of them in an array: getSheets()