Google drive cannot currently be used to sync calibre libraries because it removes parts of file names. In particular, it removes the calibre database ID from the names (the number in the parentheses). Dropbox does not do this, and calibre library sync works well as long as the single-writer rule is respected.
It is difficult to understand how google thinks that drive is a usable product when it changes the names of files. What substance are they smoking?