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
Get Updates on the Splunk Community!

Now Playing: Splunk Education Summer Learning Premieres

It’s premiere season, and Splunk Education is rolling out new releases you won’t want to miss. Whether you’re ...

The Visibility Gap: Hybrid Networks and IT Services

The most forward thinking enterprises among us see their network as much more than infrastructure – it's their ...

Get Operational Insights Quickly with Natural Language on the Splunk Platform

In today’s fast-paced digital world, turning data into actionable insights is essential for success. With ...