Using Notion API in Python to Automate Page Operations

steps

1. Set up the API token and database ID: Define the API token and database ID as string variables inside a Python script.

   pythonCopy

   notion_token = "YOUR_API_TOKEN"
   database_id = "YOUR_DATABASE_ID"

2. Configure headers for API requests: Create a dictionary for the headers. Make sure this code is placed after defining notion_token.

   pythonCopy

   headers = {
       "Authorization": f"Bearer {notion_token}",
       "Content-Type": "application/json",
       "Notion-Version": "2022-06-28"
   }

3. Query the database to retrieve pages: Write a function to get all pages from the database.

   pythonCopy

   import requests
   
   def get_pages(database_id, headers):
       url = f"https://api.notion.com/v1/databases/{database_id}/query"
       response = requests.post(url, headers=headers)
       pages = response.json()
       return pages.get("results", [])

4. Add new pages to the database: Create a helper function to add pages.

   pythonCopy

   def create_page(database_id, properties, headers):
       url = "https://api.notion.com/v1/pages"
       payload = {
           "parent": {"database_id": database_id},
           "properties": properties
       }
       response = requests.post(url, headers=headers, json=payload)
       return response.status_code == 200

5. Update existing pages: Write a function to modify page properties.

   pythonCopy

   def update_page(page_id, properties, headers):
       url = f"https://api.notion.com/v1/pages/{page_id}"
       payload = {"properties": properties}
       response = requests.patch(url, headers=headers, json=payload)
       return response.status_code == 200

6. Delete pages from the database: Archive a page using the patch method to update archived status.

   pythonCopy

   def delete_page(page_id, headers):
       url = f"https://api.notion.com/v1/pages/{page_id}"
       payload = {"archived": True}
       response = requests.patch(url, headers=headers, json=payload)
       return response.status_code == 200

Verify each step with test cases, input-output formats, and debug messages for success.

# Install the requests library
pip install requests

# Run the sample script to verify operations
python automate_notion.py
# Verify output locally: check printed page data and updates