Can you move the Google Drive to a different volume?
One neat trick you can do with recent versions of macOS is create new top-level volumes. They share the same storage as the "data" volume, but they're different.
In my case, I created a "shared" volume and disabled permissions on the volume. Then, I could create files as a test user and more easily share them with my real user without permissions problems that I was having with the /Users/Shared folder.
So while the "Document Container" option doesn't seem to work (I confirmed this), you can limit the search scope to a single location.
- Open a new Finder window and click on your home directory in the sidebar. (This is important).
- Create a new Smart Folder and set your recent date range.
- Next to "Search", limit the search scope to your home directory.
- Save as a new Smart Folder.
This will perform a recent search just in your home directory. If you have files on a separate volume, they won't be included.
I think this may be your only option due to iCloud. It's possible to hack up a saved search using a text editor and manually specify multiple paths to include. But there's no option to exclude paths. And "iCloud" is a made-up, Finder artifact that includes data from many different places.
If you know the exact paths of your DropBox and Google Drive data, then it might be possible. I don't use those products so I'm unfamiliar with how they're organized internally. But I know iCloud uses multiple locations in "~/Library/Mobile Documents". Apple's 3rd party cloud API might require those other service to use the same location. I just don't know.
If you can move Google Drive to a shared volume, that would be a quick-n-easy fix.
