The tools and APIs that your company offers make it really difficult to create such a backup and to keep it in sync. How can I do this for Google Photos? The Google Photo API returns compressed files with missing EXIF info. The Google Takeout option can't be automated and needs third party tooling to convert back into a usable format.
fyi you can automate Takeout to a degree. You can tell it to prepare a takeout once every 2 months I think, and you’ll then get an email when it’s ready. You could probably script something to look for those emails, download the compressed tgz files, and then store or upload to some backup location.