Notion Integration in n8n: API Tests Succeed But Data Retrieval Fails Due to Page Sharing Issues

Based on the error message from n8n—“In Notion, make sure to add your connection to the pages you want to access.”—the issue is most likely that while your API tests indicate a valid connection, the Notion integration hasn't been shared with the actual pages (or databases) you’re trying to retrieve data from.

Key Points to Check

• Share the Page/Database with the Integration:
  Ensure that the specific Notion page or database you wish to work with is shared with your integration.

  1. Open the page in Notion.
  2. Click the triple-dot menu at the top right.
  3. Under Connections, select Connect to and choose your integration.
     Without sharing the page, Notion will block API access even if your credentials are valid.

• Double-check API Integration Token and Permissions:
  Verify that the integration has the required capabilities (such as reading and updating content) and that the credentials in n8n are set up exactly as detailed in the Notion documentation.

• Review URL and Configuration Settings:
  Confirm that the URL you’re copying is correct and that it points to a shared page or database. Even a slight typo might result in a proper connection test but lead to no actionable data returned.

Troubleshooting Steps

1. Re-share the Notion Page:

   • Remove the integration’s access from the page.
   • Then, re-add it by following the steps above.

2. Verify Credentials in n8n:

   • Ensure that your Notion credentials in n8n use the correct integration token.
   • Double-check that the proper authentication method (API integration token or OAuth2, as applicable) is configured.

3. Test with a Simple Workflow:

   • Create a workflow that makes a simple request (like listing users or retrieving a page) to determine if the problem persists.
   • If the issue still occurs, it’s a strong indicator that the page sharing settings need attention.

By ensuring that the integration is authorized to access the specific pages in your workspace, you should be able to resolve the error and see the data returned as expected in n8n.