How do I convert a Google Sheet into a Notion database?

Export the sheet to CSV, then import that file in Notion. Notion reads the header row as property names and each row becomes a page. It guesses property types, so review them afterward. The result is a static snapshot, so later edits in the sheet will not appear unless you set up a live sync.

Can I keep Google Sheets and Notion synced automatically?

Yes. Sync2Sheets is a Google Workspace add-on that keeps a sheet and a Notion database updated in real time, in both directions. You pick the direction per column, so Sheets formulas can drive Notion properties while Notion edits still flow back to the sheet within seconds.

Does importing a Google Sheet to Notion keep formulas?

No. A CSV import brings in the computed values, not the formulas behind them. If you need Sheets formulas like GOOGLEFINANCE or VLOOKUP to keep updating Notion, use a live sync and set those columns to push from Sheets to Notion so the latest results land on the properties.

Is there a free way to get Google Sheets data into Notion?

Yes. The CSV import in Notion is free and works for a one-time copy. The tradeoff is that it goes stale the moment your sheet changes, and re-importing tends to create duplicates. Sync2Sheets offers a free 7-day trial if you want the connection to stay live.

How to Connect Google Sheets to Notion (2026)

Q: Can I import a Google Sheet into Notion?

Yes. Download your Google Sheet as a CSV (File, Download, Comma-separated values), then in Notion use Import and pick CSV to turn it into a database. This is a one-time copy. For a connection that stays current, use a sync add-on like Sync2Sheets instead of re-importing the file.

Q: How do I create Notion pages from Google Sheets rows?

With Sync2Sheets, add a row in the synced sheet and type NEW in the Page ID column. On the next sync, Sync2Sheets creates a matching Notion page with every property filled in from that row. You can also type DRAFT to stage a page before it is created.

Connecting Google Sheets to Notion in short: You have two routes. For a one-time copy, download the sheet as a CSV and use Notion's Import to turn it into a database. For data that stays current, use a sync add-on like Sync2Sheets, which can create Notion pages from your rows and keep both sides updated in real time.

Most guides cover the other direction, pulling a Notion database out into a spreadsheet. This one is the reverse: getting data that already lives in Google Sheets into Notion, and keeping it there as the numbers change. If you want the Notion to Google Sheets direction, that is a separate workflow.

There are two ways to do this. The first is a manual CSV import, which is free and quick but one-time. The second is a live synced connection, which can also create Notion pages straight from your spreadsheet rows. Here is how each works and when to pick it.

Can I import a Google Sheet into Notion?

Yes. The built-in way is a CSV import. Notion reads a CSV file and turns it into a database, so the path is: download your sheet as a CSV, then import that file in Notion.

Convert a Google Sheet into a Notion database with CSV

In Google Sheets, open the sheet you want to move.
Click "File," then "Download," then "Comma-separated values (.csv)." If your file has multiple tabs, only the active tab is exported, so download each tab you need.
In Notion, open the page where you want the data to live.
Type /import or click "Import" in the sidebar, then choose "CSV."
Select your downloaded file. Notion creates a new database, reads the header row as property names, and turns each row into a page.
Review the property types. Notion guesses them (text, number, date, select), so fix any column it read incorrectly.

That is the whole manual method, and for a one-time move it works fine.

The catch with importing a Google Sheet to Notion

The CSV import is a snapshot. The moment you finish, the connection is gone. A few things follow from that:

It does not stay synced. Edit the sheet tomorrow and Notion will not know. Edit Notion and the sheet will not know.
Re-importing creates duplicates. Notion does not match rows on a second import, so running it again gives you a second copy of every page rather than an update. Keeping things current means deleting the old database or manually merging, which gets painful fast.
Formulas become values. A CSV carries the computed result, not the =GOOGLEFINANCE or VLOOKUP behind it. Those numbers freeze at export time.

So the CSV import answers "can I get this sheet into Notion once," but not "can I keep them connected."

How to connect Google Sheets to Notion and keep it synced

If you want the data to stay current, you need a live connection instead of a file copy. Sync2Sheets is a Google Workspace add-on (184,000+ installs, 4.4 rating) that keeps a Google Sheet and a Notion database in sync in real time, in both directions. Two features make the Sheets to Notion direction work well.

Page creation. Instead of importing a file, you add rows in the sheet and Sync2Sheets builds the Notion pages for you. Type NEW in the Page ID column of a row and, on the next sync, Sync2Sheets creates a matching Notion page with every property filled in from that row. Type DRAFT if you want to stage a page before it is created. See page creation for the details.

Per-column direction. Each column can sync Notion to Sheets, Sheets to Notion, or both ways. Set a column to Sheets to Notion and a spreadsheet formula (=GOOGLEFINANCE, VLOOKUP, IMPORTXML) becomes the source of truth for that Notion property. The result recalculates in Sheets and lands on the Notion page within seconds. Notion edits to other columns still flow back to the sheet.

Set up a synced Sheets to Notion connection

Install Sync2Sheets from the Google Workspace Marketplace and grant the Google and Notion permissions it asks for.
Open your Google Sheet (the one with the data you want in Notion) and open the Sync2Sheets sidebar from the "s2s" icon.
Connect your Notion workspace and pick the Notion database you want to sync with, or create a fresh one to receive the rows.
Set column directions. Leave columns driven by Sheets formulas as Sheets to Notion, and set anything you will edit from either side to both ways.
Mark new rows. In rows that do not exist in Notion yet, type NEW in the Page ID column.
Start the sync. Sync2Sheets creates a Notion page for each NEW row, fills in the properties, and from then on keeps both sides updated automatically.

After the first sync, you stop thinking about it. Add a row in Sheets and a Notion page appears. Change a number in Notion and the sheet catches up. No re-importing, no duplicates.

One-time import vs live synced connection

	CSV import	Sync2Sheets sync
Stays current	No, snapshot only	Yes, real time both ways
Re-running	Creates duplicates	Updates in place
Creates Notion pages from rows	On first import only	Anytime, mark a row `NEW`
Keeps Sheets formulas live	No, values freeze	Yes, set column to Sheets to Notion
Direction	Sheets to Notion only	Per column: either way or both
Cost	Free	Free 7-day trial, then from $12/mo
Best for	A one-time copy	Recurring work, live data, dashboards

Which method should you use?

CSV import: good for a one-time move, an archive, or data you do not plan to touch again in the sheet.
Sync2Sheets: better any time the data keeps changing, you want spreadsheet formulas feeding Notion, or you would rather add rows in a familiar grid than click through Notion's editor.

For most people the deciding factor is duplicates. The first CSV import is painless. The fifth one, with a database full of doubled pages, is the reason people switch to a live sync.

Connect your data and keep it in sync

If you only need the data in Notion once, the CSV import is free and takes a couple of minutes. If you want the two to stay connected, with new rows becoming Notion pages and formulas driving properties, try Sync2Sheets free for 7 days. No credit card required.