skills.rest
codesofadan
codesofadanCOMMUNITY
Explore all skills by this author →
GitHub

aios-report

Refreshes a client report workbook by flushing its Redis buffer to Google Sheets.

1|Updated Jul 8, 2026
Search Tags:#fastapi#google sheets#seo reporting#agency dashboard#report sync#client workbook#redis buffer
One-click install
npx skills add https://github.com/codesofadan/danyals-aios --skill aios-report-codesofadan
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: aios-report
Source: https://github.com/codesofadan/danyals-aios/tree/main/.claude/skills/aios-report
Command: npx skills add https://github.com/codesofadan/danyals-aios --skill aios-report-codesofadan

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? Client report workbooks accumulate data in a Redis write-buffer that must be manually pushed to Google Sheets; this Skill reads the workbook state, performs the sync, and honestly reports whether rows actually landed or the push degraded because Sheets is not connected. ## Core Features & Use Cases - Workbook inspection: Reads per-client workbooks, the report-type tab map, the sync-event feed, and the Google Sheets connection panel via the AIOS API. - Lead-gated sync: Flushes one workbook's buffer to its Google Sheet through POST /reports/sync, restricted to owner/admin/manager roles. - Honest degrade reporting: Detects when the Sheets service account is not configured (connected=false) and reports 0 rows pushed instead of claiming a live sync. - Use Case: An account manager asks to "refresh the workbook for Acme"; the Skill resolves the workbook id, checks the connection, syncs, and confirms rows pushed via the sync-event feed. ## Quick Start Ask the assistant to refresh the report workbook for a specific client name and confirm how many rows were pushed to Google Sheets.

Frequently Asked Questions about aios-report

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

FAQPage Schema
How do I sync a client report workbook to Google Sheets?▼

Resolve the workbook id from GET /reports/workbooks, check GET /reports/connection, then POST /reports/sync with the workbookId. Confirm the push by reading the newest entries in GET /reports/sync-events for that client.

Who is allowed to refresh a report workbook?▼

Reading workbooks, sync events, and connection state requires the view_reports permission available to any staff member. The sync itself is lead-only: owner, admin, or manager roles, and portal clients are denied entirely.

Why does a sync show status synced but push zero rows?▼

When the Google Sheets service account is not configured, connected=false and the sync degrades: status flips to synced optimistically but the buffer is retained and sync events record 0 rows pushed. Verify via the connection endpoint and sync-event feed.

Can I sync all client workbooks at once?▼

This Skill refreshes one workbook at a time. To push every client's workbook in a single operation, use the /aios-sheets-sync skill, which calls POST /reports/sync-all.

What happens if the workbook buffer queue is empty?▼

If buffer.queued is 0 and Sheets is connected, the sync is a no-op refresh with nothing new to push. The Skill reports this explicitly rather than implying fresh data moved.

Related Skills

Explore More Marketing & Sales Skills→
KnoWhizKnoWhiz
6

google-sheets

Read, update, append rows, and reply to comments in Google Sheets.

Official
Intermediate
xg-gh-25xg-gh-25
36

swarmai-monthly-report

Compile SwarmAI telemetry into a Markdown monthly report.

Community
Intermediate
AojdevStudioAojdevStudio
317

retirement-syncing

Import Vanguard and Fidelity CSV exports into Google Sheets retirement sections.

Community
Advanced
ekkus93ekkus93

excel-to-delimited

Convert Excel workbooks into per-sheet CSV or TSV files.

Community
Intermediate