Keep Notion Pages Fresh with Live Spreadsheet Metrics
Tired of manually copying numbers from your Google Sheet into Notion? Notis watches your aggregate metrics (sums, counts, averages) and posts updates to Notion automatically, so your status pages stay current.
Trigger
Aggregate Metric Changed
Triggers when an aggregate metric (SUM/COUNT/AVG/MIN/MAX) changes in a Google Sheets spreadsheet. This trigger monitors an aggregate calculation on a target column (optionally filtered by a search column/value) and fires when the calculated result changes.
Action
Add multiple content blocks (bulk, user-friendly)
Efficiently adds multiple standard content blocks to a notion page in a single api call with automatic markdown parsing. the 'content' field in notionrichtext blocks now automatically detects and parses markdown formatting including headers (# ## ###), bold (**text**), italic (*text*), strikethrough (~~text~~), inline code (`code`), links ([text](url)), and more. ideal for bulk content creation, ai agents, and replacing multiple individual add page content calls. supports automatic text formatting, content splitting, and up to 100 blocks per request.
Why this helps
Founders often maintain a single source of truth in Google Sheets (like a live sales pipeline), but then create manual snapshots in Notion for reporting. These get stale. Updating them is repetitive busywork that drains focus.
- Status pages in Notion always reflect the latest data
- No more manual copying of metrics
- Stakeholders see fresh numbers without asking
- Reduces cognitive overhead of 'did I forget to update this?'
Setup
Build it in a few focused steps.
- 1Connect Google Sheets and Notion to Notis.
- 2Create an automation with: 'When my [metric name, e.g., total pipeline value] aggregate in Google Sheets changes, post an updated summary to my Notion status page.'
- 3Select the Google Sheets aggregate-metric trigger and specify which column to sum, count, or average (optionally with a filter).
- 4Choose the Notion page where summaries will be posted and select your alert channel.
- 5Test by adding a row to the Sheet that affects your aggregate and confirm the Notion page gets updated within a few minutes.
Questions about this workflow
Which aggregates are supported?
SUM, COUNT, AVG, MIN, and MAX. You can also optionally filter before aggregating (e.g., count only rows marked 'active').
How do I control the format of the post in Notion?
Describe it in your prompt. For example: 'Post the count as a bold number followed by the date updated.' Notis will format it accordingly.
Can I post to multiple Notion pages?
Yes, you can create separate automations for different pages or ask Notis to post summary updates to multiple locations in a single automation.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Sheets to Notion. A trigger fires from one place; an action lands in another.
Google Sheets triggers
Notion actions
Aggregate Metric Changed
Triggers when an aggregate metric (SUM/COUNT/AVG/MIN/MAX) changes in a Google Sheets spreadsheet. This trigger monitors an aggregate calculation on a target column (optionally filtered by a search column/value) and fires when the calculated result changes.
Add multiple content blocks (bulk, user-friendly)
Efficiently adds multiple standard content blocks to a notion page in a single api call with automatic markdown parsing. the 'content' field in notionrichtext blocks now automatically detects and parses markdown formatting including headers (# ## ###), bold (**text**), italic (*text*), strikethrough (~~text~~), inline code (`code`), links ([text](url)), and more. ideal for bulk content creation, ai agents, and replacing multiple individual add page content calls. supports automatic text formatting, content splitting, and up to 100 blocks per request.
Cell Range Values Changed
Triggers when values in a specified A1 range change in Google Sheets. This trigger monitors a specific cell or range of cells and fires when any values change.
Add content to Notion page
Deprecated: appends a single content block to a notion page or a parent block (must be page, toggle, to-do, bulleted/numbered list, callout, or quote); invoke repeatedly to add multiple blocks.
Conditional Format Rule Changed
Triggers when conditional formatting rules change in a Google Spreadsheet. Detects when rules are added, updated, or removed. Uses snapshot-based diffing to detect changes between polls.
Append complex blocks (advanced, full control)
Appends complex blocks with full notion block structure to a parent block or page. use for advanced scenarios requiring precise control: code blocks, tables, embeds, nested children within blocks, or when working with pre-built notion block objects. requires full notion api block schema - use add multiple page content for simpler content creation.
Data Validation Rule Changed
Triggers when data validation rules change (added/updated/removed) in a Google Spreadsheet. Uses snapshot-based diffing to detect changes between polls.
Archive Notion Page
Archives (moves to trash) or unarchives (restores from trash) a specified notion page.
Developer Metadata Changed
Triggers when developer metadata entries change (new/updated/removed) in a Google Spreadsheet. Uses snapshot-based diffing to detect changes between polls.
Create comment
Adds a comment to a notion page (via `parent page id`) or to an existing discussion thread (via `discussion id`); cannot create new discussion threads on specific blocks (inline comments).
Filtered Range Values Changed
Polling trigger that monitors Google Sheets filtered ranges for value changes. Uses snapshot-based diffing to detect when values matching a data filter change. Emits the matched values when changes are detected.
Create Notion Database
Creates a new notion database as a subpage under a specified parent page with a defined properties schema; use this action exclusively for creating new databases.
New Rows in Google Sheet
Simple polling trigger that monitors Google Sheets for new rows. Detects when new rows are added and returns the complete row data. Perfect for triggering any workflow based on new sheet entries.
Create Notion page
Creates a new empty page in a notion workspace.
New Sheet Added in Google Spreadsheet
Polling trigger that detects when a new sheet is added to a Google Spreadsheet.
Delete a block
Archives a notion block, page, or database using its id, which sets its 'archived' property to true (like moving to "trash" in the ui) and allows it to be restored later.
Connect any two apps with Notis in the middle.
Not just Google Sheets and Notion. Any combination from 985+ integrations.
When this happens · Trigger
Do this · Action
Save your first hour today.
7 days free trial with 20$ free usage included.
No card. Works with personal or business Notion.