Turns out that I had to supply a password to encrypt backups in the Google Drive setup section. I had set it up without supplying a password. Opnsense did not issue any warning/error so I assumed that password is optional. It is not optional.