I tried and verified. I was able to manually backport the package from http://deb.debian.org/debian/pool/main/p/pydrive2/pydrive2_1.15.0-3.dsc
It built and installed fine against bookworm. I was able to create a Google drive backup. I cannot do it but it could be put in bookworm-backports and made available.