Notion Database Template Prompt

Design complete Notion database templates with properties, views, formulas, and relations — described step by step so you can build them.

Prompt Template

You are a Notion power user and workspace designer.

I want to build a Notion database (or connected set of databases) for:

**Purpose:** [describe what you are tracking, e.g., a content calendar for a blog, a job application tracker, a CRM for freelance clients, a recipe collection with meal planning]

**What I need to track:** [list key information, e.g., company name, application date, status, salary range, interview notes, follow-up dates]

**How I want to see it:** [describe your ideal views, e.g., a Kanban board grouped by status, a calendar view by deadline, a gallery view with cover images, a filtered table showing only active items]

**Automations or formulas:** [any calculated fields, e.g., days since last contact, total hours this week, progress percentage, overdue flag]

Provide a complete, step-by-step setup guide:
1. **Database name and icon suggestion**
2. **Properties table** — property name, type (select/multi-select/date/formula/relation/rollup/etc.), and options or formula code
3. **Views** — name, type (table/board/calendar/gallery/timeline/list), filters, sorts, and visible properties for each
4. **Relations and rollups** (if multiple databases are needed)
5. **Template buttons** — any reusable templates for new entries
6. **Setup tips** — things to configure in Notion that cannot be expressed as text (like cover images, sub-pages, or toggle blocks)

Example Output

Notion Database: Job Application Tracker

**Database name:** Job Applications

Properties

| Property | Type | Details |

|----------|------|---------|

| Company | Title | Company name (primary field) |

| Role | Text | Job title applied for |

| Status | Select | Bookmarked, Applied, Phone Screen, Interview, Offer, Rejected, Withdrawn |

| Applied Date | Date | When you submitted |

| Salary Range | Text | e.g., k-k |

| Source | Select | LinkedIn, Referral, Company Site, Job Board |

| Follow-Up Date | Date | When to follow up |

| Days Since Applied | Formula | dateBetween(now(), prop("Applied Date"), "days") |

| Notes | Text | Interview notes, observations |

Views

1. **Pipeline Board** — Board view grouped by Status, sorted by Follow-Up Date ascending

2. **Follow-Up Calendar** — Calendar view by Follow-Up Date

3. **All Applications** — Table view sorted by Applied Date descending

4. **Active Only** — Table filtered where Status is not Rejected and not Withdrawn

Template Button

- **New Application** — Pre-fills Status: Applied, Applied Date: today, Priority: Medium

Tips for Best Results

  • 💡Describe what you are tracking in plain language — the AI handles translating it to Notion property types.
  • 💡Ask for formulas by describing what you want to calculate ('days since last contact') rather than writing Notion formula syntax yourself.
  • 💡Request multiple views — Notion's power comes from showing the same data in different ways (board, calendar, gallery).
  • 💡If your system involves linked data (clients and projects), mention that relationship so the AI designs connected databases with relations and rollups.
  • 💡Copy the properties table directly — it maps 1:1 to Notion's 'Add a property' dialog.

Frequently Asked Questions

What is the Notion Database Template Prompt prompt?

Design complete Notion database templates with properties, views, formulas, and relations — described step by step so you can build them. It's a free ChatGPT prompt template from our Productivity collection — copy it, fill in the bracketed variables, and paste it into your AI tool.

Which AI tools work with this prompt?

It's written and tested for ChatGPT, Claude and Gemini. Any AI assistant that accepts free-form text prompts will handle it well.

How do I customize this ChatGPT prompt?

Adjust the details in the template to match your own context before running it. Describe what you are tracking in plain language — the AI handles translating it to Notion property types.

Is this prompt free to use?

Yes. Every prompt on PromptAtlas is free to copy, customize, and use — no signup required.