Jirav Automated KPI Dashboard Logging
Every Monday, WebRun opens Jirav and pulls your configured KPIs, including revenue, gross margin, headcount, and cash metrics, then logs each value with a timestamp into your Google Sheets KPI dashboard, appending a new row so your team has a running history of performance without any manual data entry.
How do I automatically log Jirav KPIs into a Google Sheets dashboard each week?
WebRun opens Jirav every Monday, pulls your configured KPIs including revenue, gross margin, headcount, and cash balance, and logs each value as a new timestamped row in your Google Sheets KPI dashboard. Your team gets a live, time-series performance history without any manual data entry or copy-paste work.
- KPI dashboard updated every Monday with zero manual data entry
- Full time-series history of performance metrics in one Google Sheet
- Teams spend analysis time on insights, not copy-paste reporting
Built for FP and A teams · finance managers · CFOs · business analysts · SaaS finance teams
What does WebRun do on every run?
The exact actions WebRun takes, in order - in plain language, so you can adjust anything.
-
WebRun signs in and gets to work
Opens
app.jirav.comin a real browser with your saved login - no setup, no API keys. -
1
Jirav - pull current KPIs
jirav.com
WebRun opens Jirav to pull current KPIs. - Open Jirav and navigate to the KPI dashboard for the current period
- Pull the configured metrics: revenue, gross margin, operating expenses, headcount, and cash balance
- Note the period, actuals, targets, and prior-period values for each KPI
- Confirm all metrics are populated before moving to the next step
Done when All configured KPIs are pulled with their actuals, targets, and period labels.
-
2
Google Sheets - log KPIs to dashboard
google.com
WebRun opens Google Sheets to log KPIs to dashboard. - Open the designated KPI dashboard Google Sheet
- Append a new row with today's date, the period label, and each KPI value pulled from Jirav
- Confirm the row is written and that formulas in the sheet update correctly
Done when A new row with this week's KPIs is logged in the Google Sheets dashboard.
How is each run configured?
Secure by default
Connect once, stays signed in
WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.
Every action is checked against this policy before it runs.
Questions, answered
Which KPIs does WebRun pull from Jirav?
You configure the KPI list during setup. By default WebRun pulls revenue, gross margin, operating expenses, headcount, and cash balance, but any metric visible in your Jirav KPI dashboard can be added to the list.
Does it overwrite existing rows or append new ones?
WebRun always appends a new row with the period date and the current values, so your Google Sheet builds a full time-series history. It never overwrites previous entries.
Will it send the sheet to executives or email stakeholders?
No. WebRun only writes to your internal Google Sheet. If you want to share the dashboard with stakeholders or distribute a report externally, that step is left for you to initiate. WebRun does not send emails on its own.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.