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!

Index This | I am a number, but when you add ‘G’ to me, I go away. What number am I?

March 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...