Another +1.
MacBook Pro 14 (2021)
MacOS 12.6
Dropbox v160.4.4690
Alfred v5.0.3
Alfred finds files from my CloudStorage/GoogleDrive and CloudStorage/OneDrive no problem.
I was having a similar issue, running the 1p Add Account command with nothing happening. Turns out I had set my Alfred -> Preference -> Terminal to custom, and had botched the Applescript. Once I set it to Terminal, everything worked. Hope this helps someone.