L&D series: Grafana Spreadsheet for Transformative Data Insights
Learning and Development chapter 26.
DISCLAIMER: I’m using MacBook Pro M1.
PREPARATION
- Grafana OSS
- Google Spreadsheet Online
INSTALLATION
Please run these following commands (if you’re using non macOS, please look for similar command).
brew update
brew install grafana
brew services start grafana
Next for the online version of Google Spreadsheet.
- Create an API Key with Google Admin Console by following the tutorial from this Medium article. Instead of choosing Service Account, we have to choose API Key.
Do not forget to copy the API key somewhere else.
Now go to you Grafana Dashboard. Go to Connections — Data sources — Add data source then filter Google Sheet
Paste the API key in ‘Enter API key’ field then click Save & test button.
If connection success, then you’ll see this message.
Create New Dashboard
- Choose
Add visualization.
- Choose the Google Sheet for data source.
- Input the Google Sheet query in this section.
For Spreadsheet ID, we can see it in the URL => https://docs.google.com/spreadsheets/d/<Spreadsheet ID>/edit. If we’re done, then Save or Apply to see the result.
Are you ready to migrate to Grafana? — MperMperPisang
