Connect Snowflake to Notion

Build an AI agent that works across Snowflake and Notion, on a schedule or when you click Run.

7 source actions

24 target actions

Reverse direction supported

Start building Have us set it up (A$490)Browse Snowflake integrations

Why Connect Snowflake & Notion?

Read what you need from Snowflake

Your agent uses Snowflake's documented actions to pull the records it needs, each time it runs.

Run a Notion action

Then it uses one of 24 documented actions, such as Append Block to Parent, Complete File Upload, Create Comment.

Test it, then put it on a schedule

Run it once on your own data and check the result. Then set it to run daily, on weekdays or weekly.

Available Triggers & Actions

Snowflake

Triggers (12)

New Row

Emit new event when a row is added to a table

polling

New Query Results

Run a SQL query on a schedule, triggering a workflow for each row of results

polling

Failed Task in Schema

Emit new events when a task fails in a database schema

polling

New Database

Emit new event when a database is created

polling

New Deleted Role

Emit new event when a role is deleted

polling

New Deleted User

Emit new event when a user is deleted

polling

New Role

Emit new event when a role is created

polling

New Schema

Emit new event when a schema is created

polling

New Table

Emit new event when a table is created

polling

New Update Role

Emit new event when a role is updated

polling

New Update User

Emit new event when a user is updated

polling

New Usage Monitor

Emit new event when a query is executed in the specified params

polling

Actions (7)

Execute SQL Query

Execute a custom Snowflake query. See our docs to learn more about working with SQL in Mazaal AI.

Insert Multiple Rows

Insert multiple rows into a table

Insert Single Row

Insert a row into a table

List Database Options

Retrieves available options for the Database field.

List User Name Options

Retrieves available options for the User Name field.

List Warehouse Name Options

Retrieves available options for the Warehouse Name field.

Query SQL Database

Execute a SQL Query. See our docs to learn more about working with SQL in Mazaal AI.

Notion

Triggers (9)

New Comment Created

Emit new event when a new comment is created in a page or block. See the documentation

polling

New Data Source Created

Emit new event when a data source is created. See the documentation

polling

New or Updated Page in Data Source (By Property)

Emit new event when a page is created or updated in the selected data source. See the documentation

polling

New or Updated Page in Data Source (By Timestamp)

Emit new event when a page is created or updated in the selected data source. See the documentation

polling

New Page in Data Source

Emit new event when a page is created in the selected data source. See the documentation

polling

New Webhook Event (Instant)

Emit new event each time a webhook event is received. Webhook must be setup in Notion. See the documentation

webhook

Page or Subpage Updated

Emit new event when the selected page or one of its sub-pages is updated. See the documentation

polling

Page Properties Updated (Instant)

Emit new event each time a page property is updated in a data source. For use with Page Properties Updated event type. Webhook must be set up in Notion. See the documentation

webhook

Page Updated

Emit new event when a selected page is updated. See the documentation

polling

Actions (24)

Append Block to Parent

Append new and/or existing blocks to the specified parent. See the documentation

Complete File Upload

Use this action to finalize a mode=multi_part file upload after all of the parts have been sent successfully. See the documentation

Create Comment

Create a comment in a page or existing discussion thread. See the documentation

Create Database

Create a database and its initial data source. See the documentation

Create File Upload

Create a file upload. See the documentation

Create Page

Create a page from a parent page. See the documentation

Create Page from Data Source

Create a page from a data source. See the documentation

Delete Block

Sets a Block object, including page blocks, to archived: true using the ID specified. See the documentation

Duplicate Page

Create a new page copied from an existing page block. See the documentation

Find Pages or Data Sources

Searches for a page or data source. See the documentation

Get Current User

Retrieve the Notion identity tied to the current OAuth token, returning the full users.retrieve payload for me (person or bot). Includes the user ID, name, avatar URL, type (person vs bot), and workspace ownership metadata—useful for confirming which workspace is connected, adapting downstream queries, or giving an LLM the context it needs about who is operating inside Notion. See the documentation.

List All Users

Returns all users in the workspace. See the documentation

List File Uploads

Use this action to list file uploads. See the documentation

Query Data Source

Query a data source with a specified filter. See the documentation

Retrieve Data Source Content

Get all content of a data source. See the documentation

Retrieve Data Source Schema

Get the property schema of a data source in Notion. See the documentation

Retrieve File Upload

Use this action to retrieve a file upload. See the documentation

Retrieve Page Content

Get page content as block objects or markdown. Blocks can be text, lists, media, a page, among others. See the documentation

Retrieve Page Metadata

Get details of a page. See the documentation

Retrieve Page Property Item

Get a Property Item object for a selected page and property. See the documentation

Retrieve User

Returns a user using the ID specified. See the documentation

Send File Upload

Send a file upload. See the documentation

Update Child Block

Updates a child block object. See the documentation

Update Data Source

Update a data source. See the documentation

Integration Features

7 documented Snowflake actions

24 documented Notion actions

Plain-English agent instructions

Daily, weekday or weekly schedule, or run on demand

Execution monitoring

A supported Notion to Snowflake direction

Capability Examples

Snowflake trigger → Notion action

Catalog example

Snowflake

New Row

Notion

Append Block to Parent

Notion trigger → Snowflake action

Reverse direction

Notion

New Comment Created

Snowflake

Execute SQL Query

How It Works

Connect Apps

Authenticate your Snowflake and Notion accounts

Describe the Job

Say what to read from Snowflake and what to do in Notion

Choose an Action

Select the documented Notion operation to run

Test and Review

Verify field mapping and provider responses before activation

Frequently Asked Questions

Integration Benefits

Scheduled or On-demand Runs

Runs daily, on weekdays or weekly at a set time, or when you click Run. It does not fire on live Snowflake events yet.

Automated Actions

Use 24 documented Notion actions each time the agent runs.

Provider Authentication

Review the authentication requirements published by each provider before activating the workflow.

Guided Configuration

Describe the job in plain English. The agent picks theSnowflake and Notion actions it needs.

Your Own Accounts

You connect your own Snowflake and Notion accounts. App connections need a paid plan.

Execution Review

Test the workflow and review provider responses before relying on it in production.

Reverse Integration Available

Also connect Notion to Snowflake for bidirectional automation

View Integration

All Snowflake Integrations

Explore all available Snowflake connections

View All Integrations

All Notion Integrations

Explore all available Notion connections

View All Integrations

Popular Integrations

View all integrations →

More Notion Integrations

View all Notion integrations →

Ready to Connect Snowflake & Notion?

Build this agent in Mazaal AI and test it on your ownSnowflake and Notion data.

Start building

Rather not build it yourself? We set up one Snowflake to Notion agent on your accounts for A$490: a 30-minute call, a test on your real data, and 14 days of fixes. Plan billed separately. Email Enod

Connect Snowflake to Notion

Why Connect Snowflake & Notion?

Read what you need from Snowflake

Run a Notion action

Test it, then put it on a schedule

Available Triggers & Actions

Snowflake

Triggers (12)

Actions (7)

Notion

Triggers (9)

Actions (24)

Integration Features

Capability Examples

Snowflake trigger → Notion action

Notion trigger → Snowflake action

How It Works

Connect Apps

Describe the Job

Choose an Action

Test and Review

Frequently Asked Questions

Is the Snowflake to Notion direction supported?

Does it run the moment something changes in Snowflake?

Which Notion actions are available?

Can I also connect Notion to Snowflake?

Integration Benefits

Scheduled or On-demand Runs

Automated Actions

Provider Authentication

Guided Configuration

Your Own Accounts

Execution Review

Reverse Integration Available

All Snowflake Integrations

All Notion Integrations

Popular Integrations

More Notion Integrations

Ready to Connect Snowflake & Notion?