Page Creation: Make Notion Pages from Sheets Rows

Page creation lets you add new Notion database pages directly from Google Sheets. Type a row, mark it NEW, and Sync2Sheets creates a full Notion page with every property filled in. Perfect for bulk imports, form submissions, or any workflow that starts outside of Notion.

The workflow

Every synced database has a Page ID column that maps each row to a Notion page. Page creation reuses that column with two special keywords:

• DRAFT: you are still filling in values. The row is ignored by the sync.
• NEW: the row is ready. On the next sync, Sync2Sheets creates a Notion page with the row's values and replaces NEW with the real Notion page ID.

If something goes wrong (for example, a required property is missing) the cell turns red and displays ERROR along with a note explaining the problem. Fix the row, change ERROR back to NEW, and it retries on the next sync.

What you can do with it

• Bulk-import existing data from a CSV, from another tool, or from a manual export without writing scripts
• Create pages from form tools (Google Forms, Typeform, Tally) that write to a sheet and then flow into Notion automatically
• Seed a new workspace with hundreds of template pages by generating the rows in Sheets
• Ingest third-party data via Sheets connectors (HubSpot contacts, Stripe customers, GitHub issues) that need to land in Notion as pages
• Let non-Notion users contribute by giving them a shared sheet where rows become Notion pages

Setup

Page creation is configured per database:

1. Sync the target Notion database to a sheet.
2. In the Sync2Sheets sidebar, open the database settings and enable Page Creation.
3. Add a row to the sheet. Fill the properties you want set on the new page.
4. In the Page ID column, type NEW (use DRAFT while you are still editing).
5. Wait for the next scheduled sync or click Run Sync Now for immediate creation.

Property support

You can populate any property type that Sync2Sheets supports on the initial creation: title, rich text, number, select, multi-select, status, date, checkbox, URL, email, phone, person, relation, files, and icon. For relation properties, reference the related page by its Page ID (visible in the related sheet). For person properties, use the workspace member's email.

Handling errors

If a row fails to create, Sync2Sheets surfaces the error directly in the Page ID cell:

• Red background so you can spot the problem row at a glance
• ERROR keyword in the cell
• Cell note describing what went wrong (missing required property, invalid select option, relation not found, etc.)

Fix the underlying row, change ERROR back to NEW, and the retry is automatic.

Related features

• Editable columns let existing rows push value changes back to Notion. Page creation adds whole new rows. Many workflows use both.
• Databases covers the full set of property mappings, which apply identically to page creation.

See it in action: