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!

See your relevant APM services, dashboards, and alerts in one place with the updated ...

As a Splunk Observability user, you have a lot of data you have to manage, prioritize, and troubleshoot on a ...

Index This | What goes away as soon as you talk about it?

May 2025 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with this month’s ...

What's New in Splunk Observability Cloud and Splunk AppDynamics - May 2025

This month, we’re delivering several new innovations in Splunk Observability Cloud and Splunk AppDynamics ...