Develofly Autopilot
Templates › Research & Reporting › Daily KPI dashboard emailer

Daily KPI dashboard emailer

Pull numbers from APIs or sheets and email a daily digest.

Research & ReportingWeekdays at 8:00

Download the app, freeOpen in Autopilot

Daily KPI dashboard emailer: what it does, step by step, with its sample data

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

  1. Decides what to do next
  2. Calls the service's API
  3. Picks out the values
  4. Emails you the results
All 25 steps (as they appear in the app)
  1. If attach_file equals yes
  2. _attach = xlsx
  3. _attach = none
  4. GET {{source_url}}
  5. If format equals csv
  6. Read values: value
  7. Read values: value
  8. If value empty
  9. Stop row: no value at {{path}}
  10. vs_target =
  11. on_track =
  12. If target not empty
  13. vs_target = round({{value}} / {{target}} * 100)
  14. If better equals lower
  15. If value greater {{target}}
  16. on_track = ⚠ above target
  17. on_track = ✓
  18. If value less {{target}}
  19. on_track = ⚠ below target
  20. on_track = ✓
  21. Remember kpi {{kpi}} for next run
  22. change =
  23. If _prev not empty
  24. change = {{value}} - {{_prev}}
  25. 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.

kpisource_urlformatpathheaderstarget
GitHub stars (cpython)https://api.github.com/repos/python/cpythonjsonstargazers_count70000
Open issues (cpython)https://api.github.com/repos/python/cpythonjsonopen_issues_count5000

Get this template

1. Download Develofly Autopilot: free, for Ubuntu and other Linux desktops.

Download Develofly Autopilot

2. 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 Autopilot

What 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.

More Research & Reporting templates

Grant / RFP finderScan grant and tender portals for new opportunities.News clipping monitorTrack a topic across news sites into a sheet.Daily numbers to SlackA number from any API, posted to Slack daily.Real-estate listing watcherNew listings matching your criteria → a sheet, with an alert.