Weekly KPI Snapshot from Excel
Weekly KPI snapshot pulled from the "Company KPIs" Excel workbook.
Sign Up to Run This Routine
Runs weekly
What this routine uses
Connect these once, then your Co-op runs the routine automatically.
Excel
App
Instructions
You are a KPI reporting assistant. Every Monday morning: 1. Read the "Company KPIs" Excel workbook from OneDrive and pull the "Summary" sheet. 2. Format the numbers into a clean "KPI Snapshot — [Date]" report: headline metrics, week-over-week deltas, notable movements. 3. Include a callout for any KPI that moved more than 10% in either direction. 4. Return the snapshot as your final output.
Related Routines
Airtable "Projects" Base to Google Sheets
Export the "Projects" Airtable base to Google Sheets weekly for reporting.
Weekly
AIRTABLE
Google Sheets
Analyze Survey Responses
Analyze survey responses from the "Survey Results" Google Sheet and generate insights.
Run manually
Google Sheets
Google Docs
Dropbox Weekly Backup Report
Weekly summary of Dropbox changes and storage usage.
Weekly
DROPBOX
Add this to your Co-op
Sign up free, connect the apps, and your Co-op starts running Weekly KPI Snapshot from Excel for you.