The first thing to do is to read the calibre FAQ section headed:
I am getting errors with my calibre library on a networked drive/NAS?.
Then to realize that in your calibre library at the end of the individual book directories, you will see (1234) where the numbers are a calibre generated ID. For versioning, Google Drive uses the same structure so it will destroy your library.
Putting a calibre library on any network attached storage is a gamble, putting it on Google Drive is like playing Russian Roulette with no empty chamber.
See
WARNING - Google Drive Incompatible with Calibre! for more information.
Try a search for "calibre how to recover a corrupted library site:mobileread.com" on Google. You should get multiple hits such as
Can't open Calibre-Corrupt library.
The basic procedure would be to copy your library from Google Drive to local storage before working on it. As a start, I would then create a new library and add the books from the local copy of the old library to the new library using add books from folders and sub-folders.
You can keep a backup copy of your calibre library on Google Drive, just don't have your active copy on there.