You can't setup import with team drive but if you have a spreadsheet you want to import from standard google drive you can set it up after installing the app by following these steps:
1.) Go to Apps -> Manage apps -> Find google drive and click "Set up". Follow the instructions to setup a google service account key. You'll get an email address from Splunk which you should then share with the google spreadsheet so Splunk has read access.
2.) Create a lookup file (to be overwritten by google sheets) "| makeresults | outputlookup mylookup.csv"
3.) Settings -> Data inputs -> Google spreadsheet -> New -> Input the title of the spreadsheet and sheet you're interested in ingesting. Select the lookup you created in step 2 as well as a Name/Interval.
Now if you search "| inputlookup mylookup.csv" you should see results. Hope this helps!
... View more