What it does
Pulls each number in your list (one KPI per row) from a JSON API or a CSV (for example a Google Sheet published as CSV), compares it with its target and the last run, and emails you one digest with a table of every KPI. JSON paths look like data.total; CSV paths are a cell (B2) or Column.last / .sum / .average / .count. Uses the email account in Settings → Notifications.
How it works
- Decides what to do next
- Calls the service's API
- Picks out the values
- Emails you the results
All 25 steps (as they appear in the app)
- If attach_file equals yes
- _attach = xlsx
- _attach = none
- GET {{source_url}}
- If format equals csv
- Read values: value
- Read values: value
- If value empty
- Stop row: no value at {{path}}
- vs_target =
- on_track =
- If target not empty
- vs_target = round({{value}} / {{target}} * 100)
- If better equals lower
- If value greater {{target}}
- on_track = ⚠ above target
- on_track = ✓
- If value less {{target}}
- on_track = ⚠ below target
- on_track = ✓
- Remember kpi {{kpi}} for next run
- change =
- If _prev not empty
- change = {{value}} - {{_prev}}
- Email results to {{email_to}} ({{_attach}})
Sample data included
The template comes with sample rows like these, so you can see it work before using your own list.
| kpi | source_url | format | path | headers | target |
|---|---|---|---|---|---|
| GitHub stars (cpython) | https://api.github.com/repos/python/cpython | json | stargazers_count | 70000 | |
| Open issues (cpython) | https://api.github.com/repos/python/cpython | json | open_issues_count | 5000 |
Get this template
1. Download Develofly Autopilot: free, for Ubuntu and other Linux desktops.
Download Develofly Autopilot2. The app comes with every template, so this one is already in your library. Click below to open it (or find it under Templates).
Open in AutopilotWhat you need
- A spreadsheet (CSV or Excel) — a sample is included
- Email or chat alerts set up in Settings
You fill in: Send to, Subject, Intro line, Attach the sheet.
Make it yours
Every step is editable in the app: change the site, the columns, the schedule, or chain it with other bots. Run it once, on a schedule, or sell it as your own bot.