All Apps and Add-ons

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

obhatti
Explorer

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

0 Karma
1 Solution

LukeMurphey
Champion

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".

View solution in original post

sathwikr076
Communicator

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.

0 Karma

LukeMurphey
Champion

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
Explorer

Thanks. That worked!

0 Karma

cbhattad
Path Finder

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

0 Karma
*NEW* Splunk Love Promo!
Snag a $25 Visa Gift Card for Giving Your Review!

It's another Splunk Love Special! For a limited time, you can review one of our select Splunk products through Gartner Peer Insights and receive a $25 Visa gift card!

Review:





Or Learn More in Our Blog >>