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.
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
Google sheet :
Column A Column B
If <uniqueId_tok> = 5227 then my panel reads G-sheet and displays data in column B i.e Monday
Hope my ASK is clear