Get a list of Google Photo Folder Names

Go to https://photos.google.com and run from the browser console

Remove the quotes around the resulting string and import as a spreadsheet separated by tabs.

Refer: https://webapps.stackexchange.com/questions/90614/how-can-i-get-a-list-of-albums-in-google-photos

List of Folder Names

var links = document.getElementsByTagName('A'); 
var s = ''; 
for (var i = 0; i< links.length; i++) {
 if (/\b(album|share)\b/.test(links[i].href)) {
 var albumName = links[i].children[1].children[0].innerText;
 s = s + albumName + '\t' + links[i].href + '\n';
 }
}

List of Shared Albums

var links = document.getElementsByTagName('A'); 
var s = ''; 
for (var i = 0; i< links.length; i++) {
 if (/\b(album|share)\b/.test(links[i].href)) {
 s = s + links[i].innerText + '\t' + links[i].href + '\n';
 }
}