Go to the Destinations overview page and click the Add destination button. Select Notion and click Continue. You can then authenticate Hightouch to Notion by logging into Notion.
Next, select which Notion pages you want to give Hightouch access to.
Be sure to give access to pages that include databases you want to sync to.
If the page containing the database within Notion has restricted access, you won't be able to configure a sync to it.
Once successful, you will be redirected back to Hightouch to enter a descriptive name for your destination and complete setup.
Once you've set up your Notion destination and have a model to pull data from, you can set up your sync configuration to begin syncing data. Go to the Syncs overview page and click the Add sync button to begin. Then, select the relevant model and the Notion destination you want to sync to.
To match rows from your model to database rows in Notion, you need to select a model column and corresponding Notion field.
It's best to select a unique identifier for record matching, otherwise the intended records may not be updated properly.
Refer to the record matching docs for more information.
Hightouch supports the following Notion database properties when field mapping.
Checkbox
Date: Hightouch supports a single date, and not a date range
Email
Multi Select
Number: If a number field is passed an invalid number, Hightouch attempts to convert it to a number. If the conversion result is invalid, the sync errors.
Phone
Rich Text
Select
Title
URL
To learn more about Notion's available properties, please refer to Notion's docs.
If the page containing the database within Notion has restricted access, the database won't appear in the dropdown menu of the sync configuration, even if Hightouch is explicitly granted access during authentication.
You may also receive a 404 - Could not find database with ID: {...} error in the record matching section of your sync configuration, or when attempting to sync to Notion.
To fix this, go to the Destinations overview page and select your Notion destination.
Click Log in to Notion and add access to any required pages.
Then, return to your sync configuration or create a new one from the Syncs overview page.
You may need to click the refresh button to see the new database.
This error occurs if you try to sync null values to Select or Multi-select fields in Notion.
To resolve this, check the Don't sync null values option in the template mapper or remove rows containing null values from your model's query results.
You need to do this option for all field mappings to Select or Multi-select fields in Notion, if you believe the mapped model columns might contain null values.
This error occurs if you try to sync non-text values to a Text field in Notion.
To resolve this, cast the relevant column or columns from your model to a String type.
Hightouch provides complete visibility into the API calls made during each of your sync runs. We recommend reading our article on debugging tips and tricks to learn more.