in CWP control panel can I do the auto backup on google drive instead of the server disk
You could use rClone to sync your local backup folder(s) to google drive:
https://rclone.org/drive/ (https://rclone.org/drive/)
Install rclone and
Setup a cron job with something like this:
rclone sync /yourbackupfolder/ remotename:remotebackupfolder
Yourbackupfolder will be synced with google drive every time the cron job is run.
p.s If you delete source folder - yourbackupfolder - files will also be removed from google drive. If you don't want that use:
rclone copy /yourbackupfolder/ remotename:remotebackupfolder
Read the rclone manuals - https://rclone.org/docs/ (https://rclone.org/docs/)