How to display data from google sheets to Splunk Dashboard?

[Splunk_noobie]

Hi all,

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

[Splunk_noobie]

@gcusello  
Could you please help 🙂 

[gcusello]

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

[Splunk_noobie]

@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