How do I use my Splunk data to create charts on Google Sheets?

[obhatti]

I have Google Import/Export Setup. How do I use data in my Splunk indexes to create charts in Google Sheets?

[sathwikr076]

can you please let me know how you did the setup of this app. we deployed the app and it is showing nothing about the setup.

Thanks,
Sathwik.

[LukeMurphey · Accepted solution]

You would need to do the following:

1) Create a lookup file
Create a lookup file. You can use the Lookup Editor app to do this if you want.

2) Write the search to populate the lookup
Create your search to populate the lookup with the data that you want it to contain. You can use the "outputlookup" search command to do this. You will probably want to use the "append" argument.

3) Create the input
Create the Google Import/Export input. Select the lookup file you created and make sure that you make the operation "export".

[obhatti]

Thanks. That worked!

[cbhattad]

How to do the 3rd Step?
Is there any UI for it?