Automated Kyligence Weekly Metrics Export
Every Monday morning, WebRun opens Kyligence, reads the current value of every metric in your tracked semantic models, appends a dated row for each one to a Google Sheet, and writes a short narrative in Notion explaining the week's biggest moves, so the numbers behind the cubes reach people who never open Kyligence themselves.
How do I export my Kyligence metrics to a spreadsheet every week?
WebRun reads every tracked metric in your Kyligence models each Monday, exports a dated row per metric to a Google Sheet, and writes a short Notion narrative on the week's biggest moves. The numbers behind your semantic layer reach a spreadsheet and a plain-language summary automatically, without anyone exporting a cube by hand.
- Metric model numbers reach a spreadsheet with zero manual exports
- A running weekly history builds automatically for trend analysis
- A plain-language narrative in Notion explains what moved and why it matters
Built for Data teams · BI analysts · Finance teams · Enterprise IT 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
kyligence.ioin a real browser with your saved login - no setup, no API keys. -
1
Kyligence - read this week's metric values
- Open Kyligence and read the current value of every metric in the tracked models
- Compare each value to last week's exported number
- Note the percentage change for each metric
Done when Every tracked metric has this week's value and change captured.
-
2
Google Sheets - export the numbers
google.com
WebRun opens Google Sheets to export the numbers. - Append a new row for each metric with this week's date and value
- Keep prior weeks' rows untouched below
- Format the change column so drops stand out
Done when This week's row is added to the export sheet for every metric.
-
3
Notion - write the narrative
notion.so
WebRun opens Notion to write the narrative. - Write a short narrative explaining the week's biggest metric moves
- Link back to the row range in the export sheet
- Keep the narrative to a few short paragraphs
Done when A dated narrative page exists in Notion for the week.
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
Does this change our metric models or cubes in Kyligence?
No. WebRun only reads the values the models already compute. Metric definitions, cubes, and semantic models are never edited.
What if a metric model has not finished building for the week?
It is logged as pending in the sheet rather than a guessed number, and picked up on the next weekly run once it finishes.
Can we track metrics from more than one model?
Yes. Point WebRun at every metric model you want tracked and it exports all of them into the same weekly sheet.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.