Notion + Snowflake

Execute sql in Snowflake when updated database items occur in Notion

Keep your data management as streamlined as possible with this workflow. When changes are made to items in your Notion database, this process instantly executes a SQL command in Snowflake. This ensures both your Notion and Snowflake databases remain up-to-date, eliminating the hassle of manual updates. A perfect solution for data analysts and project managers seeking an efficient way to handle their data.

When this happens...
TriggerPolling
automatically do this!
ActionWrite

Start free with email

Start free with Google

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

Supported triggers and actions

- Database
- Data Source
- Page
Trigger
Instant
Try It
- Data SourceRequired
Trigger
Instant
Try It
- PageRequired
Trigger
Instant
Try It
- PageRequired
- Block TypeRequired
- Content
- Programming Language
- Checked
- Icon (Emoji)
Action
Write
- PageRequired
- CommentRequired
Action
Write

- Parent PageRequired
- Title
- Content
- Icon
- Cover
Action
Write
- Item IDRequired
Action
Write

- Data Source
- ItemRequired
- Content
- Content Format
Action
Write
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
Write
Retrieve a Page
This action retrieves a specific page from Notion using its ID. The page id can be a normal page or a database item.
Action
Write
- PageRequired
Action
Search
- Block IDRequired
Action
Search
- Page IDRequired
Action
Search
- TitleRequired
- Exact MatchRequired
Action
Search
- Data Source
- Advanced Query (JSON)
Action
Search
- Data Source
- Template Mode
Action
Search or write
- SQL StatementRequired
- Primary Key
Trigger
Polling
Try It
New View
Triggers when a new view is created (from yesterday onwards).
Trigger
Polling
Try It
- TableRequired
- Column NameRequired
Action
Write
- SQL StatementRequired
Action
Write
- TableRequired
- Column Name
- Where ClauseRequired
Action
Search

- Data SourceRequired
Trigger
Instant
Try It
- Data SourceRequired
Trigger
Instant
Try It
- Data Source
- PageRequired
- Properties to Watch
Trigger
Instant
Try It
- Data Source
- ItemRequired
Action
Write
- Data Source
- Template Mode
Action
Write
- PageRequired
- ContentRequired
- Content Format
Action
Write
- DatabaseRequired
- Title
- Move To
- Display Inline
- Icon (Emoji)
- Move to Trash
- Lock Database
Action
Write
- Data SourceRequired
- Title
- Icon Emoji
- Property Updates (JSON)
Action
Write
Retrieve Database
This action retrieves a database in Notion using the ID of the database.
Action
Write
- Block IdRequired
Action
Search
- Data Source
Action
Search
- Block IDRequired
- Page Size
- Start Cursor
Action
Search
- Page or Database Item IDRequired
Action
Search
- PageRequired
- PropertyRequired
Action
Search
- UserRequired
Action
Search
- The table to look for new columns on.Required
Trigger
Polling
Try It
New Table
Triggers when a new table is created.
Trigger
Polling
Try It
- TableRequired
- Columns to Return
- Updated Date ColumnRequired
- Primary Key
Trigger
Polling
Try It
- Disclaimer
- TableRequired
- Primary Key ColumnRequired
- Primary Key ValuesRequired
Action
Write
- TableRequired
- Primary Key ColumnRequired
- Primary Key ValuesRequired
- Column NameRequired
Action
Write

About Notion

A new tool that blends your everyday work apps into one. It's the all-in-one workspace for you and your team.

Related categories

Task Management

About Snowflake

Snowflake allows corporate users to store and analyze data using cloud-based hardware and software.

Learn more

Related categories

Databases

Related Zap Templates

Create new Notion database items from new rows in Snowflake

Create new Notion database items from new rows in Snowflake

Execute sql in Snowflake when new database items appear in Notion

Notion + Snowflake

Execute sql in Snowflake when updated database items occur in Notion

New Comment

Updated Content in Data Source Item

Updated Content in Page

Add Block to Page

Add Comment

Create Page

Restore Data Source Item

Update Data Source Item

API Request (Beta)

Retrieve a Page

Get Page Comments

Get Block

Get Page and Children

Find Page (By Title)

Query Data Source (Advanced)

Find or Create Database Item

New Row

New View

Create Rows

Execute SQL

Find Row

New Data Source Item

Updated Properties in Data Source Item

Updated Properties on a Page

Archive Data Source Item

Create Data Source Item

Add Content to Page

Update Database

Update Data Source Schema

Retrieve Database

Retrieve Block Children

Find Data Source Items

Get Block Children

Get Page or Data Source Item by ID

Get Page Property

Get User Details

New Column

New Table

New or Updated Row

Delete Rows

Update Rows

About Notion

Related categories

About Snowflake

Related categories

Related Zap Templates

Related Zap Templates