Using Make with Notion and Joomla

Hello,

We’re discovering the Notion universe and its possibilities, and we’d like to use it to manage publications on our website and our social networks.

We’ve managed to automate our daily social network posts from our Notion database, but we’re having trouble doing the same thing for our Joomla5 site.

We’re using the ‘Content Calendar’ template on Notion, which allows us to work with several people.

We’ve added properties to the basic ones, and we manage our articles in sub-pages integrated into a record in the base (page). This is how the model works.

Using Make we’re able to retrieve the property data from the main page, but not the content of the embedded sub-pages (if I’ve understood correctly this sub-page is embedded in a content block on Notion).

I don’t know if that’s clear enough :confused:

Is there a way to associate a property with a specific sub-page? That way we could retrieve the text of our articles via Make like any other property.

Or if anyone knows how to retrieve the sub-page content directly, I’d love to hear from you too.

Thanks in advance for any help you can give.

Hi David,
You can use the “List page contents” module to retrieve the content of Notion pages

Hello Simo
Thank you, I will try this

So I tried but without any conclusive result, or at least I’m stuck.

My first module is “Notion - Search Objects”.
I do a search in my entire database based on a criterion. For my test there’s only one page that matches this search.

I send the result to a “Notion - List Page Contents” module with “Page ID” as the criterion.
So I see the list of everything on the page found (“Bundles”) and I see that what I’m looking for is in “Bundle 7”.

What I then did was to send the result of this second module to a third module “Notion - List page Contents” but between the 2 I put a filter “Bundle order position=7”.

And then I see a list of “Bundles” containing all the content of my page.

But how can I retrieve all this for each part of the “Joomla - Create an article” module?

For example :

  • Bundle1 for "Title
  • Bundle 2 to 113 for "Text

Very nice progress - that’s the complications of working with page content with the Notion API; each block type has a different data structure, so you need to take that into account.
To your specific question, I don’t know currently, and I can offer some possibilities/thoughts:

  1. Use an array aggregator to bundle blocks of the same type together before mapping them to the correct fied in Joomla
  2. Use routes based on the block type and map to Joomla accordingly

Then you’re speaking Chinese to me :sweat_smile:

I didn’t understand the 2 possibilities you mentioned :smirking_face:

Ahah got it - here is the documentation about the Array Aggregator

1 Like

Thank you, I’m going to study all this and hope to understand everything. :sweat_smile:

2 Likes