Google Sheets columns that sync to Notion

Google Sheets has no fixed field list. Every column of the tab you sync becomes a field, named after its header, and 2sync suggests a Notion property type from the column's formatting. Text, numbers, dates, checkboxes, and dropdown lists all map to the matching Notion type, and formula columns sync one way into Notion. You control each column's direction in field mapping.

For the setup walkthrough, see the Google Sheets sync guide.

Column types and Notion properties

Two more fields appear in every automation: Sync Status and Automation Name go to Notion and are never written into the sheet. Trigger deletion on Google Sheets goes to the sheet and deletes the row when the mapped checkbox is checked.

How does 2sync decide a column's type?

2sync looks at the column in this order:

1. A data validation rule on the column (a dropdown list, a checkbox, a date rule)
2. The number format you applied (Format > Number)
3. The values in the first rows of the tab

A column with no format and mixed values is treated as text. Change the type in field mapping if the guess is wrong, then click Refresh tabs whenever you reformat a column so the suggestion updates.

Text columns

A plain text column maps to a Text property by default. It can also map to:

• Title: one column has to map to the Notion title. The first text column is proposed; a row with an empty title is skipped until you fill it in
• Select: the cell text becomes the option name. An option that does not exist yet is created in Notion
• Multi-select: values in the cell separated by a comma and a space become one option each (see below)
• URL, Email, Phone: the cell text is stored as is

Line breaks inside a cell are kept in the Notion text.

Multiple values in one cell

Map a text column to a Multi-select and 2sync splits the cell on , (comma, space). The cell alpha, beta becomes the options alpha and beta. To keep a comma inside an option, escape it with a backslash: red, green\, blue becomes the options red and green, blue.

The same rule applies in the other direction: Notion options are written into the cell separated by , , with commas inside an option escaped.

Number columns

A column formatted as a number, currency, or percent maps to a Number property. The raw value syncs, not the formatted text: a cell showing $1,200.00 reaches Notion as 1200, and a Notion number is written into the cell as a plain number that keeps the column's format.

Dates and time zones

A column formatted as a date maps to a Notion date without a time. A column formatted as date time maps to a Notion date with a time.

Times are converted using the time zone of the spreadsheet, set under File > Settings in Google Sheets. A cell showing 14:30 in a spreadsheet set to Paris time reaches Notion as 14:30 Paris time, whatever your Notion or 2sync time zone is.

A sheet cell holds one date. Use single dates in Notion rather than ranges for columns that sync to the sheet.

Checkboxes

A column with checkboxes (Insert > Checkbox) maps to a Checkbox property. Ticking the box in either app ticks it in the other. 2sync writes a real checkbox value into the cell, not the text TRUE.

Dropdown lists

A column with a dropdown list (Data > Data validation, Dropdown) maps to a Select property, and the list's options are offered when you map values. Pick an option in Notion that is not in the list yet and 2sync adds it to the dropdown, so the list and the Notion options stay aligned.

A dropdown column can also map to a Status property or, for cells holding several values, to a Multi-select.

Formula columns

A column that contains formulas syncs one way, to Notion. 2sync reads the calculated results and never writes into the column, so the formulas keep running in the sheet. The suggested property type follows the results: a =M2*N2 column maps to a Number, an =UPPER(A2) column to Text.

Editing the mapped property in Notion has no lasting effect: the next sync writes the formula result back. Change the inputs instead, in the sheet or in Notion, and the result follows.

Managed columns

2sync adds two columns of its own to the tab:

• 2sync ID, hidden and protected, holds the ID that links each row to its Notion page. Never edit or delete it
• Notion Link, visible and protected, appears when Include Notion link is on in the sync settings and holds each page's URL

Neither shows up in field mapping. See the Google Sheets sync guide for what happens when the ID column is touched.

What should I do next?

1. Set up the Google Sheets sync if you have not connected yet
2. Configure sync direction per column
3. Set default values for Notion-only properties

Related

• Google Sheets sync for the full setup guide
• Notion property types for supported property formats
• Sync direction for per-field data flow control
• Default values for filling Notion-only properties on new pages
• Todoist fields for comparing a fixed field set with column-based mapping

FAQ