Extract text content from a "List Page Contents" Notion Module

GOAL : Extract the text content within the bundles from a Notion “List Page Contents” Module

CONTEXT : My scenario begins with a “Watch Database Items” notion module. This module grabs the contents of a property in a notion base that contains an “Interesting Article” that I have saved there.

I then have a List Page Contents notion module that grabs the contents of the Watch Data Base Items module. This data is put into several bundles.

This bundled data is the Interesting Article from the notion data base but seperated into different sections.

I would like to combine the seperated bundle data into one single bundle that will then be fed as the input for a ChatGPT module.

WHAT I HAVE TRIED:

I have tried using a text aggregator to combine the multiple bundles into one bundle. However the output comes out as blank.

I think the problem i’m having that i’m not grabbing the correct values from the List Page Contents (I’ve been grabbing “Plain Text” values).

OR notion is just awkard with providing values

Here are the values I have for the “List Page Contents”:

I have not been able to figure this out for a while and I would appreciate any help with this! Thanks

Welcome to the Make community!

Please provide the output bundles of the modules by running the scenario, then click the white speech bubble on the top-right of each module and select “Download output bundles”.
Screenshot_2023-10-06_141025

A.

Save the bundle contents in your text editor as a bundle.txt file, and upload it here into this discussion thread.

Uploading it here will look like this:

bundle.txt (12.3 KB)

B.

If you are unable to upload files on this forum, alternatively you can paste the formatted output bundle in this manner:

  • Either add three backticks ``` before and after the code, like this:

    ```
    input/output bundle content goes here
    ```

  • Or use the format code button in the editor:
    Screenshot_2023-10-02_191027

Providing the output bundles will allow others to replicate what is going on in the scenario even if they do not use the external service.

Following these steps will allow others to assist you here. Thanks!

samliewrequest private consultation

Join the unofficial Make Discord server to chat with us!

Hi Sam,

Thanks for your reply. Please find my output bundle from the “List Page Contents Module” below

bundle.txt (20.6 KB)

Hi @Jamie_Harris

Please ensure your mapping in the text aggregator is correct. We tried the following mapping, and it worked.


Output:

If you require additional assistance, please don’t hesitate to reach out to us.
MSquare Support| Book Live Implementation
Visit us here
Youtube Channel

Oh wow! Please could you tell me how you get the “JSON - Parse JSON [145]” for the source module box. I cant seem to see it on my screen.

I also cant see the “145. paragraph.rich_text []:plain_text”

Thanks for your help!

Hi @Jamie_Harris
We used JSON parse to test with the output bundle you provided. You need to select the source as the module from which you want to aggregate text. The plain_text cannot be mapped because the first bundle does not contain it. The first bundle is an image. Instead, you can copy this: {{145.paragraph.rich_text[].plain_text}} and change the module number to 3 in your case.
{{3.paragraph.rich_text[].plain_text}}

2 Likes

Thanks again for your help, When I copy what you put —> {{3.paragraph.rich_text[].plain_text}} , it doesnt seem to regsiter.

Do you see any of the values in this screenshot as the correct one i should be selecting. Apologies if I am misunderstanding

Here is the same list with some expansion into further values:

65

Hi @Jamie_Harris

The mapping is correct. Once you run the scenario, it will work fine. After the first run, it will display the mapped value properly.

2 Likes

That worked! Thank you so much for the help. How did you know the correct way to map it without it being an option from the notion value list? I feel like I would have never had figured that out :grin:

2 Likes