How to Connect GPT Assistants With Zapier & Notion Database

Summary

The video script outlines a step-by-step guide on setting up a GPT assistant to provide motivational quotes and save them into a Notion database using Zapier. It details the process of configuring the GPT assistant, linking it with Zapier, and creating a custom action that automates the quote saving process. The tutorial emphasizes the importance of accurate variable naming and provides troubleshooting tips, ultimately showcasing the integration of AI, Zapier, and Notion for streamlined workflow management.

Takeaways

• 🤖 The process begins by setting up a GPT assistant and connecting it to a Notion database via Zapier, emphasizing the utility of GPTs in automating workflows.
• 🔧 The GPT assistant is configured by conversing with it, where the user's inputs are used to define the assistant's behavior and tasks.
• 🎯 The primary function of the GPT assistant in this example is to provide motivational quotes and save them into a Notion database.
• 🌟 The assistant's name and profile picture can be customized to suit the user's preferences, enhancing the user experience.
• 📝 The configuration tab is crucial as it auto-fills the description and instructions based on the user's conversation with the GPT.
• 🔗 The 'add actions' feature within the GPT assistant allows the integration of custom actions through URLs provided by Zapier.
• 🔄 The process of creating a Zap involves selecting the appropriate triggers and actions, such as 'list available actions' and 'run action'.
• 🔍 The 'available action ID' is an important identifier needed when setting up the Zap.
• 📌 The GPT assistant requires specific instructions and action configurations to link and execute the Zapier action successfully.
• 🛠️ Troubleshooting may be necessary to ensure the correct variable names and action IDs are used, which is vital for the successful execution of the GPT assistant's tasks.
• 📋 The final outcome is the GPT assistant's ability to not only generate content but also to store and organize it in a user's Notion database, showcasing the potential for integrating AI with existing productivity tools.

Q & A

What is the main purpose of setting up a GPT assistant as described in the transcript?

The main purpose is to create a GPT assistant that provides motivational quotes for users and saves them into a Notion database through a Zapier action.

How does the process of configuring a GPT assistant begin?

The process begins by creating a GPT beta in the OpenAI interface, where the user interacts with a chat window to provide configurations and instructions for the GPT assistant.

What is the name given to the GPT assistant in the transcript?

The GPT assistant is named 'Motivation Mover' during the configuration process.

What types of motivational quotes does the 'Motivation Mover' focus on?

The 'Motivation Mover' focuses on providing general life inspiration quotes.

How does the GPT assistant handle user requests for quotes?

In this example, the GPT assistant is set up to provide random quotes without asking for context.

What is the role of Zapier in this setup?

Zapier acts as an intermediary that connects the GPT assistant to the Notion database, enabling the saving of motivational quotes into the database.

How is the Zapier action for Notion created?

The Zapier action is created by linking the OpenAI account with Zapier, specifying the action as creating a Database item in Notion, and naming the action 'NotionCreateDatabaseItem'.

What is the significance of the 'AvailableActionId' in the Zapier action?

The 'AvailableActionId' is a unique identifier for the Zapier action that is required to link the GPT assistant with the action in Notion.

How does the GPT assistant know which Notion database to add quotes to?

The user specifies the name of the Notion database 'Inspirational Quotes' during the configuration process, which the GPT assistant uses to determine where to add the quotes.

What is the importance of reviewing actions before running them in Zapier?

Reviewing actions before running them helps ensure that the correct information is being used and that the action will be performed as intended, which is crucial for troubleshooting and preventing errors.

How does the GPT assistant handle errors or incomplete messages?

If the GPT assistant hallucinates or does not complete the entire message, it is helpful to review the actions before running to catch any potential issues and make necessary corrections.

What is the final outcome of the process described in the transcript?

The final outcome is a successfully configured GPT assistant that can provide motivational quotes and automatically save them into a specified Notion database through Zapier actions.

Outlines

00:00

🤖 Setting Up a GPT Assistant with Zapier and Notion

The paragraph introduces the process of setting up a GPT assistant using OpenAI's front end and connecting it to a Notion database via Zapier. The assistant is designed to provide motivational quotes and save them into a Notion database. The user interacts with the GPT assistant through a chat window, where the conversation helps configure the assistant's workflow. The assistant, named 'Motivation Mover', is to focus on general life inspiration quotes and save them randomly without asking for context. The paragraph also describes the technical steps involved in configuring the GPT assistant, including updating its behavior, naming it, and refining its context.

05:03

🔗 Integrating Zapier Actions for Motivational Quotes

This paragraph delves into the integration of Zapier actions with the GPT assistant. It explains how to create a new action in Zapier and link it to the OpenAI account. The user is guided through the process of selecting the 'Notion' app and creating a 'Database item' action. The action is named 'NotionCreateDatabaseItem', and a preview is required before running the AI action. The paragraph also covers the import of a special URL to autofill the schema for the Zapier action and the importance of the action ID for future reference.

10:09

📝 Adding Quotes to Notion Database

The focus of this paragraph is on the实际操作 of adding motivational quotes to a Notion database using the GPT assistant. The user creates a new database titled 'Inspirational Quotes' in Notion and sets up the GPT assistant to request the addition of quotes to this database. The assistant generates a quote about overcoming challenges and prompts the user to confirm its addition to the database. The process involves an initial review step before the quote is officially added to the Notion database, demonstrating the practical application of the GPT assistant's integration with Zapier and Notion.

15:10

🛠️ Troubleshooting and Refining the GPT Integration

The paragraph discusses troubleshooting and refining the integration between the GPT assistant, Zapier, and Notion. It highlights the importance of correct variable naming and the potential for the GPT assistant to execute actions despite minor errors. The user corrects the variable name from 'RequiredActionId' to 'AvailableActionId' to fix the issue. The paragraph also emphasizes the power of the GPT assistant in executing tasks on the first pass and the need for careful review to ensure smooth operation.

20:13

🌟 Finalizing the GPT, Zapier, and Notion Workflow

This paragraph wraps up the tutorial by summarizing the steps taken to create a GPT assistant that generates motivational quotes and stores them in a Notion database using Zapier. The user has successfully set up the assistant, integrated Zapier actions, and resolved any issues. The paragraph encourages viewers to consider their own personal and business workflows to leverage the power of GPT assistants and custom actions for various applications, such as content creation and organization. The tutorial concludes with a prompt for feedback and a thank you note to the viewers.

Keywords

💡GPT assistant

A GPT (Generative Pre-trained Transformer) assistant refers to an AI-driven tool that uses natural language processing to interact with users, providing responses and completing tasks. In the context of the video, the GPT assistant is being configured to offer motivational quotes and save them into a Notion database, demonstrating its utility in personal productivity and organization.

💡Zapier

Zapier is an online automation tool that connects different web applications, allowing them to interact with each other without direct intervention. It is instrumental in the video for linking the GPT assistant to the Notion database, enabling the seamless transfer of motivational quotes from the assistant to the database.

💡Notion Database

Notion is an all-in-one workspace that includes a database feature for organizing information. In the video, the Notion database serves as a storage system for motivational quotes generated by the GPT assistant. It is an example of how Notion can be integrated with other tools for enhanced productivity.

💡Workflows

Workflows refer to the sequence of steps or processes involved in completing a task or achieving a goal. In the video, workflows are associated with the automated actions performed by the GPT assistant, such as generating quotes and saving them into a database.

💡Configuration

Configuration involves the process of setting up or defining the parameters and settings of a system or tool. In the context of the video, the GPT assistant's configuration entails specifying its purpose, behavior, and the actions it should perform, such as saving quotes into a Notion database.

💡Chat window

A chat window is an interface that allows users to communicate with another entity, such as a person or an AI, through text-based messages. In the video, the chat window is where the user interacts with the GPT assistant to build and configure its functionalities.

💡Motivational quotes

Motivational quotes are phrases or sayings that are intended to inspire and encourage individuals to take action or adopt a positive mindset. In the video, the GPT assistant's primary function is to generate such quotes for the user, which are then saved into the Notion database.

💡User experience (UX)

User experience, or UX, refers to the overall experience a user has while interacting with a system or product, focusing on aspects such as ease of use, accessibility, and satisfaction. In the video, the chat window's conversation starters and the actions available for the user to click are designed to enhance the UX.

💡APIs

APIs, or Application Programming Interfaces, are sets of protocols and tools that allow different software applications to communicate with each other. In the video, APIs are implicitly used when the GPT assistant interacts with Zapier and Notion, facilitating the automation process.

💡Custom actions

Custom actions refer to user-defined tasks or processes that are not part of a system's standard functionalities. In the video, the custom action involves setting up a GPT assistant to perform a specific workflow, which includes generating motivational quotes and saving them into a Notion database via Zapier.

💡Integration

Integration in this context refers to the process of combining two or more systems or tools to work together seamlessly. The video illustrates the integration of the GPT assistant with Zapier and Notion, allowing for the automated transfer of data between these platforms.

Highlights

The process of setting up a GPT assistant to interact with a Notion database through Zapier is discussed.

GPT assistants are essentially workflows that can be programmed to perform specific tasks.

The creation of a GPT assistant named 'Motivation Mover' is detailed, designed to provide motivational quotes.

The assistant's purpose is refined to focus on providing general life inspiration quotes.

The configuration tab is used to define the assistant's role and instructions for the user.

A Zapier action is integrated into the GPT assistant to save quotes into a Notion database.

The special URL for GPT writing instructions in Zapier is mentioned for importing the schema.

Two actions are populated under 'available actions': 'list available actions' and 'run action'.

The creation of the first Zap is explained, which involves linking the GPT assistant to Zapier.

The importance of the action name and ID in the Zapier action is emphasized for successful integration.

The process of enabling the GPT action and troubleshooting potential issues is outlined.

The Notion database is set up to store the motivational quotes, with a focus on proper naming for access control.

The GPT assistant requests user confirmation before adding quotes to the Notion database.

A quote is successfully added to the Notion database as a demonstration of the integrated workflow.

The necessity of reviewing actions before execution is highlighted for accuracy and error prevention.

The importance of variable names in the integration process is discussed, emphasizing precision for successful action.

The GPT assistant's ability to execute tasks despite minor errors showcases its robustness.

The final result is a GPT assistant capable of generating motivational quotes and storing them in a Notion database without user preview.

Transcripts

GPT custom action with Zapier and Notion Database ===

[00:00:00] All right, we're going to run through quickly how to set up a GPT assistant in the

OpenAI front end, connect it through Zapier to a Notion database, because really what

these GPTs are, are just workflows.

So we want these workflows to be able to take actions and do useful things with them.

So this is the, if you click explore, you'll have my GPTs up at the top here, and then

scroll down.

And these are some ones pre made by OpenAI, recently used.

We're gonna go right into create a GPT beta up top.

Hi, I'll help you build a GPT.

So this is a familiar chat window, just like using a chat GPT, where you can start talking

to This chat window and it will help you configure your GPT assistant because everything that

you type in here is just going to get added into the instructions here, which at the end

of the day is a [00:01:00] glorified prompt.

So let's get into it.

I'm going to move myself over here for a second.

Your purpose is to Help me build a GPT assistant that provides motivational quotes for the

user and then saves them through a Zapier action into a Notion database.

Enter.

Updating GPT here means that it's going to start filling out this configure tab here,

which we'll see once it's finished running.

You can do it, little buddy.

GPT behavior updated, checkmark.

How about naming this GPT, Motivation Mover.

Does this name sound good to you?

[00:02:00] Sure.

It's going to generate the profile picture, which it pulls from DALL E3, and you can obviously

have a conversation here and change things around or say, I don't like that name, or

just go straight into the configure tab and enter a name yourself.

Sunshine, I like it, looks great.

Let's refine the context of motivation mover a bit more.

What specific types of motivational quotes should it focus on?

For instance, should it provide quotes for specific situations like overcoming challenges,

starting a new venture, or general life inspiration?

Let's stick to general life inspiration for this example.[00:03:00]

Are there any specific ways you want MotivationMover to handle user requests?

For example, should it always ask for context or should it provide random quotes?

Random quotes are fine for now.

I wonder if this is bugging out here because it's not letting me press enter.

It's just, it's jumping on it.

It's updating it quickly.

Interesting.

I'm going to refresh this for a second.

Configure.

So if we look at the configure tab here, it's auto filled the description and the instructions.

Your role is to assist users by providing motivational quotes and facilitating the saving

of these quotes through a Zapier Action into a Notion database.

So this is good enough to start here.

Okay, I'm going to name this [00:04:00] Motivation to Notion Assistant.

All right.

So below the instructions, we have conversation starters here, which are fine as is because

this is what's going to show up on the bottom right hand side for buttons for you to just

click as a nice UX experience for the user.

But here's where we want to focus in on our Zapier action here.

At the bottom, we have a button that says add actions and it asks for the schema.

For this action here.

Now for Zapier, we're going to go to the new Zapier docs that just launched here.

And they have a GPT writing instructions.

Uh, URL, which I will post in the description below, but this special URL, we're going to

copy to our clipboard, come back to the assistant.

There's a button here that says import from URL.

And if I paste this URL and click [00:05:00] import, it is going to auto fill this schema

for us.

And you'll notice that as soon as I did this, we now have two actions that have populated.

under available actions.

The first one is list available actions.

The next one is run action.

If we look at the path here, there is an important thing that we need to notice here, which is

the available action ID, which is something that we're going to need to retrieve later

when we're creating this ZAP.

Okay, so how do we create our first zap?

We know that this is going to create some sort of motivational quote.

How do we link this up to Zapier?

There's another URL, which is, uh, GPT actions here, which is going to ask you, hey, do you

want to link your open AI account to Zapier allow?

And then you come to this screen here, which is blank.

When you're first starting out because you haven't added any actions [00:06:00] So we're

going to click add a new action here and it's just like creating any other zap that you've

done so we're going to do notion and Then it's going to auto populate with the available

notion things and we want to create a Database item here because that's what we want to try

to do choose account It's a Notion account.

It's going to ask you to link again.

Now for this database value, it's going to say, have AI guess a value for this field.

And I'm going to keep this as is because the AI assistant is going to generate this motivational

quote for us.

And this is what we want in our database.

So, if we show all options here, you can also include some formatting and other things.

This action name is actually important, and we're going to want to fill it out, because

we're going to feed this back to our OpenAI assistant here.

So I'll, it's recommending that I name it NotionCreateDatabaseItem. [00:07:00] Sounds

great.

Now, here's an interesting box, which is require preview before running AI action.

And I'm going to check this box because when the first time you run this, it's helpful

in troubleshooting.

So we're going to enable this action now.

And now instead of the blank page that I had before, I have my first GPT action that we've

created.

And you'll notice this is toggled on obviously needs to be toggled on green and order it

forward to work in your GPT.

So now, how do we link this to our GPT?

If we go back to our Zapier docs, one of the things in the writing instructions here is,

this is what they want you to enter into the prompt screen, which is, here are some rules,

here are instructions for the custom action, and here are the required action.

[00:08:00] So if we copy all of this, And come back to our GPT, we go back to configure.

So under our instructions here, we're going to hit enter a few times just to break the

space.

We're going to paste this entire thing in here.

Okay.

Now the rules are fine.

The instructions are fine.

But for the required actions, they have pre populated some actions that they used in an

example.

Now, how do we get our notion action in here?

Okay.

I'm going to delete.

This one here.

So the first thing is the action name, which if you remember, going back to our actions,

is, show all options, notion create database item.

So that is the first one.

So, we go back to our GPT, delete Google Calendar find event, notion create database item.

And then for this [00:09:00] confirmation link, instead of the confirmation link, what

we're going to do is we're going to paste the, um, action ID, which we're going to get

back from this page when we open up our Zapier action, the URL at the top is going to have

a string of numbers at the end of the URL.

I'm going to copy it and paste it into the GPT so you see this.

So it's a string of numbers and letters.

And this is what the required action ID is actually going to look like.

So, I'm going to do required action ID colon, um, So, now, if this AI assistant is prompted

to add this to [00:10:00] Notion.

It will use this zap in order to create our database item.

So let's pull up our Notion page here.

And I have a list of impactful quotes.

Well, I don't want to just have this all loose like this.

I want to create a new database here.

So I'm going to create a database inline.

I'm going to title it Motivational Quotes.

I actually deleted the title of this.

Inspirational Quotes.

Here, let's delete these for the time being.

So, the reason that this, um, Naming is important because when you actually create this, it's

going to also ask you what [00:11:00] pages do you allow it to access.

And since I already went through this once, I specifically said, hey, this inspirational

quote page is what I want to talk to for Notion.

So keep that in mind if you want to give blanket coverage to your entire Notion workspace or

just a few pages, you have the ability to do that.

But the title of this...

All right.

Now I'm going to go to the, uh, my database, uh, the GPT is going to request, where do

you want to add this?

And since I'm in inspirational quotes, I named this motivational quotes.

Oh, it's impactful quotes.

All right.

Let's see if this works.

I'll come back over here.

Uh, share me a quote about overcoming challenges.[00:12:00]

The greater the obstacle, the more glory and overcoming it.

You got this.

Would you like to add this quote to your database?

All right, that quote is pretty weak, but let's just, for time's sake, let's just say

yes.

We want to add this to a database.

And you can see, all right, now it's calling.

Some info is going to send to actions.

zapier.

com.

Only do this for sites you trust.

Allow.

And this is part of the steps here that it's asking you to do this to make sure that you

want to do this.

Because every time you do this, you start hitting APIs.

You start, you know, using tasks and tokens out in the real world.[00:13:00]

You want to make sure that this is the action you want to do.

Great.

It looks like we can add the quote to your Notion database.

I'm going to start the process now.

Adding the quote.

The

quote is ready.

To be added.

To confirm and complete the action, please visit the following link.

And remember that I checked that box, that I wanted to review this action before sending,

which is why it is doing this step again.

Because I allowed the initial interaction with Zapier, and now it's ready to run.

But before it does, it's gonna say, hey, are you sure?

If I click this link, This is the preview that I wanted to see, okay, which is, it's

got motivational quotes in the database, which is the one that I want, and it's got this

name field in the database being populated with the quote.

[00:14:00] So I'm going to go ahead and let this run.

If you get a blank, here, and it's just a database name where the database name is wrong.

You can go back and prompt your GPT to let them know.

It says, Hey, I've got, you know, a missing body here in this field.

It's blank.

Go make sure that you grab it.

So every now and again, this GPT assistant might hallucinate or not might not complete

the entire message, which was why it's helpful sometimes.

Uh, so review these before running.

We're going to click run.

Action run, you can close this window and return to GPT.

If I show the result details here, you're going to see some additional information from

the zap, which is the URL of the database here.

And then some more information just in case, uh, you have more complex data that you're

sending here than just the motivational quote.

This can get useful because it can be accessed. [00:15:00] Go back to the GPT.

Oh, let's check our notion page.

Here we go.

So now, the greater the obstacle, the more glory in overcoming it.

Okay.

So we've just did three things.

We spun up a GPT.

We gave it instructions on creating motivational quotes.

We've connected to a Zapier Action.

And now, it's taking...

That quote and inserting it into a notion database, and that is what I wanted to show

you here.

If we go back and say, please give me another quote on overcoming challenges.

Strength does not come from winning.

Your struggles develop your strengths.

When you go through hardships and decide not to surrender, that is strength.

Arnold Schwarzenegger.

All right.

That's much better than the first one.

If [00:16:00] you'd like, I'd like you to add this quote to your notion database.

Just let me know.

Okay.

One thing I'm going to do before I say yes, is I'm going to come back to this action.

here.

I'm going to uncheck review, require preview before running AI action.

Click done.

Come back.

Yes.

Please add this to my notion.

Talking to actions.

zapier.

com.

Good job.

GPT assistant.

Yes.

I want you to allow this.

Oh, now it's going to come with a bug.

Is this action ID correct?

Did that change when I checked that [00:17:00] box?

Looks right.

Or J. Can we try that again?

Interesting.

So I wonder why the action ID...

Okay, after troubleshooting this thing for a few minutes, I came to the sudden realization

that variable names are extremely important.

Who would have guessed?

If we click configure down here on our actions, we see our available action run action, which

is running this sap.

What is the variable name?

It is [00:18:00] AvailableActionId.

And what did I place in the instructions?

RequiredActionId, which is not the correct variable name.

So if I change that...

We should fix our problem, which it's kind of impressive that the GPT was able to execute

this on the first pass to begin with.

But that just goes to show you the power of some of these things.

Okay, if we click now, I need motivation for starting something new.

The secret of getting ahead is getting started.

Mark Twain.

Simple.

Again.

Let's add this to Notion.

Database.

Please.

We remember.

Hardships often prepare ordinary people for an extraordinary destiny, was what we had

before.

We're gonna allow the zap.

Action.[00:19:00]

It also says it's checked and I do have the required Zapier AI action enabled for Notion

Create Database item.

So that's the name that we have here before.

Just confirming that we are on the right path here.

The quote, the secret of getting ahead and getting started, Mark Twain, has been successfully

added to your Notion database.

Secret of getting ahead is Mark Tain.

And look, this just added some additional tags as well.

So remember the difference here.

I unchecked the required preview before running AI action here on this Zapier setup page.

So it did not ask me before it ran this.

It just dumped it right into the database.

[00:20:00] So, there is your successful link of creating a GPT.

Having a custom action through Zapier and dumping output into a Notion database.

Now this example is not going to blow anybody's heads off or be super impressive, but I always

find it's helpful to start simple, because then you can start thinking about your own

personal workflows and your businesses.

And your agencies and what are some things that I can do with these GPTs and what are

some custom actions that I can tie a zap into that are helpful if you're creating images

or, um, pulling Canva.

you're making emails, you're writing blog posts or tweets or anything like that, you

want a place to be able to store this because the general chat window in GPT, it's not very

user friendly for storing conversations.

So you [00:21:00] want to be able to tap in to your existing CMSs and whatever you use

to stay organized.

Anyways, that's all I've got today.

Hope you guys enjoyed.

Let me know what you think in the comments.

Thanks for watching. . . .