Assemble a weekly metrics brief from Google Sheets
The useful report starts with a named sheet and a bounded range. Keep the reporting period and any missing or inconsistent values visible instead of filling gaps with assumptions.
For an operations or product lead preparing a weekly review from a spreadsheet.
What needs to be in place
- In My apps, add Google Sheets and connect an account with access to the intended spreadsheet.
- A spreadsheet, worksheet, A1 range, and reporting period. Check that the selected range contains the expected header and date columns.
In My apps, add the apps listed above and connect the accounts you want your AI client to use. Then connect your AI client to Weavz. A workspace template is optional: it can configure app access and defaults, but your AI client runs the task.
Work through the selected sources
The exact actions available depend on the integrations and actions enabled in the workspace. These steps keep the task bounded to the account and records you selected.
Choose the reporting range
Select a spreadsheet and worksheet, then provide an A1 range narrow enough to cover the reporting period.
Check the returned rows
Confirm the date and metric columns. Call out missing values, duplicate rows, or inconsistent units before summarizing.
Write the brief
Describe changes the values support, show the range and period used, and list questions that need an owner to resolve.
App actions and developer details
Action names and inputs
These details help when configuring or implementing the task. You can follow the guide without starting from the action identifiers.
google-sheets.read_rangeRead values from the selected sheet and A1 range.
Required inputs:
range
A starting instruction for your AI client
Replace bracketed details with the records and scope you chose. Review the returned result against its sources.
Example instruction
Read [spreadsheet and worksheet] range [A1 range] for [reporting period]. Prepare a weekly metrics brief with the measures, changes directly supported by the data, and data-quality questions. State the source range and period. Do not edit the spreadsheet, invent targets, or compare periods that are not included in the selected data.
What the result contains
A short metrics narrative tied to one visible source range and an explicit reporting period.
Keep the source trail with it
Include the spreadsheet, worksheet, A1 range, and period in the first line of the brief so another operator can reproduce the read.
Keep drafts and writes separate
This task reads the sheet and returns a draft. Updating rows, writing another sheet, or posting the report to Slack requires a separate destination and write action.
If a source or connection is missing
If the range is too large or headers are unclear, narrow the selection and confirm the units with the spreadsheet owner before interpreting it.
Set up the accounts and task
Optional workspace template: Data Ops Workbench.
Integrations
- Google Sheets
Read a specified A1 range from a spreadsheet.
Includes Google Sheets for reports and structured records. The example asks for a discrepancy report; select your own range for this brief.