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
Legend

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!

Improve Your Security Posture

Watch NowImprove Your Security PostureCustomers are at the center of everything we do at Splunk and security ...

Maximize the Value from Microsoft Defender with Splunk

 Watch NowJoin Splunk and Sens Consulting for this Security Edition Tech TalkWho should attend:  Security ...

This Week's Community Digest - Splunk Community Happenings [6.27.22]

Get the latest news and updates from the Splunk Community here! News From Splunk Answers ✍️ Splunk Answers is ...