Pull data from a Google Sheet and write a report to Notion
Analyze spreadsheet metrics, write an executive summary, and save it to Notion automatically
Overview
Turning raw spreadsheet data into a readable summary means switching tools and writing from scratch. This template reads your metrics, identifies what changed, writes the narrative, and files it to Notion so the report is ready without the manual work.
How it works
- Opens your Google Sheet and reads data from the specified tab
- Identifies the three most significant week-over-week changes
- Writes a 200-word executive summary explaining what moved and why
- Creates a new page in your Notion database with todays date
- Saves the summary to that page
Who this is for
Analysts and ops leads who track metrics in spreadsheets and want narrative summaries written and filed automatically.
Suggested prompt
Open my Google Sheet called [1. Metrics sheet name] and read the data in the tab labeled [2. Tab name]. Identify the three most significant week-over-week changes—positive or negative—and write a 200-word executive summary explaining what moved, by how much, and what likely drove it. Then create a new page in my Notion database called [3. Database name] titled "Report - [todays date]" and paste the summary there.
Frequently asked questions
Can I change the summary length?
Yes, adjust 200-word in the prompt to any length you prefer.
What if I want to save the report to Google Docs instead?
Swap Notion for Google Docs in the prompt and connect Google Docs to your MCP server.
Can I analyze a different time period?
Yes, change week-over-week to month-over-month or any comparison period in your data.
Can I include more than three changes?
Yes, adjust the number in the prompt to highlight as many metrics as you need.