how to auto update personal video metatdata

Looking to benefit from others experience…
I want to automatically populate additional details for my personal video library. From what I’ve read online it seems this is somewhat of a weak area for Plex. I have a library (directory) of personal video files (MOV, MP4). I have a spreadsheet containing the details for each video - 1 row each, listing filename, resolution, title, summary, keywords, date, rating, etc.
I want to get as much of this info into the Plex library as possible.

Thoughts I had included - importing into the DB directly via SQLite tool (can’t identify which tables)
or adding the metadata to each video file (using Adobe Bridge or equiv) (don’t know which fields Plex Agent reads)

Any suggestions to make either of these options work would be greatly appreciated or even an option 3 perhaps…

Thanks in advance.
Tim

  1. install these .nfo importer agents
    and make them the default agents for your Personal video library

  2. create Kodi-compatible .nfo files with all details of your videos using Ember Media Manager
    https://forum.kodi.tv/showthread.php?tid=191781

That way all the info is readily available and can be backed up together with the media files.

Thanks for the suggestion. It looks like Ember Media Manager manually creates ,nfo files and doesn’t ise an Excel spreadsheet as a source. I may skip that step and write an Excel script to create the 100+ .nfo files itself. I’ve installed the XBMC agent and tried having Plex refresh one video with an .nfo file in the directory but it did not pick up the additional details from the file. Library Scanner is set to “Plex Video Files Scanner” and agent is “XMBCnfoMoviesImporter”. Does this sound correct?