Notion AI Database Autofill can automatically fill a property in a database row based on the content of another property in the same row. This feature saves time when you need to generate summaries, translations, or extracted data from an existing field. The source property reference tells Notion AI which column to read the input from before generating the output. This article explains how to set up Autofill with a source property, configure the AI prompt, and avoid common setup mistakes.
Key Takeaways: Notion AI Autofill With Source Property
- Database property context menu > Autofill > Configure Autofill: Opens the panel where you select the source property and write the AI prompt.
- Add source property button in the Autofill editor: Inserts a dynamic reference to another property in the same row so the AI reads from that field.
- Autofill column header button > Autofill all: Runs the AI generation on every existing row that has a value in the source property.
What Is Notion AI Database Autofill With Source Property
Notion AI Database Autofill lets you automatically generate content for a database property using an AI prompt. When you add a source property reference, the AI reads the value from another property in the same row and uses it as input for the prompt. For example, you can have a Notes property and an AI Summary property. The Autofill prompt in the Summary property reads from the Notes property and writes a short summary.
The source property reference is a dynamic tag that looks like {Source Property Name}. You insert it inside the Autofill prompt editor. The AI then replaces that tag with the actual content of the source property each time it runs on a row. This works for text, select, multi-select, and formula properties that output text.
Prerequisites for this feature:
- A Notion workspace with AI add-on enabled (paid plan).
- A database with at least two properties: one source property and one target property where the AI output will appear.
- The target property must be a text or formula property. Notion AI cannot write into select or date properties.
The Autofill runs on demand. You trigger it per row or for the entire database. It does not run automatically when new rows are added. You must manually click the Autofill button after adding new data.
Steps to Set Up Autofill With a Source Property Reference
Follow these steps to configure Notion AI Database Autofill that uses a source property as input.
- Open your database and select the target property
Navigate to the database view where you want the AI output to appear. Click the property header of the column that will receive the generated text. If the property does not exist yet, add a new text property by clicking the + button in the last column header and selecting Text. - Open the Autofill configuration panel
Hover over the target property header. Click the small ••• icon that appears on the right side of the header. From the dropdown menu, select Autofill. A submenu appears. Click Configure Autofill. - Write the AI prompt with a source property reference
In the Autofill editor that opens on the right side of the screen, type your prompt. To reference another property, click the Add source property button located below the prompt text box. A list of all properties in the database appears. Select the property you want the AI to read. Notion inserts a tag like{Notes}into the prompt. You can also type the property name manually inside curly braces. For example:Summarize the following text in three bullet points: {Notes}. - Set the output length and style (optional)
Below the prompt box, you can adjust the output length slider from Short to Long. You can also select a tone: Professional, Casual, or Direct. These settings influence how the AI formats the generated text. Leave them at default if you want the AI to decide. - Save the Autofill configuration
Click the Save button at the bottom of the Autofill editor. The panel closes. The target property header now shows a small sparkle icon indicating that Autofill is configured. - Run Autofill on a single row
Click into any cell in the target property column. A small Autofill button appears inside the cell. Click it. The AI reads the source property value from the same row and writes the output into the target cell. - Run Autofill on all rows
Hover over the target property header again. Click the ••• icon and select Autofill. From the submenu, click Autofill all. Notion AI processes every row that has a value in the source property. Rows where the source property is empty are skipped.
Common Mistakes and Limitations When Using Source Property References
Source property tag is not recognized by the AI
If the AI prompt contains a property name that does not exist in the database, the Autofill fails silently. The cell remains empty or shows an error icon. To fix this, open the Autofill configuration and verify that the property name inside the curly braces matches exactly. Use the Add source property button instead of typing manually to avoid typos.
Autofill runs but the target cell stays empty
This usually happens when the source property contains data that the AI cannot process. For example, a formula property that returns a blank value or a rollup that pulls from an empty relation. Check the source property cell in the same row. If it is empty, the AI has no input and writes nothing. Fill in the source property first, then run Autofill again.
Autofill all button is grayed out
The Autofill all option is disabled when no rows have data in the source property. Add at least one row with a value in the source column. If you already have data and the button is still grayed out, refresh the page. A browser refresh reloads the database state and enables the button.
AI writes into the wrong property
Autofill only writes into the property where you configured it. If you see output in a different column, you likely configured Autofill on the wrong property header. Open the Autofill configuration from the correct target property header and reconfigure it. Delete the Autofill configuration on the wrong property by opening its Autofill panel and clicking Remove Autofill.
Source property reference works only with text-based properties
Notion AI can read from text, select, multi-select, email, phone, URL, and formula properties. It cannot read from date, checkbox, relation, rollup, or file/media properties. If you try to reference a date property, the AI sees the date as plain text but the output may be unpredictable. Use text properties as the source for reliable results.
Autofill With Source Property: Supported Property Types
| Source Property Type | Supported as Source | Notes |
|---|---|---|
| Text | Yes | Best for reliable AI input |
| Select | Yes | AI reads the selected option name as text |
| Multi-Select | Yes | AI reads all selected options separated by commas |
| Yes | AI reads the full email address | |
| Phone | Yes | AI reads the phone number as text |
| URL | Yes | AI reads the URL string |
| Formula (text output) | Yes | Works if the formula returns text |
| Date | No | AI may read it but output is unreliable |
| Checkbox | No | Cannot be used as source |
| Relation | No | Cannot be used as source |
| Rollup | No | Cannot be used as source |
| File & Media | No | Cannot be used as source |
Notion AI Autofill with a source property reference is a practical way to automate content generation inside your databases. Configure the prompt once and run Autofill on individual rows or the entire database. Remember that the source property must contain text data for the AI to process. Use the Add source property button to insert the correct reference tag and avoid typos. For advanced workflows, combine multiple source properties in one prompt by adding several references like {Title} and {Notes} in the same prompt.