I’m currently working with a Salesforce org that has over 1 million+ Attachments and ContentVersion files across multiple objects.
I’m looking for a scalable way to bulk download all files and directly store them in Google Drive, without first saving them locally.
So far, I’ve tried:
- dataloader.io, but it has a limitation of 10k files per month
- Salesforce Data Export, but it doesn’t provide actual file downloads (only metadata)
Has anyone implemented a solution for this at large scale? Any recommendations around tools, integrations, or best practices would be really helpful.
Thanks in advance!
Hi. In my opinion, there should be an apex scheduled job that pulls the attachment and post it as an attachment to google drive folder. The solution is based on the integrating google drive and salesforce using api. See similar discussion
https://trailhead.salesforce.com/trailblazer-community/feed/0D54V00007ZBMiISAXHere is an app from app exchange that doesn't work on bulk but works for single files which confirms that integration is possible and bulk data can be moved as well.
https://appexchange.salesforce.com/appxListingDetail?listingId=a0N3A00000Ecv16UAB