Updating Notion Databased with ChatGPT Outputs

Getting Started
, ,
1

Hi All,

Hoping I could get some help with this. I am new to Make and creating this type of automations.

I chat a chat going on with ChatGPT where it suggests content ideas, along with scripts, and captions for me. My normal workflow is that ones that I like or approve I just copy and past into a database in Notion - its time consuming sometimes.

What I am trying to to setup is for whatever idea’s the ChatGPT gives me and I approve I would like it to automatically update my Notion Database with a the new page using the content tittle and then putting the scripts into those pages.

I used ChatGPT to see if I could setup with its help and it gave me these directions:

Step-by-Step in Make

1) Create a new Scenario

  • Add Module A: Webhooks → Custom webhook

    • Click “Add” to create a new webhook (e.g., ChatGPT_Approved_Script).

    • Copy the generated Webhook URL (we’ll use this to test).

  • Add Module B: JSON → Parse JSON

    • Data: map the webhook’s body (or payload) to this module.

    • JSON schema: paste this minimal schema (you can expand later if needed): “ ChatGPT provided the code “

      This is where I am stuck because once I create the Parse JSON and map out the data before I can save and move on I have to also put inthe JSON string… Which I don’t know where to get or what I looks like.

      Below is the rest of the steps I need to take.

      Can someone help? Or is there a easier way of doing this?

2) Create the database item in Notion

      • Add Module C: Notion → Create a Database Item

        • Connect your Notion account (OAuth).

        • Database: select your MPF Data base.

        • Map properties (use your exact column names):

          • Video Tittle → {{2.parsed.video_title}}

          • Status (Select) → {{2.parsed.status}}

            • Tip: make sure the select values in Notion include what you’ll send (e.g., “Idea”, “Scripting”, “Filming”, etc.).

          • Film Date (Date) → {{2.parsed.film_date}} (leave blank if null)

          • Sales Funnel (Select) → {{2.parsed.sales_funnel}} (or set a default)

          • Date Planned For (Date) → {{2.parsed.date_planned_for}} (optional)

        • This module returns the Page ID we’ll use next.

3) Append the three toggles inside the page

  • Add Module D: Notion → Append a Block’s Children

    • Parent block/page: map the Page ID returned by Module C.

    • Children: choose “Enter raw JSON” (if available) or use the structured UI.

    • Paste this JSON with three toggles (works with the Notion API’s toggle block):

2

Hi @Peter_Kramm and welcome to the Make Community!

What you’re trying to do is not as straightforward as that.

In order to do this, if I understand correcty, you need to:

  • Create a Custom GPT in ChatGPT
  • Give the instructions to the Custom GPT for what you wnat it to do
  • Add an actioon in the custom GPT so it knows how to call Make
  • Create a scenario in Make that receives the data from ChatGPT
  • Add the various modules in your scenario that will take the data from ChatGPT and put it in Notion
  • Every time ChatGPT tries to call Make, you will need to give it permission to do so (unless this has changed recently).

If you’re OK with that, I recommend that you proceed like this:

  • Creating a scenario that can update the data you need to update in Notion. that way you will know what ChatGPT needs to send to Make in order to complete the task.
  • Create the custom GPT in ChatGPT and add an action that sends your idea to Make. You can find an explanation of how to do that here: GPT Actions library - getting started
  • Activate your scenario and test by using your custom GPT. You will not be able to do this from a regular chat in ChatGPT. Also, custom GPTs don’t have access tot the stuff you’ve stored in ChatGPT’s long-term memory.

If you have questions about this, you can ask here.

However, if you decide to move ahead and implement something like this and you have questions, create a new topic so that someone who has the same questions can find the answers more easily.

L