How to connect a Notion database

This step-by-step guide will walk you through the process of connecting Notion database to Google Sheets.

Step 1: Select the Notion database

From the Home screen, click the "Add a connection" button.

Select "Notion Database" from the Data Sources section.

Step 2: Select a sheet from Google Spreadsheet

There are two possibilities when selecting a sheet:

1. Sheet with data

• If the sheet you select already contains data (created or imported), ensure the first row is the header row.

• Addsync uses these header names to match with your Notion database field names for auto-mapping in Step 5.

Note: Auto duplication merging is currently unsupported. If both your sheet and Notion database contain data, duplicate fields will appear. You must manually delete duplicates for now. If this is critical for you, email us to prioritize this feature development.

2. Sheet is empty/new

• If the selected sheet is empty, Addsync will automatically create headers using the names from your Notion database.

After selecting a sheet for syncing, click the "Next" button.

Step 3: Connect to your Notion account

If you’re new to Addsync or your previous connection has expired or been revoked:

1. Click the "+" button to be redirected to the secure Notion connection page.

2. On the Notion connection page:

   • Select the Notion account to connect.

   • Click "Select Pages" and choose the pages to connect (select all pages for ease of use).

3. Ensure that the database you want to sync is included in the selected pages.

4. Click "Allow access."

Step 4: Select a database

• Choose the Notion database you want to use for this connection.

• Click the "Next" button.

Note: Wiki databases have limited support because the Notion API does not support nested databases (e.g., wiki database → database). However, wiki databases with pages (e.g., wiki database → page) are supported.

Step 5: Map the columns and fields

This step lets you choose what data to sync and define the sync flow direction.

Auto-mapping Fields

Addsync will automatically map fields if the connected apps share the same field names.

This feature saves time but is optional. You can unmap auto-mapped fields or manually map fields with different names.

Manual mapping Fields

If there is no maps, Click "+ Add" at the bottom to create a new column map.

1. From "Select a Sheet Column," choose a Google Sheets column.

2. From "Select a Notion Field," choose a Notion field.

3. From "Select Direction," select the sync flow direction for the column map.

To delete a map, click the delete icon.

Sync Flow Directions:

1. Import: Sync data from a Notion database property to a Google Sheet column.

2. Export: Sync data from a Google Sheet column to a Notion database property.

3. Two-Way Sync: Synchronize data between a Notion database property and a Google Sheet column, reflecting changes made to either.

When finished, click the "Next" button in the top-right corner to proceed to the configuration page.

Step 6: Configure & Complete the Setup:

This is the final step. All settings are pre-filled, so you can simply click the "Done" button. If you wish to customize the sync behavior, read below:

Enable to disable auto sync:

One time data flow: Addsync will sync the data once but won’t auto-refresh it. However, you can manually refresh the data by clicking the "🔄" button.

Setup interval for recurring sync: Selecting this option enables automatic data refresh at the interval you specify.

Auto delete

Auto-delete removes a destination row when its corresponding row is deleted from the source. For example, if you create a one-way connection (Google Sheet ← Notion Database) and enable auto-delete, deleting a row or page in Notion will automatically delete the corresponding row in Google Sheets during the next refresh.

Format

Pre-Format Sheet Columns: Automatically applies a Google Sheets format to all cells in a column based on the corresponding Notion database property. This ensures you don't need to apply formatting manually when creating new rows. Note that only certain fields are supported.

Format Sheet Cells: Applies a Google Sheets format corresponding to the Notion database property. If disabled, no formatting will be applied, and you can manually format cells as needed.