How to connect a Notion table

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

Step 1: Select the Notion table

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

Select "Notion Table" 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 table field names for auto-mapping in Step 5.

Note: Auto duplication merging is currently unsupported. If both your sheet and Notion table 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 table.

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 table you want to sync is included in the selected pages.

4. Click "Allow access."

Step 4: Insert table block link

Go to your Notion table page, right-click on the six dots, and select 'Copy link to block.

• Paste the copied table block URL and click 'Check URL.

• Click the "Next" button.

Note: Ensure that your table has headers enabled and each table column has the proper column name set.

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 table property to a Google Sheet column.

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

3. Two-Way Sync: Synchronize data between a Notion table 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 Table) 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

Format Sheet Cells: Applies a Google Sheets text format. If disabled, no formatting will be applied, and you can manually format cells as needed.