Calibres Add from folder template
does can NOT pull path info to populate additional fields.
The GetFileName PI is a possible work around. It populates a custom column with the path.
There is still a lot of work using that method.
You could also do things in Series sized batches, (manually) Adding the Series NAME info after each Add cycle

I think I would import the Title as 'Series Number - Album Title'
then use a Bulk metadata edit: S&R (tab) REGEX to
correct the Index