Can I use automator to select text then search spotlight for it?
I think the closest you are going to get is something like this.

( In a Automator Service  Document )



I am just show two folders here as an example.

The first action gathers the selected text into a variable.

Each Spotlight Action ignore the above actions output/input and uses the variable token as the search term.