A daily goals report: what's on plan and what's behind

The scenario reconciles goals from mondayCom against the real work in jira, calculates the gap, updates the statuses, and sends a summary to Telegram and a detailed report to Mandrill.

  • Goals are checked against real work, not gut feel
  • The gap is calculated daily, not at quarter's end
  • Goal statuses update themselves in mondayCom
  • The summary goes to Telegram, the detail by email
Monday.comJira Software
Set it up for yourselfScriptera

How it works

To keep Telegram and Mandrill in sync, connect them with a ready-made scenario — changes flow automatically.

  1. Starts when: Daily OKR Sync Trigger
  2. Then: Fetch OKRs from Monday.com
  3. Then: Map Monday Fields → Standard KR Schema
  4. Then: Split KR → Epics Mapper
  5. Check: Join KR + Epic Data (SQL Merge)
  6. Then: Compute KR Progress & Variance
  7. Then: Update KR Status on Monday
  8. Then: Aggregate Final Results for Reporting
  9. Then: Post Slack Variance Report
  10. Then: Email Variance Digest (Outlook)
  11. Then: Fetch Jira Epic Details
  12. Then: Normalize Jira Response

You can launch this Telegram + Mandrill integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.

Similar scenarios