Editable Columns: Push Sheets Values Back to Notion

Editable columns let any cell in Google Sheets write its value back to the corresponding Notion property. Sync2Sheets is not a full two-way sync: Notion to Sheets is the default direction. Editable columns are an opt-in, per-column way to send values the other way, scoped to the specific columns you mark as editable.

Why you want this

Notion cannot call external services from a formula. It cannot fetch a stock price, a currency rate, a row from another system, or a value from a scraped webpage. Google Sheets can. Editable columns let you build that data in Sheets and have Notion show the result as if it were a native property.

Common patterns:

• Live stock prices with =GOOGLEFINANCE("NASDAQ:AAPL") updating a Current Price number property in a Notion portfolio database
• Currency conversion with =GOOGLEFINANCE("CURRENCY:USDEUR") for multi-currency tracking
• Web scraping with =IMPORTXML pulling ratings, prices, or stock status into a Notion content database
• Calculations too complex for Notion formulas such as weighted scoring, regression, or anything that benefits from array formulas
• Data from other systems imported into Sheets through connectors (HubSpot, Salesforce, Stripe) and mirrored into a Notion view

How it works

Once a database is synced, open the column settings in the Sync2Sheets sidebar and toggle Editable on the columns you want. From that point on, whenever the value in Sheets changes, Sync2Sheets writes it back to the matching Notion property. Manual edits made in Notion for that column are overwritten on the next sync. That is intentional: the formula is the source of truth, not a human edit.

Writes are one-directional by design. This protects your formulas from being silently overwritten by a teammate editing the Notion page. For truly bidirectional edits, use a regular (non-editable) column and edit only in Notion.

Supported property types

Editable columns work with:

• Title
• Rich Text
• Number
• Checkbox
• URL, Email, Phone Number
• Select, Multi-select, Status
• Person
• Date
• Files
• Relation
• Icon (emoji only; image and link icons are overwritten if pushed)

Setup steps

1. Sync the Notion database to a Google Sheet.
2. In the Sync2Sheets sidebar, open Columns for that database.
3. Toggle Editable on the column you want to feed from a formula.
4. Write the formula in that column. On the next sync, the result appears in Notion.

That's it. No API keys, no webhook configuration, no scripting.

Relation to other features

Editable columns send a single property's value. If you want to sync an entire cell's value to a Notion block (paragraph, heading, callout) rather than a property, use block updates instead. If you want to create whole Notion pages from new rows in Sheets, use page creation.

See it in action: