Welcome back to the course.
In this video I'm going to show you step by step how to build a system that creates for you three different
types of content for LinkedIn, Facebook or even your blog.
And here we'll be using Google Sheets.
And now actually let me show you how it works.
For now let's delete it.
So whenever I provide a campaign content subject and an event target audience, it triggers the entire
workflow.
And here I'm actually we use our free agents to generate content.
Let me show you for an example.
Let's go over with health here.
Let's say five tips for better health managing better health.
For example managing better health.
Um, and here let's say beginners, um, beginners in health we can say that.
All right.
And now actually we can go over to executions and wait, um, for the new record.
So it should be running in a while.
As you can see here, it's running for 11 seconds.
So let's wait for some more seconds.
And here we should have the content right there.
And as you can see we've got the LinkedIn post, Facebook post, blog post and even we've got emojis.
We've got um very sophisticated content, very customized for each platform.
And that's great because actually we can only provide here the data and afterwards receive the content.
All right.
Without going to, for example, ChatGPT Cloud or any other platform that you can train your agent that
does specific things.
And then, um, you've got actually you save time and you've got everything automated.
So with all that being said, let's build this entire system.
And also we need to remember in the resources of this material, you will have actually the file with
um, some system instructions here.
The prompts um, that will be using in this video.
With all that being said, what we can do, we can go over and create our automation.
So let's sign in and here create workflow.
All right first things first we want to have a trigger which is Google Sheets.
Um so we trigger on the new row.
And then what we do um we create actually um yeah we create our Google Sheets and they're also in the
resources you can download the template.
Um, so yeah just click here, make a copy and afterwards everything is finished.
Let me make a copy for now so I can, uh like name it templates.
Templates.
All right.
Make a copy.
And now what we can do, we can actually delete all of the data and.
Nice.
It's ready.
Let me go over here.
Um, here and pick my template.
Okay.
Let's add the sheet one.
And we've got row added.
Now what we can do we can go over here and provide the data.
So campaign let's say I like to go ahead with productivity.
Productivity.
Then change the actual content subject.
Actually set it up.
So here.
Let's go over with five tips five tips for I don't know, managing time.
Managing time.
And there for target audience business owners.
We know that business owners um, has limited time.
Um, as all of the people, however especially business owners, are struggling with managing time.
All.
Right.
And this is a great topic for LinkedIn Facebook blog post.
It's really nice what we can do.
We can go over here and fetch test event.
So we've got um, yeah, we've got actually here.
Uh, no, this is not this workflow.
I'm sorry.
Um, let's actually close that, um, fetch test event.
Nice.
So we've got campaign content, subject, target audience, and we've got also these, um, brackets,
um, blank.
However, um, we'll will just create the agents next.
What we do, we actually go over here and we add the, um, actually edit fields.
All right.
So we edit fields and we would like, um, to map um, the content subject and target audience.
So we just drop it here and we rename it as the query.
Then we go ahead and we drop the target audience and we name it as the target audience.
Like this.
And then what we do, we test this step.
So we would like to have um, yeah.
The variable which is query and that's it.
And they're actually let me show you the schema.
All right.
We've got the query and target audience.
That's enough.
Um, actually let's go over ahead.
Let me actually change the camera.
All right.
Um, let's go over next to the step, which is, um, actually, let's go over here, um, or even to
our entire automation will build.
Um, let me show you.
Uh, okay.
Let's go over here.
Next, we've got a step for, um, actually searching the internet.
We'll be using Tavli.
Then we'll split out the data, we'll aggregate, and then we'll use our agents.
And at the end we will update the Google Sheets.
So it's nice to show you on this example.
Let's go over to the next step which is actually our HTTP request.
Okay.
And then um and they're actually inside our file.
Um let's scroll up there and you've got um yeah all of the data.
So method posts and body enabled body content type JSON, usually using JSON.
And here JSON format you need to copy and paste.
Um so what do we have.
Um do we have URL.
No, actually I will paste that in a while.
However, for now let me show you from where you can take it API.
Um click here.
Login into your account.
You've got free account actually 1000 credits.
Um here go over to documentation.
And in the API reference probably you should have this entire URL.
Where do we have URL?
All right.
Like like here we've got the URL.
We can just copy that.
Um, we can go over here.
Uh, where do we have our automation?
We can we can go over there and click send body um, specify using JSON.
And there actually we need to, um, pick our plain text.
All right.
Um, so let's go over to our, uh, all right, to our automation.
Let's paste it.
And inside you need to provide your API key simply here what you have.
Um, you have your API key.
You've got the query.
So actually, you know, that's why we changed, um, here actually we changed, um, this variable
to query, um, search depth.
And we've got the basic include answer.
True.
We've got max results.
You can change them.
Actually, I set it up as three.
Um, and in general you need to provide here your API key.
Let's go back to Tavileh.
And they're just actually like create our API key which is new or even copy our existing one.
Um, so let's go over here and just paste my API key right there.
All right.
Let's paste it.
Let's close it.
And now even change the method to post.
Um let's say let's see if that works.
So as you can see it works.
We've got the query.
And there even we've got three results.
So there the URL um content title.
Um and like result one, result zero.
And result two.
So three of them um what we can do else let's rename it.
So search web.
Uh we can rename it.
And now what we can do, we can just add the field which is split out.
Um, and they're just um.
Yeah.
Name it as results.
Okay.
as results.
There's the step.
So we've got three items.
We've got the URL.
So we split it out three items.
So we've got for each URL row content title publish date content.
And now it's the time for aggregate.
Aggregate.
So combine a field from many items into a list into a single item.
There we can just choose all item data.
Um we can leave the data here.
We will.
We would like to have specified fields and their title and the row content.
So we'll have like one item and they're just look we've got three items at once.
So here we've got data zero, data one, data two and their row content and title for each of them.
And that's how we've got three different items.
So here even what we have seven workflow hacks.
Two is overwhelm and enhance stress free Reproductivity.
What to do if you hate your job but can't just quit?
Also, it's about the health.
Cardiologist shares five simple daily habits to help lower your health attack risk.
So we've got actually, you know, everything in one item, which is very nice.
So in general we've got here five notes.
Firstly we've got a neural audit in a Google Sheets.
Next what we do we edit the fields actually here.
And we change that to the query and target audience without here the space.
And then what we have we have the search internet with Tavileh and we split out and we aggregate aggregate
the content.
Then uh, we can just go ahead with our agent.
So we'll have three of them.
First one is agent for LinkedIn.
Okay.
Let's rename it.
So here LinkedIn.
And I will guide you through because here inside um yeah.
Inside our file we've got the prompt and system message which is which is pretty long.
All right.
So let me guide you through.
Let's click on define below.
And now let's copy the prompt.
So as you can see here inside and we've got the target audience.
However let's see what happens here.
So we've got actually our edit fields.
We've got target audience even um you know actually, you know um, yeah.
Here we've got set search fields.
So we can actually rename it.
So, um, set search fields.
So, like, actually you need to be aware of, um, different names.
All right.
You need to be very careful with actually names of the specific fields.
Otherwise sometimes, like the variables, uh, may not be visible even here.
We've got some problem.
So here.
Let's see.
Um, where do we have this set?
Search fields.
Set search fields.
Item JSON.
Target audience.
All right, so I don't know what happens actually here.
Nevertheless, we can just take this entire field.
Um, okay, so now, um, we can even afterwards see if that works.
So the field is nice.
However, sometimes even we've got, uh, like this problem.
Nevertheless, um, it just an error.
Let's go over here and add the system message.
Um, even before let's add the model, we'll be using OpenAI for Ominae.
You can either use a for Ominae or for O.
It's your choice.
Okay.
Um, let's go over ahead.
Provide the system instructions.
Um, here.
Okay.
Um, so let's go over there.
Um, and just copy this, all of the system instructions, and let me guide you through what we have
inside, okay.
So let's change it to expression and open that.
First we've got the system role.
So we are a professional LinkedIn content specialist who turns articles into high performing LinkedIn
posts aimed at specific professional audiences.
Task details.
Use the article provided to create a LinkedIn post that is clear, engaging.
Optimized for mobile reading tailored to the professional goals and interests of the target audience.
Um, actually, let me change the camera.
Um, Taylor actually written in plain text only.
Um, no formatting and with line breaks for readability.
So you've got all of these instructions like include 1 to 1 and to two emojis to add personality.
Of course you can change them.
These are the instructions I provided for you.
Um, you can just.
Yeah, just change them for better.
Um, maybe you would like to have more emojis.
Um, just more hashtags.
Or just even you can remove the hashtags.
It's your choice.
Um, however, you've got also the output should contain only the final post text, nothing more.
So it's like the safety net for any other fields, because we know llms like to provide, um, the responses,
you know, that are woke sometimes, or even we have some additional elements.
We've got Post requirements.
So here maximum width and 3000 characters.
I don't know about the LinkedIn post length, however I think it's up to 5000 characters.
I'm not sure about it.
So you can like correct me.
Um, however, here also we've got keep the tone um, human and conversational um, example key reminders.
So that's it.
We can notice a step.
Um, let's see if that works.
We've got this red field that indicates we don't have that however, you know, um, yeah, just an
error because when we just highlight that, we, we can see we've got article content.
So let's see what we have filling over overwhelm at work.
Um, you're not alone.
As we juggle have heavy workloads and rising stress levels, it's crucial to find ways to boost our
productivity without sacrificing our wellbeing.
So we've got our agent for LinkedIn created.
it.
Um, let's go ahead and create the agent for Facebook.
Okay.
So let's go over here to define below.
And now we can go over ahead to agent and take the prompt.
All right we've got the prompt.
And here every time again we've got this field.
So here um set search fields.
However you know what's very important.
Let's see right there.
Uh, so we've got a problem with the target audience probably.
Um, let's go over and see what happens.
So let's go over ahead with, um.
Yeah, we've set, um, search fields.
We've got the target audience.
Let's place it here, even what we can do.
Um, yeah.
So it's my bet.
Probably, um, let's change it to first.
Now it should work.
So we've got business owners, um, in the previous agent?
I don't know, actually, um, we would need to to see it later.
Um, because with the item also, it can work.
Nevertheless, even you can like, um, type first and here the brackets or just type the item.
All right.
Sometimes um, it works with the item, sometimes with the first.
Even if you set up the entire automation and you have the item, um, it's showing like when you're
creating the automation, it's showing like item doesn't work in that case.
So here, um, later.
Um, yeah.
Everything is fine.
So it's just a disclaimer for now.
Let's choose it.
Um, we can again run it as a step.
Uh, okay.
Let's wait a while.
All right.
We've got it.
Um, let's go over here to our agent here.
Let's, um, there are the model, which is open AI.
Um.
All right.
And now in general, what we can do, we can add the system message.
And here let me guide you through because again we've got some prompts.
We've got some prompts here.
We've got some prompts that you can just copy and paste simply.
It's as simple as that.
And then what we have system role.
You're an expert Facebook content creator who transform articles into concise, high impact posts crafted
for a specific audience task specification.
Using the provided article, create a Facebook post that is short, attention grabbing, and easy to
read on mobile, designed to match and match the interests, needs and goals of the target audience.
Includes 1 or 2 emojis to add personality and honestly speaking, I don't like to add too much emojis
because actually, um, I don't know.
For me it's just better to add one.
I'm sorry I accidentally, um, accidentally provided here free.
However, what I said I like to provide 1 or 2 emojis for clarity to not overwhelm the viewer.
Because here, as an example, actually in the example you can see we've got one emoji and a second.
So it's enough for me and contains 1 to 3 relevant hashtags.
You can change the value also there, like the.
The structure is very similar with the LinkedIn post specifics and content context example.
Um, however, it's shorter than the LinkedIn post reminders and so on so you can read all of the instructions.
However, I think I provided here everything which is needed.
All right.
Um, so yeah even reminders example I like to use examples, you know, when you use examples in the
system message, um, you like kind of give the template for um, the LM model how it should behave.
Because even sometimes if you really clarify, um, the output, um, like really clarify it in the
best possible way.
Um, even, um, sometimes LM can provide, um, you know, um, And can provide something different.
A little bit and you think, all right, why?
Why?
I provided really clear instructions and you still give me the content.
So for consistency, because we'll be using this agent a lot.
Um, every time actually, or even most of the time you would like to provide the example.
Yeah.
That's right.
Um, so let's like, close it.
I'm sorry.
Let's test a step, even rename it as the Facebook agent or just, um, simply Facebook.
Let's wait.
All right.
Feeling overwhelmed as a business owner, it's time to revolutionize for your work or your workflow.
I'm sorry.
Uh, and now, uh, we've got the Facebook.
And at the end, um, actually, not at the end.
We've got now the agent for, for for for for blog post.
Yeah.
So let's go over with a agent, um, defined below.
And here we've got the a prompt.
Uh, we can just copy that from here.
So we've got the prompt.
Um, okay.
And as you can see right there, what we do again, let's change uh, first.
Okay.
And as you can see I'm using here the field from the aggregate.
So there I just like take this variable and um like yeah put here.
However also I use um kind of the comment which is two JSON string.
So simply you just type the dot and two JSON string.
And when you just take your mouse and you put it here, you can see how it works.
So it converts the array to JSON string the same as JavaScript JSON string Stringify.
All right.
So here you've got even an example.
So we use it um, and for like the clarity I, I actually um yeah combined for you all of these prompts
to use.
So we've got article content target audience.
So we can just copy and paste it without just, you know, setting it, setting it up manually.
Um, let's go over add the model.
So here we've got OpenAI um, GPT four or mini.
Um okay.
Let's add it here and now system uh message.
Okay.
Um, so in the system message again we've got um, the system role, task specification specifics and
content examples and the reminders.
Okay.
So we can just read it.
Um, I don't want to actually, um, cover that everything.
I actually covered this entire instructions.
However, let's see what we have.
Just simply ask you are a skilled and creative blog writer capable of crafting engaging, concise,
and well-structured two paragraph blog blog articles based on provided content task specification.
So write a two paragraph blog article using the provided content.
Ensure that blog is coherent, engaging and informative for a general audience.
Use a was a professional yet friendly tone and specific.
So here this task is designed to create short, high quality blog content and examples.
All right so we've got here example.
So here input output.
The next example and input output reminders.
And that's pretty it.
Um let's rename it as blog post.
That's correct.
Let's rename it.
Now test the step.
All right.
Okay.
Let's wait a while.
It's nice in today's fast paced business world.
Nice.
Okay, so I can say, uh, we are almost done.
Let's put it here.
Okay.
And now the last one, the last step is to update, um, Google Sheets.
Okay.
So this is our output node.
Let's update Google Sheets and here click on Update Road and Sheets and pick our content social media
content template sheet one.
And there what we have column to match on campaign.
And here what we have.
Let's actually close all of these um yeah.
Nodes and their provide a campaign.
Um, here.
All right.
We can provide this campaign, their content subject or even we don't need to update that.
All right, we've got it already.
Um, let's provide content for LinkedIn.
Um, here for Facebook and at the end block.
All right, um, let's go over and test the step, see how it performs.
Okay.
So we've got there actually.
What's happening?
Um, update the row.
Um, all right.
Let's change it to first let's test the step okay.
So now what we have template It.
Okay, so now we've got the content for LinkedIn, Facebook and blog.
All right.
It's nice.
We've got everything.
We've got the campaign content, subject, target audience, LinkedIn, Facebook, blog post nice.
With all that being said, what we can do, we can just rename it, rename this automation as a content
creation.
Let's say automation.
Okay, let's actually, um, now let's make it as active and we can simply test it out.
So let's go over here to the template and add um, the new role.
All right.
The new role.
So here maybe let's type the lifehacks.
Um like here we have the campaign.
So the lifehacks there five lifehacks for um, saving even more time.
Um, and now maybe people are interested in.
life hacks.
Um, let's say beginners, right?
Maybe.
Like this.
And now we can wait.
All right, so let's go over here.
Um, yes.
Let's go over here and click on executions.
And now, hopefully it will appear soon so we can wait a while.
Um, hopefully it appears soon.
I don't want to make a cut here.
Um, okay, so we have, um, actually not there.
Um, let's see, we've got there and provided the campaign content.
Subject, target audience.
Um, okay, let's go over here and let's wait for some more time.
Yes, we've got it running.
Um, we need to remember, um, it actually refreshes every minute, so we've got it running.
And now let's see.
And so it used our LinkedIn Facebook blog post Google Sheets.
And now let's go over to template.
And we've got everything actually, you know, LinkedIn post Facebook post and blog post content created
automatically.
I don't need to do actually I need I don't need to do anything afterwards like content is created.
It's so cool.
Like imagine you've got different platforms X let's say even, um, I don't know, maybe you have the
school group or any other platform.
You can just create this automation that handles everything and afterwards it creates for you the content.
So in general, I hope you enjoyed it.
Remember you can download the template and actually in the resources of this material along with the
instructions.
Um, it's really cool.
All right.
You can do this.
Um, I hope you enjoyed this video.
Remember actually, to leave us an honest review or even rating of the course, it helps us so, so
much.
Uh, thank you for watching.
I hope you enjoyed that.
And I will see you in the next automation.