You want to bring data from Google Sheets into a Notion database and keep it updated automatically. Notion offers two ways to do this: a one-time CSV import or a live sync using the native Google Sheets integration. The live sync method ensures that any change you make in Google Sheets appears in your Notion database within minutes. This article explains how to set up that live connection and what to do if the data does not update as expected.
Key Takeaways: Import Google Sheets to Notion Database with Live Sync
- Settings & Members > My Connections > Google Drive: Connect your Google account so Notion can read your sheets.
- Create a new database and select Google Sheets: Choose this import method to establish a live link instead of a static CSV upload.
- Select the correct sheet and range: The integration maps columns to Notion properties; picking the wrong range causes data to appear in the wrong fields.
How the Notion-Google Sheets Live Sync Works
Notion’s native Google Drive integration lets you import a Google Sheets file as a live database. Unlike a CSV import, which creates a static snapshot, the live sync maintains a connection between the sheet and the Notion database. When you add, edit, or delete rows in Google Sheets, those changes appear in the Notion database after a short sync cycle, usually within 5 to 15 minutes.
The integration works only with a single sheet tab inside a Google Sheets file. It maps each column header in the sheet to a property in the Notion database. The first row of the sheet must contain column headers; otherwise, Notion cannot interpret the data correctly. You can still edit the data inside Notion, but those edits are not pushed back to Google Sheets — the sync is one-way from Sheets to Notion.
Before starting, you need a Google account with access to the sheet you want to import. The sheet must be stored in Google Drive, not on a local computer. You also need a Notion workspace where you have permission to create new databases.
Steps to Import a Google Sheets File Into a Notion Database Live
Follow these steps to create a live Notion database from your Google Sheets file. The process takes about two minutes and does not require any third-party tools.
- Connect your Google account to Notion
Open Notion and go to Settings & Members in the left sidebar. Select My Connections. Click Connect next to Google Drive. Sign in to the Google account that owns the sheet you want to import. Grant Notion permission to view your Google Drive files. - Create a new database from Google Sheets
In your Notion workspace, click the + button next to the page title to add a new block. Type “Google Sheets” and select the Google Sheets option from the menu. Alternatively, click the + icon in the left sidebar to create a new page, then type “database” and choose the Database – Google Sheets option. - Select the Google Sheets file
A file picker opens showing your Google Drive files. Navigate to the folder that contains your sheet. Select the file. If you have many files, use the search bar at the top to find the sheet by name. - Choose the sheet tab and data range
After selecting the file, a dialog asks which sheet tab to import. Pick the correct tab if your file has multiple tabs. Then specify the data range, for example A1:Z100. If your sheet has headers in the first row, check the box labeled “First row is header.” Notion will use these headers as property names. - Confirm the import
Click Import. Notion creates a new database page with all rows from the sheet. The database properties match the column headers from the sheet. The database is now live — any change in the Google Sheets file will sync to this database automatically.
Things to Avoid and Common Mistakes
Sheet tab contains merged cells or blank rows
Merged cells in Google Sheets cause Notion to skip entire rows or columns. Before importing, unmerge all cells in the sheet. Also remove any completely blank rows or columns within the data range. The first row must contain unique, non-empty column headers.
Data does not update after editing the sheet
The live sync is not instant. It can take up to 15 minutes for changes to appear in Notion. If the data still does not update after 30 minutes, disconnect and reconnect the Google Drive connection in Settings & Members > My Connections. Then re-import the sheet by creating a new database from the same file.
Property types do not match the data
Notion automatically assigns property types based on the first few rows of each column. For example, a column with dates becomes a Date property. If the type is wrong, change it manually in the database property settings after the import. This does not break the live sync.
Notion Database Import Methods: CSV vs Google Sheets Live Sync
| Item | CSV Import | Google Sheets Live Sync |
|---|---|---|
| Description | Upload a CSV file as a one-time snapshot | Connect a Google Sheets file that updates automatically |
| Data updates | Manual re-upload required | Automatic every 5–15 minutes |
| Edits in Notion | Allowed, no sync back | Allowed, no sync back to Google Sheets |
| File location | Local computer or cloud storage | Google Drive only |
| Column headers | First row of CSV must be headers | First row of sheet tab must be headers |
You can now create a live Notion database from any Google Sheets file in your Google Drive. Use the native Google Drive integration to establish the connection instead of uploading a static CSV. If you need to sync multiple sheets, repeat the process for each sheet tab. For advanced workflows, consider using Notion’s API to push data back to Google Sheets automatically.