Notion - Upload File from Workflows to Notion Database

Overview

Quickly upload a file to a Notion Database. Unsupported Notion datatypes for upload are: - Files - People - Rollup - Relation - Formula When uploading a file to a database in Notion, you have two options from Workflows: to replace an existing database or to append to an existing database. #### Replace When the `Replace` insert method is selected, this will do one of two things: 1) create a new database or 2) overwrite an existing database. The inputs provided will determine the behaviour. For instance, if the `Database ID` is provided, the blueprint will attempt to overwrite that existing database. If the `Database ID` is not provided, the blueprint will attempt to create a new database, but in order to do so the `Page ID` of where the new database will live is required. Additionally, when creating a new database, you can optionally provide the `Database Name`, not providing the `Database Name` will result in the created database being named "Untitled." #### Append When the `Append` insert method is selected, the blueprint will attempt to add new rows to an existing database. In order to do so, the `Database ID` is required, failing to provide it will result in an error. **NOTE** - existing schemas and datatypes are strictly enforced. If there is a mismatch in datatypes for data being loaded, it will fail.

Variables

Name	Reference	Type	Required	Default	Options	Description
Access Token	NOTION_ACCESS_TOKEN	Password	✅	-	-	The access token assigned to the integration created
Database ID	NOTION_DATABASE_ID	Alphanumeric	➖	-	-	The ID of the notion database found in the URL. Is necessary if `Append` is selected
Page ID	NOTION_PAGE_ID	Alphanumeric	➖	-	-	The parent page ID where the Database will reside. Is only necessary if `Replace` is selected and the database doesn't exist.
Database Name	NOTION_DATABASE_NAME	Alphanumeric	➖	-	-	The optional name of the database to be created. If `Replace` is selected and the database doesn't exist, this will provide a name for the one that is created
Source File Name	NOTION_FILE_NAME	Alphanumeric	➖	-	-	The name of the file to load to Notion
Source Folder Name	NOTION_FOLDER_NAME	Alphanumeric	➖	-	-	The optional name of the folder containing the file to load to Notion
Insert Method	NOTION_INSERT_METHOD	Select	➖	append	Append: append Replace: replace	The option to overwrite an existing database, or append additional rows

YAML

Below is the YAML template

YAML


source:
  template: Notion - Upload File from Workflows to Notion Database
  inputs:
    NOTION_ACCESS_TOKEN:
    NOTION_DATABASE_ID:
    NOTION_PAGE_ID:
    NOTION_DATABASE_NAME:
    NOTION_FILE_NAME:
    NOTION_FOLDER_NAME:
    NOTION_INSERT_METHOD: append
  type: TEMPLATE
guardrails:
  retry_count: 1
  retry_wait: 0h0m0s
  runtime_cutoff: 1h0m0s
  exclude_exit_code_ranges:
    - 200
    - 201
    - 202
    - 203
    - 204
    - 205
    - 206
    - 249