Generate weekly reports from multiple sources
Pull data from Google Sheets and Looker, flag anomalies, and write a summary to your Google Doc template
Overview
Recurring reports often require pulling numbers from multiple systems, comparing them, and writing up what changed. This template handles the data gathering and analysis, then writes the narrative directly to your report template so you can review and finalize instead of starting from scratch.
How it works
- Pulls this week data from your Google Sheets dashboard
- Cross-references against the specified metric in Looker
- Flags anomalies or trends worth highlighting
- Writes a summary to your Google Doc template
Who this is for
Ops managers, finance teams, and analysts who produce recurring reports and want to automate the data gathering and first-draft writing.
Suggested prompt
Pull this week data from [1. Dashboard name] dashboard in Google Sheets, cross-reference it against [2. Metric name] in Looker, flag any anomalies or trends worth calling out, and write a summary to my Google Doc template called [3. Document name].
Frequently asked questions
Can I use a different reporting tool instead of Looker?
Yes, swap Looker for another analytics tool connected to your MCP server, like Tableau or Power BI.
What kind of anomalies does it flag?
It identifies significant changes from previous periods, outliers, and trends that deviate from expected patterns based on the data you provide.
Can I customize the report format?
Yes, set up your Google Doc template with the structure you want, and the summary will be written into it.
Does this work for monthly or quarterly reports?
Yes, just adjust the prompt to specify the time period you need.