Batch adding footer reference number from xls or csv

Hi

Does anyone know how I might use an action in adobe pro to add a document specific footer (ie a reference number) to a folder of documents - based on an index (xls or CSV). So CSV could have filename and then reference and action would look at this to find the reference and then add it as a footer to the document, then move to the next document and repeat.

Any thoughts - or other ways to achieve this would be welcome!

Many thanks