Notion Database Modifier

This plugin enables users to perform operations on Notion database pages, including creation, updates, and deletions.

📝 User Setting Notes:

🔧 Set Up the Plugin Server:

• A plugin server must be set up to use this feature. Follow the detailed guide to set up a plugin server on Render: How to Deploy the Plugin Server on Render

🔑 Set Up Your Notion API Key:

• Go to the Notion Integration Page and create a new integration.
• Copy the key from the Integration Detail Page.
• Paste the key into the plugin's user settings: Notion API Key: ntn_XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

For detailed instructions, visit the Notion Integration API Documentation

🔗 Share Your Database with the Integration:

• Open your database in Notion.
• Click the “Share” button in the top right.
• Select “Invite”, search for your integration name, and click “Invite” to grant access.

For detailed instructions, visit the Notion API Connections Documentation

📌 Important Notes:

👉 Database Context Requirement:

To use the plugin, you need to tell the AI your database ID along with the database structure at the beginning.

1. Obtain Your Database ID

• To get the database ID, open your Notion database as a full page in your browser.
• Copy the full URL from the address bar. The URL will look something like this: https://www.notion.so/<DATABASE_ID>?v=<VIEW_ID>
• Example URL https://www.notion.so/12345bcxyz?v=11111aaaaaa. The Database ID is: 12345bcxyz.

2. Obtain Your Database Structure

• Manually list out each property, including Name, Type, and Options (Select, Multi-select, Status).
• Use the Notion Database Structure Viewer plugin.

⚠️ Limitations:

• The plugin does not support the following property types for modification: Relation, Rollup, Verification, Formula, Unique ID.
• The files property type only supports external URLs. When updating the file property, its value will be overwritten by the array of files provided. For more details, refer to the Notion Property Value Page

👉 Rate Limits:

• There are rate limits for Notion API requests. Learn more at Notion API Rate Limits.
• There are size limits on certain parameters, as well as the depth of children in requests. Learn more at Notion API Size Limits

💡 Example Usage

• As an HR professional, I want to modify my company's employee directory. First, I need to provide the AI with the context of my database, including the database URL along with the database structure description.

Given the description of my Employee Directory Database as follows:

Notion Database URL: https://www.notion.so/12345bcxyz?v=11111aaaaaa

Database Structure:

1. Name (Title)
2. Years of Experience (Number)
3. Skills (Multi-select) - Options: Project Management, Programming, Data Analysis, Communication, Leadership, Design, Marketing, Sales, MLOps, FullStack
4. Probation Passed (Checkbox)
5. Location (Select) - Options: HQ - New York, Office - London, Office - Singapore, Remote - Domestic, Remote - International, Hybrid, Office - New York
6. Role (Select) - Options: Engineer, Manager, Designer, Analyst, Developer, Director, Coordinator, Specialist
7. LinkedIn Profile (URL)
8. Performance Review Status (Status) - Options: Not started, In progress, Done
9. Email (Email)
10. Start Date (Date)
11. Department (Select) - Options: Engineering, Marketing, Sales, HR, Finance, Operations, Customer Support, Design
12. Attachments (Files)
13. Phone (Phone Number)
14. Notes (Rich Text)

Then, I can ask the AI to modify the Notion database based on my needs. Here are some examples:

Example 1: create a new employee

Please create a new employee record for Dat Tran with the following details: Years of Experience: 5 Skills: Project Management, Data Analysis, Leadership Location: Office - Vietnam Role: Developer Email: [email protected] Start Date: 2024-06-15 Department: Engineering Phone: +44 20 7946 0958 Notes: Strong leadership and problem-solving skills with a focus on system architecture.

Example 2: Update an existing employee

Update the Name to Dylan Tran and Linkedin to https://www.linkedin.com/in/dylantransample

Example 3: Remove an employee by name

Remove Employee Name “Dylan Tran”