aios-monthly-report

Generates a monthly client report from backend KPIs and syncs the workbook to Google Sheets.

1|Updated Jul 8, 2026
One-click install
npx skills add https://github.com/codesofadan/danyals-aios --skill aios-monthly-report-codesofadan
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: aios-monthly-report
Source: https://github.com/codesofadan/danyals-aios/tree/main/.claude/skills/aios-monthly-report
Command: npx skills add https://github.com/codesofadan/danyals-aios --skill aios-monthly-report-codesofadan

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? Writing end-of-month client reports manually means pulling numbers from multiple dashboards and risking invented or inconsistent figures. This Skill assembles the monthly client narrative strictly from real backend rows (audit deltas, milestone progress, content stats, spend) and pushes the client's workbook to Google Sheets. ## Core Features & Use Cases - Grounded narrative generation: Composes a branded client summary using only figures fetched from the Command Center, milestones, content-job stats, and report workbooks, with no fabricated traffic or ranking numbers. - Milestone progress calculation: Derives progress percentage from the stage-weight formula over real milestone status values. - Google Sheets sync: Pushes the client's workbook via POST /reports/sync (lead-only) and confirms rows pushed through sync-events, honestly reporting degraded states when the Sheets credential is dormant. - Use Case: An account lead says "write this month's client summary for Acme" and receives a formatted report with health status, audits, content shipped, spend, a plain-prose narrative, and a confirmed Sheets sync status. ## Quick Start Ask the assistant to write this month's client report for a named client, for example: generate the monthly report for Acme for October.

Frequently Asked Questions about aios-monthly-report

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I generate a monthly client report from backend data?▼

Invoke the skill with a client name and optional month. It reads the Command Center KPIs, milestones, content-job stats, and the client's workbook via the AIOS API, then composes a narrative using only those fetched figures.

How does the report sync to Google Sheets?▼

After writing the narrative, the skill calls POST /reports/sync with the workbook ID, then checks /reports/sync-events to confirm rows pushed. Syncing requires a lead role (owner, admin, or manager); non-leads receive the narrative read-only.

What happens if the Google Sheets credential is not connected?▼

The sync degrades: zero rows are pushed and the buffer is retained. The skill still delivers the narrative but labels the sync as degraded with the Sheets key pending, never claiming it reached Google Sheets.

Can the report include traffic or ranking numbers?▼

No live analytics exist in the platform. The traffic series is an audit-derived placeholder and must be labeled as such; the narrative is built only from real audit, content, milestone, and spend rows.

Why does the sync step return a 403 error?▼

The /reports/sync endpoint is lead-only. Portal clients and non-lead staff are forbidden; the skill stops before syncing and reports that a lead is required.