Notion x Make : trigger based on Property change

How To
,
1

Hi
I have a Notion database. I would like to launch a scenario when a specific property is changed from No to Yes.
Then it send the Page title to OpenAI and start prompting and add the result back in Notion’s database within the specific page content.

I struggle with the first step. Is there a way to Watch a property change on a selected database ? Or do I have to add one more steps and update the Notion database into a Google sheet and launch from there ?

Thanks for your help.

2

Hi Haz,
You can use a Webhook trigger in the Make scenario. In your Notion database, you can create a database automation that triggers the webhook.

3

Thanks for your help @Simo

1/ I managed to do the first steps till the redaction in OpenAI, but I’m stuck at the last step : add the result from OpenAI as the content of the database item. Not adding in a property, but in the content of the item.

In notion each item of a database is a page when you click on Open. I mean this page content. I don’t want to update a column of the database).

I tried Append a page content / Update a database Item / etc… but no luck always an error.

2/ is it possible to remove the caracter limit of 2000 ? for example if I need to create a long blog post as the content, going from the keyword.

Thanks for the help.

4
  1. You can use “Append page content” to insert content into a Notion page. Why didn’t that work for you? Do you see errors?
  2. The 2000 character limit is enforced by the Notion API, so it’s not possible to remove it. To work around it, you can split the input text into multiple bundles and either make multiple API requests one per bundle), or append multiple blocks in one API request
5

CleanShot 2025-01-23 at 15.27.27@2x
CleanShot 2025-01-23 at 15.27.27@2x2280×1064 177 KB

CleanShot 2025-01-23 at 15.28.23@2x
CleanShot 2025-01-23 at 15.28.23@2x1454×1218 173 KB

Here is my settings, I’ve added Database item id (which might be the Page ID). In the content object I have added the output of openai.

I’ve tried to so many times but it doesn’t work :confused:

6

if you map the “Content objects” field (as shown in screenshot 1 on your latest message), you would need to first construct the correct JSON object for the block type following the Notion API documentation.

If instead, you don’t need that, you can directly add the specific block (see screenshot below)

appending a paragraph block to the Notion page
appending a paragraph block to the Notion page1099×753 30.3 KB

7

So I did like in your screenshot, but have a new issue instead : [400] body failed validation: body.paragraph.rich_text[0].text.content.length should be ≤ 2000, instead was 5967.

My content is mostly blog post article which is normally quite long. Is there a limitation of character of 2000 only ? is it coming from make or notion ?

8

Yes right, there is a limitation of 2000 characters per block - coming from Notion

9

Is my only solution to use Airtable or Google Sheet instead of Notion ? Already have my datase in Notion though.
I read somewhere that the body in notion is not limited with 2k character only properties… do you have an idea if it’s true ?

thanks again for your help.

10

Mh I don’t think so - anyways appending a very long text (more than 12 thousand characters) works for me with the setup below using the “Append page content” module. So just to confirm, this is the setup you used and you still get the error message?

Append page content Notion API Make