The Google Import app supports importing google sheets to a lookup table. Does this work on a search head cluster? Will the import run on the captain only or on all nodes? Will the lookup exist on all nodes?
I don't have an SHC environment for testing so I can't confirm the behavior. However, I believe that the lookup would exist on call SHs. My understanding is that modular inputs run on all SHs. They have to be designed specifically to recognize that they are running on the captain if you want them to run only on the captain. I never implemented captain detection in the Google Import app so it should run everywhere.
Let me know if find that this is not the actual behavior.