Good news, Sparkle plays nicely with your existing setup:
Works with:
Dropbox (synced folders)
Google Drive (File Stream)
iCloud Drive
OneDrive (locally synced files)
What you should know:
Files must be available locally: Sparkle can't organize files that are only stored in the cloud
Sparkle won't mess with your file names or metadata (though timestamps may change when files are moved)
Let your cloud sync finish before running Sparkle