Google Drive Stream indexing by macOS has been hit or miss, and looking on the Google forums, they sometimes try to fix the issues.
— Alfred App (@alfredapp) April 24, 2020
If Spotlight is finding the files, make sure that the Google Drive volume is within Alfred's Features > Default Results > Search Scope