How to Automate Notion Databases with AI Prompts

# Content Agency Blog Automation Workflow

## 1. Workflow Overview
This workflow turns a bare-bones article entry (title + keyword) into a fully scoped brief. Notion AI Autofill generates SEO assets on creation, while a Button property triggers writer assignment based on category, letting you move from idea to assigned draft in one click.

## 2. Database Schema

| Property Name | Type | Purpose |
|---|---|---|
| Article Title | Title | Working headline |
| Target Keyword | Text | Primary SEO keyword |
| Category | Select | Topic bucket (e.g., SaaS, Health, Finance) |
| Meta Description | AI Autofill (Text) | SEO snippet |
| Suggested H2s | AI Autofill (Text) | Three outline headings |
| Summary Angle | AI Autofill (Text) | One-line hook |
| Writers | Relation | Linked Writers database |
| Assigned Writer | Relation | Final assignee |
| Status | Status | Idea → Briefed → Drafting → Done |
| Assign Writer | Button | Runs assignment logic |

## 3. Step-by-Step Automation Setup

1. **Create the database** with properties above. Build a companion *Writers* database with a `Specialty` Select property matching your `Category` options.
2. **Set Status default to "Idea"** and configure an automation: *When page added → Set Status to "Idea"*.
3. **Enable AI Autofill on Meta Description** with "Update automatically" toggled on, so it regenerates when Title or Keyword changes.
4. **Enable AI Autofill on Suggested H2s and Summary Angle** with the same auto-update setting. This gives you a full brief the moment you type a title.
5. **Configure the Assign Writer Button** with these actions:
   - Edit property → `Assigned Writer` → use a Formula-driven lookup, OR manually add conditional steps: *If Category is "SaaS", set Assigned Writer to [Writer A]*, repeat per category.
   - Edit property → `Status` → "Briefed".
   - Send notification to assigned writer.
6. **Add a Formula property "Brief Ready?"** returning ✅ when Meta Description, Suggested H2s, and Assigned Writer are all filled — use this as a Kanban filter.

## 4. Example AI Prompts

**Meta Description (AI Autofill):**
```
Write a 150-character SEO meta description for an article titled "Article Title" targeting the keyword "Target Keyword". Use active voice, include the keyword once naturally, and end with a benefit-driven call to action. Return only the description text.
```

**Suggested H2s (AI Autofill):**
```
Generate three H2 subheadings for a blog post titled "Article Title" optimized for the keyword "Target Keyword". Each heading should cover a distinct angle (problem, solution, example). Format as a numbered list. Return only the list.
```

**Summary Angle (AI Autofill):**
```
In one sentence under 25 words, describe the unique angle this article should take given the title "Article Title" and keyword "Target Keyword". Write it as a directive to the writer.
```

## 5. Testing & Iteration Tips

- **Test with three sample titles** across different categories to confirm AI Autofill triggers and the Button routes correctly.
- **Refine prompts iteratively**: if meta descriptions feel generic, add brand tone cues (e.g., "Use a confident, consultative tone").
- **Audit weekly** using the "Brief Ready?" Formula — any ❌ row signals a broken autofill or missing category.
- **Expand the Button** later with steps to create a linked page in a Drafts database or post to Slack via a connected automation.
- **Lock AI properties** after approval by copying values into a plain Text field so regeneration doesn't overwrite finalized copy.

# Notion AI Automation Workflow: Content Agency Blog Post Management

## Workflow Overview
This automation transforms raw article ideas into structured briefs by using AI Autofill properties to generate SEO meta descriptions and H2 heading suggestions, then routes assignments to writers via a button action based on topic category. Once you enter a title and keyword, a single button click triggers AI generation and auto-assigns the post to the appropriate writer.

## Database Schema

| Property Name | Property Type | Purpose |
|---|---|---|
| Title | Text | Article title (manual input) |
| Target Keyword | Text | Primary SEO keyword (manual input) |
| Topic Category | Select | Options: Tech, Marketing, Design, Sales (manual input) |
| SEO Meta Description | AI Autofill | Auto-generated 160-character meta description |
| H2 Headings | AI Autofill | Three suggested section headings |
| Assigned Writer | Relation | Links to Writer database filtered by category |
| Status | Select | Draft → In Progress → Review → Published |
| Generate & Assign | Button | Triggers all AI generation and assignment |

## Step-by-Step Automation Setup

**1. Create the Writer Database**
Build a separate "Writers" database with properties: Name (Text), Specialty (Select: Tech/Marketing/Design/Sales), Capacity (Number). This is the lookup table for assignments.

**2. Add SEO Meta Description AI Autofill Property**
Create a new property → AI Autofill → Configure to trigger when Title and Target Keyword are filled. Paste the prompt below into the AI configuration.

**3. Add H2 Headings AI Autofill Property**
Create another AI Autofill property that triggers on the same conditions (Title + Target Keyword filled). Use the second prompt below.

**4. Create the Assigned Writer Relation**
Add a Relation property linking to your Writers database. Set it to auto-fill using a Formula that matches the current page's Topic Category to the Writer's Specialty.

**5. Build the Generate & Assign Button**
Create a Button property named "Generate & Assign." Configure it to:
- Trigger both AI Autofill properties (SEO description + H2 headings)
- Execute the Relation formula to assign the writer
- Update Status to "In Progress"

**6. Test with Sample Data**
Create a test article idea, fill Title/Keyword/Category, then click "Generate & Assign" to verify all three automation layers work.

## Example AI Prompts

**SEO Meta Description Prompt:**
```
Write a compelling SEO meta description under 160 characters for a blog post titled "{Title}" targeting the keyword "{Target Keyword}". The description should include the keyword naturally, be action-oriented, and encourage clicks from search results.
```

**H2 Headings Prompt:**
```
Generate three SEO-optimized H2 heading suggestions for a blog post titled "{Title}" that targets "{Target Keyword}". Each heading should be 5-8 words, incorporate the keyword or related terms naturally, and represent logical content sections. Format as a numbered list.
```

## Testing & Iteration Tips

- Test with 2-3 sample articles across different categories before going live
- Monitor generated meta descriptions for character count accuracy; adjust prompt if needed
- Validate that writer assignments match category expectations
- A/B test prompt variations (e.g., "compelling" vs. "conversion-focused") to find your tone preference
- Once confident, batch-process your backlog by running the button on existing idea entries

Here is the complete AI-powered workflow for your Notion content agency.

### 1. Workflow Overview

This workflow uses a database button to trigger three AI Autofill properties simultaneously. When you provide an article's title, keyword, and category, a single click will generate an SEO meta description, suggest H2 headings, and recommend the best writer for the job from a separate writers database.

### 2. Database Schema

You will need two databases: **Content** and **Writers**.

**Content Database**
| Property Name | Property Type |
| :--- | :--- |
| Article Title | Title |
| Keyword | Text |
| Category | Select |
| Meta Description | AI Autofill |
| H2 Suggestions | AI Autofill |
| Suggested Writer | AI Autofill |
| Assigned Writer | Relation |
| Generate Draft | Button |

**Writers Database**
| Property Name | Property Type |
| :--- | :--- |
| Writer Name | Title |
| Specialty | Multi-select |

### 3. Step-by-Step Automation Setup

1.  **Create Databases:** Build the two databases above: `Content` and `Writers`. Populate the `Writers` database with your team's names and their topic specialties (e.g., "SaaS," "Marketing," "Finance").
2.  **Create Relation:** In the `Content` database, create the `Assigned Writer` property. Set its type to `Relation` and connect it to the `Writers` database.
3.  **Configure AI Autofill Properties:** In the `Content` database, create the three `AI Autofill` properties (`Meta Description`, `H2 Suggestions`, `Suggested Writer`). Paste the corresponding prompts from the section below into each one. In their settings, change the trigger from "On creation & property edit" to **"Manual update only"**.
4.  **Create the Button:** Create the `Generate Draft` property and set its type to `Button`.
5.  **Configure the Button Action:** Click "Add action" for the button. Select **"Edit pages in..."** and choose your `Content` database.
6.  **Set Button Properties:** Set the action to edit the following three properties:
    *   `Meta Description` -> **Update property**
    *   `H2 Suggestions` -> **Update property**
    *   `Suggested Writer` -> **Update property**
    This configuration tells the button to trigger the manually-updated AI properties all at once.

### 4. Example AI Prompts

**For the `Meta Description` AI Autofill property:**
```
Based on the page title and its 'Keyword' property, write a compelling, SEO-optimized meta description. Ensure it is under 160 characters and naturally includes the keyword.
```

**For the `H2 Suggestions` AI Autofill property:**
```
Based on the page title and its 'Keyword' property, suggest three distinct and engaging H2 headings for a blog post. Format the output as a numbered list.
```

**For the `Suggested Writer` AI Autofill property:**
*Replace the names and specialties in the brackets with your actual team.*
```
Based on this page's 'Category' property, suggest the best writer from this list: [Anna (SaaS, B2B), Tom (Finance, Fintech), Chloe (Marketing)]. Only return

### 1. Workflow Overview
Add a new page to your Blog Posts database with just Title and Target Keyword. Chained AI Autofill properties automatically infer Topic Category from those inputs, assign the best Writer based on category, generate an SEO Meta Description, and suggest three H2 headings. Use the Regenerate Content button to clear and refresh AI outputs.

### 2. Database Schema
| Property Name | Type | Configuration |
|---------------|------|---------------|
| Title | Title | - |
| Target Keyword | Text | - |
| Topic Category | Select | Options: Technology, Health & Wellness, Business & Finance |
| Assigned Writer | Select | Options: Alex Johnson (Technology), Maria Lopez (Health & Wellness), David Kim (Business & Finance) |
| SEO Meta Description | Text | AI Autofill |
| Suggested H2 Headings | Rich text | AI Autofill |
| Regenerate Content | Button | See setup |

### 3. Step-by-Step Automation Setup
1. In your Blog Posts database, add missing properties per schema. Create Select options exactly as listed.
2. Select Topic Category property > Turn on AI Autofill > Paste the Topic Category prompt (section 4).
3. Select Assigned Writer > Turn on AI Autofill > Paste the Assigned Writer prompt.
4. Select SEO Meta Description > Turn on AI Autofill > Paste the SEO Meta Description prompt.
5. Select Suggested H2 Headings > Turn on AI Autofill > Paste the Suggested H2 Headings prompt.
6. Add Regenerate Content Button property > Edit > Add action: "Edit pages" > Clear Topic Category, Assigned Writer, SEO Meta Description, Suggested H2 Headings (set to empty).

### 4. Example AI Prompts
**Topic Category:**
```
You classify article ideas. Title: {{Title}}. Keyword: {{Target Keyword}}. Choose **exactly one**: Technology, Health & Wellness, Business & Finance. Output ONLY the category name.
```

**Assigned Writer:**
```
You assign writers by category. Category: {{Topic Category}}. Title: {{Title}}. Matches: Alex Johnson (Technology), Maria Lopez (Health & Wellness), David Kim (Business & Finance). Output ONLY the full writer name.
```

**SEO Meta Description:**
```
You craft SEO meta descriptions. For "{{Title}}" targeting "{{Target Keyword}}", write an engaging 120-160 char summary. Include keyword early. Output ONLY the description.
```

**Suggested H2 Headings:**
```
You suggest outlines. For "{{Title}}" with keyword "{{Target Keyword}}", propose **exactly 3** H2 headings. Use • bullets. Output ONLY the bulleted list.
```

### 5. Testing & Iteration Tips
Create test page, fill Title/Keyword, wait 10-30s for chain (category first, then others). Edit Title to retrigger. Use button to clear/regenerate. Refine prompts with specifics (e.g., add examples). Match Select options to your real categories/writers. Monitor for AI drift; limit to database views with filters.

(Word count: 448)