Dashboards & Visualizations

How to display data from google sheets to Splunk Dashboard?

Splunk_noobie
Path Finder

Hi all,

Is there any way we can display data from G-sheet to the Splunk dashboard if a particular condition is met? 


Labels (5)
0 Karma

Splunk_noobie
Path Finder

@gcusello  
Could you please help 🙂 

0 Karma

gcusello
SplunkTrust
SplunkTrust

Hi @Splunk_noobie,

I never used G-Sheets, but I can suppose that it's possible to download the G-Sheets content in a csv file and then ingest and use it in Splunk.

To automate this process you should see how to use G-Sheets API but I cannot help you about this.

In other words, the problems isn't in Splunk displaying but in ingestion before splunking.

Ciao.

Giuseppe

0 Karma

Splunk_noobie
Path Finder

@ITWhisperer 

Any idea what should the approach be? 

 

> I have a Gsheet with a unique id in the column A. If that matches my <uniqueId_tok> Token in the dashboard, an HTML panel can display the data present on column B of my G-sheet 

Example : 

Google sheet : 
Column A           Column B

5227                    Monday

1256                    Tuesday

7690                    Wednesday

 

If <uniqueId_tok> = 5227 then my panel reads G-sheet and displays data in column B i.e Monday

Hope my ASK is clear 

0 Karma
Get Updates on the Splunk Community!

Dashboards: Hiding charts while search is being executed and other uses for tokens

There are a couple of features of SimpleXML / Classic dashboards that can be used to enhance the user ...

Splunk Observability Cloud's AI Assistant in Action Series: Explaining Metrics and ...

This is the fourth post in the Splunk Observability Cloud’s AI Assistant in Action series that digs into how ...

Brains, Bytes, and Boston: Learn from the Best at .conf25

When you think of Boston, you might picture colonial charm, world-class universities, or even the crack of a ...