Although this script has to open each file, Its does the job !! Thank you
You are also welcome to join that thread and ask about a way to do this in bulk.
I just made an action which run this script, then Batch it to a folder and all the PSD files are getting indexed in a single sheet
Cool! I'm glad this all got sorted out so quickly.
Also doable with ExifTool:
exiftool -csv -r -ext .psd -LayerNames 'Mac OS Path to PSD Input Folder' > 'Mac OS Path to/output file.csv'
(Win OS uses straight double quotes around file paths that contain spaces)