Finding specific things
Cloud sync clients are the second most common reason a file 'exists but cannot be found'.
Dropbox Smart Sync, Google Drive streaming and OneDrive Files On-Demand all leave placeholders rather than real files. The name is local; the contents are not.
Consequence: name search works, content search does not, and the file's size on disk is effectively zero.
Google Drive mounts as a virtual volume at /Volumes/GoogleDrive (older) or under ~/Library/CloudStorage/GoogleDrive-you@example.com (current). Two problems follow: it is a network-ish volume that Spotlight indexes poorly, and the modern path is inside ~/Library, which Spotlight excludes anyway.
That combination is why Google Drive files are close to unsearchable via Spotlight.
Dropbox syncs to a real folder in your home directory, so it indexes normally — for files that are actually downloaded. Right-click a folder → Make available offline to force local copies.
Similar to Dropbox, with Files On-Demand behaving like Dropbox Smart Sync.
is the only place the contents exist
~/Library/CloudStorage will find placeholdersas well as downloaded files, since both have real directory entries
.gdoc files are just pointers containing a URL. There is no document on your Mac to search at all. Only Drive's web search can find their contents.
Modern Google Drive mounts under ~/Library/CloudStorage, which Spotlight excludes, and streamed files have no local contents.
Only a small placeholder. The contents download when opened.
Everywhere keeps track of every file on your Mac — including the folders Spotlight hides and drives you have unplugged. Free for a day, then $19 once.
Download for Mac