Your revenue dashboard updates instantly as Notion deals change
Update a deal in Notion and your Google Sheets revenue chart refreshes automatically. Real-time visibility, no manual charting.
Trigger
Page Updated
Triggers when any block within a specified Notion page is updated.
Action
Create Chart in Google Sheets
Create a chart in a google sheets spreadsheet using the specified data range and chart type.
Why this helps
You track sales deals in Notion and want a visual revenue chart in Google Sheets for dashboards or investor calls, but charts go stale when deals change. You end up manually re-running the chart, or the dashboard becomes unreliable.
- Charts update in real-time as deals move through the pipeline
- Dashboard always reflects current deal state for investor or team updates
- No manual chart recreation or data manipulation
- Visual trends are immediately visible for quick decision-making
Setup
Build it in a few focused steps.
- 1Connect Notion and Google Sheets to Notis.
- 2Create an automation called 'Revenue Tracker Charts' with trigger 'Page Updated' in your Notion deals database.
- 3Tell Notis: 'When a deal or stage changes in Notion, update the revenue chart in Google Sheets to show pipeline value by stage and total deal count'.
- 4Specify which Google Sheets file and which chart(s) to update.
- 5Test by changing a deal's stage in Notion and watch the chart update in seconds.
Questions about this workflow
Which deal properties affect the chart?
Whatever you tell Notis to include: deal value, stage, close date, probability, or win/loss status. The chart updates based on those properties.
Can I have multiple charts (one for pipeline, one for forecast)?
Yes. You can set up the automation to update multiple charts, or create separate automations for different chart types.
What if a deal is deleted in Notion?
The chart recalculates to remove that deal from the totals. Notis handles the math automatically.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Notion to Google Sheets. A trigger fires from one place; an action lands in another.
Notion triggers
Google Sheets actions
All Page Events
Triggers when any Notion page is created or updated across the workspace.
Add Sheet to Spreadsheet
Adds a new sheet (worksheet) to a spreadsheet. use this tool to create a new tab within an existing google sheet, optionally specifying its title, index, size, and other properties.
Comment Created
Triggers when a new comment is created in Notion. Optional `page_id` filter scopes to comments on a specific page. When omitted, fires for any new comment in the workspace the integration has access to. Requires the 'Read comments' capability on the Notion integration. If a connection was authorized before that capability was enabled, the user must re-authorize the connection for comment events to flow.
Aggregate Column Data
Searches for rows where a specific column matches a value and performs mathematical operations on data from another column.
New Comment
Triggers when a new comment is added to a specified Notion block or page.
Append Dimension
Tool to append new rows or columns to a sheet, increasing its size. use when you need to add empty rows or columns to an existing sheet.
Database Created
Triggers when a new Notion database (the container) is created. A database is the post-2025-09-03 container that holds one or more data sources. This trigger fires for the container's creation event (`database.created`), distinct from `NOTION_DATASOURCE_CREATED` which fires when a new data source is added to an existing database. Most customers calling Notion's `POST /v1/databases` (the legacy API) or creating a database via the Notion UI will see this event. Adding a new data source to an existing database fires `data_source.created` instead — use `NOTION_DATASOURCE_CREATED` for that. Notion's payload puts `entity.type: "block"` (the container is a `child_database` block in the content tree) and `entity.id` is the database id.
Batch get spreadsheet
Retrieves data from specified cell ranges in a google spreadsheet; ensure the spreadsheet has at least one worksheet and any explicitly referenced sheet names in ranges exist.
Data Source Created
Triggers when a new Notion data source is created. Fires workspace-wide. The payload's `data.parent` carries the data source's tree parent (typically the teamspace) for downstream filtering. A single template-based database creation can fire multiple `data_source.created` events at once — one per data source the template instantiates.
Batch update spreadsheet
Updates a specified range in a google sheet with given values, or appends them as new rows if `first cell location` is omitted; ensure the target sheet exists and the spreadsheet contains at least one worksheet.
Data Source Schema Updated
Triggers when a Notion data source's schema is updated. Fires on column add / remove / rename. Payload includes `data.updated_properties: [{id, name, action}]` so consumers can discriminate the kind of change downstream. Optional `data_source_id` filter scopes to schema changes on a single data source. When omitted, fires for any schema change in the workspace the integration has access to. Note: adding a column also fires `page.properties_updated` once per existing row in the data source. Customers wanting a single structural-change signal should use this trigger.
Batch Update Values by Data Filter
Tool to update values in ranges matching data filters. use when you need to update specific data in a google sheet based on criteria rather than fixed cell ranges.
New Page
Triggers when a new page is added to a Notion database.
Clear Basic Filter
Tool to clear the basic filter from a sheet. use when you need to remove an existing basic filter from a specific sheet within a google spreadsheet.
Page Added to Page
Fires when a new subpage (a `child_page` type block) is added under a specified parent Notion page.
Clear spreadsheet values
Clears cell content (preserving formatting and notes) from a specified a1 notation range in a google spreadsheet; the range must correspond to an existing sheet and cells.
Connect any two apps with Notis in the middle.
Not just Notion and Google Sheets. 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 Google Sheets.