Scanning local TV show's episodes and then move them to Google Drive maintaining all scanned metadata

There is a whole discussion on how to move your metadata to another library by editting the database. [HowTo] Plex database modification - Moving media the right/wrong way

That one is mainly for all files, but you should be able to adjust it to specific files.