View source for List Sheet Names and URLs for Each Sheet

# Create a Google Sheet that has a ton of sheets
# Create a new Sheet that is left-most of all of the other sheets in the Google Sheet and name it <code>Index</code>
## If you wish to use something other than Index, you can change the Sheet Name to whatever you like, but in this code below, you will want to replace <code>Index</code> with what your desired sheet name is
## <code>  var sh=ss.getSheetByName(''''Index'''<nowiki/>');</code>
# Insert the code below to the Scripts section and hit save
# Go back to the Google Sheets and refresh the file. In the menu you should get a new option called, "Sheets" and within that menu, there will be "List All Sheets" and "List All URLs". Click on each in order until you have the list of links


<code>function listSheets() {</code>

<code>  var sheetNames = new Array();</code>

<code>  var sheets = SpreadsheetApp.getActiveSpreadsheet().getSheets();</code>

<code>  var selectedSheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();</code>

<code>  var selectedRow = selectedSheet.getActiveCell().getRow();</code>

<code>  var selectedCol = selectedSheet.getActiveCell().getColumn();</code>

<code>  var range = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet().getRange(selectedRow, selectedCol, sheets.length, 1);</code>

<code>  for (var i = 0; i < sheets.length; i++) sheetNames.push([sheets[i].getName()]);</code>

<code>  range.setValues(sheetNames);</code>

<code>}</code>


<code>function onOpen() {</code>

<code>  SpreadsheetApp.getUi()</code>

<code>      .createMenu('Sheets')</code>

<code>      .addItem('List All Sheets', 'listSheets')</code>

<code>      .addItem('List All URLS', 'listedSheetUrls')</code>

<code>      .addToUi();</code>

<code>}</code>


<code>function mySheetName() {</code>

<code>  var key = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet().getName();</code>

<code>  return key;</code>

<code>}</code>



<code>function listedSheetUrls() {</code>

<code>  var ss=SpreadsheetApp.getActive();</code>

<code>  var sh=ss.getSheetByName('Index');</code>

<code>  var rg=sh.getRange(1,1,sh.getLastRow(),1);</code>

<code>  var vA=rg.getValues();</code>

<code>  var nA=vA.map(function(r){return r[0];});</code>

<code>  var shts=ss.getSheets();</code>

<code>  shts.forEach(function(sh,i){</code>

<code>    var idx=nA.indexOf(sh.getName());</code>

<code>    if(idx!=-1) {</code>

<code>      var url=Utilities.formatString('<nowiki>https://docs.google.com/spreadsheets/d/%s/edit#gid=%s',ss.getId(),sh.getSheetId())</nowiki>;</code>

<code>      vA[idx].splice(1,0,url);</code>

<code>    }</code>

<code>  });</code>

<code>  sh.getRange(1,1,vA.length,vA[0].length).setValues(vA);</code>

<code>}</code>
[[Category:Google Sheets]]