In this video, I'm gonna show you automations
that can automatically create and publish content to LinkedIn,
Facebook, Twitter,
and X. These image carousels to Instagram
and vertical videos for Instagram
that take B roll and add captions and AI voice overs.
And it's completely, 100% automated.
All by uploading some voice notes into a Slack channel.
Are imported into Air Table
where you can review all of the content
and even review it before it's published.
I'll explain how to build these automations step by step.
How to create the images, the AI voice overs,
and the vertical videos with captions using J sound a video,
and how to publish to LinkedIn,
Facebook, Instagram reels and Twitter all automatically.
I'll even explain how to record these audio notes
so it's easy and chill
so that you can start creating content and grow your business today.
It's way more simple than you think.
I'll show you how to build this all from scratch in make.com Air table
and you can have this up and running.
Now, before we get into
actually building out all of these different automations
and actually building out this air table system,
I'm gonna build out every single column live from scratch.
Let's talk a little bit about how it works.
It all starts in this Slack channel,
where I can simply record an audio note using this icon here.
I simply talk very casually
and I tend to ask myself a couple of different prompts.
Which I'll show you later in the video.
That just makes it super easy.
There's no pressure. Sometimes I might even actually go out for a walk.
And then once I'm done recording this audio,
then an automation will look for those audio notes,
and then it will download the file,
it's gonna create a transcript,
it's gonna extract the main points,
and I'll show you why I do that later.
And then it creates a row in air table right here in this table here
called speak.
And then it simply drops that transcription into a row here.
And so over a period of time,
you're gonna have a bunch of different transcripts in here
from your Slack recordings.
From there, the automation is gonna continue to run
and go down these four different paths
to create posts for LinkedIn and Facebook X
and Twitter, the carousel images for Instagram,
and then the vertical video for the Instagram Real.
And so if we jump back over to air table
and then we jump to the social side,
we can see the post that are generated right here in this column here.
We have the content, then we have the platform,
the type of content it is,
and then a status where we can review it,
approve it. And then finally,
once the automation runs, it'll market published.
And we also just keep track of when it was created and last modified.
Now, what's nice about the way I built
This system is
that you don't actually have to schedule any of this content
and pick a published date
or anything like that. We have a automation and air table,
and I'll show you how to build this from scratch.
But it just runs at some interval that you give it.
It could run once a day, twice a day.
And then it's gonna find a single post that is ready and approved.
Once we approve something here,
it's gonna look for that content in this published view.
You can see here
we have this automation that is looking for an approved post.
And then we have this script here,
which is going to make a call to make.com,
which is going to then trigger the process to publish it
to either LinkedIn, Facebook,
Instagram or Instagram reels or Twitter.
Really based off of this platform and where it's supposed to go.
Some of the automations are more straightforward,
like LinkedIn, Facebook,
where we're simply publishing a text post.
But for Instagram,
we need to loop and create images for each page in the carousel.
If I click here, we can see that example here.
That's what this automation is doing before it finally publishes it.
And then for the vertical videos and these reels,
this automation here is taking the content from this here, here.
And then it's generating audio in my voice,
it's uploading it to Google Drive,
and then it's using this platform here,
Jason to video,
to Take this B roll video that I have here
that's stored on Google Drive.
Where it adds the AI voiceover
mistakes to avoid with AI in your business. So.
And then it adds the captions.
And then finally after it builds that video,
it automatically pushes it to Instagram.
And X is pretty straightforward.
It just posts one of the tweets that was generated here
after you market approved.
And again, you can review the content of any of these posts
before you actually approve it for publishing.
Where this automation will then trigger and pull it through
and send it to this automation
which creates the assets and does the publishing.
And finally the last piece of this automation,
it simply goes back into air table
and marks these posts that were approved for publishing to published.
Then you can then track all of those in this view here.
Alright, so let's dig in.
I'm gonna build out these automations from scratch.
But if you would like access to the entire blueprints,
these automations. So you can simply import these automations
just by clicking a file and uploading it
and getting the entire thing built out for you to save a ton of time.
As well as access to my speak to social air table base
that has everything already built out,
including these automations.
Make sure to check out my new community,
the No Code Architects.
I'm building out a huge template library of automations just like this.
And You'll be able to get access to these automations
and the air table base. So let's start from the very beginning.
I'm now in Slack. If you don't have a Slack account,
go ahead and create one, and then you can create a channel.
I created one called speak to social,
and then I simply used this little icon down here
to record some audio notes directly into that channel.
Now, keep in mind there's a super easy way to record these audio notes.
You don't have to be prepared.
You can go off the top of your head.
You can even make mistakes,
take pauses. That GPT will clean it all up.
In fact, you can just grab your phone and go on a walk
and record directly into the Slack mobile app.
And these are the basic prompts that I give myself as I'm recording
to produce good content through the automations.
I just have a statement where I say,
if you want this thing.
Then I talk about the main problem that people have
attaining this thing. And then
I talk a little bit about
why I'm the authority to speak on this topic
and the number one mistake people make.
And then I talk about that
there's a better way to do this thing that they want.
And then finally, I give them the steps to achieve this thing.
So that's a basic format that you can use.
It makes it super easy, super low pressure.
So you get that audio recording into Slack
so that we can then continue on with the automations.
So the first automation we need to add is for Slack.
Or go ahead and click that.
And then we're gonna watch for private channel messages.
If you don't already have a connection,
you'll need to add that. And then for input method,
you can leave it as a list
and we're gonna select a private channel.
Notice you'll see mine here.
Speak to social. Go ahead and grab that.
You can leave the limit on 2.
You can go ahead and click. Okay.
Now you will need to record a test audio.
So go ahead and do that.
Feel free to use this basic script and prompting method
that I gave you earlier. If you have something real.
It's gonna make the output of our automations better.
And then we're gonna go ahead and run this automation manually.
Go ahead and right click and say choose where to start.
Go ahead and click. Choose manually.
We'll be doing this quite a bit.
It's gonna load up the audio recordings that you have already recorded.
Go ahead and pick that top one.
Click. Okay.
And then down here you can say run once.
That's gonna run the automation.
And pull in that first audio recording
so we can continue to build out the automation.
The next thing we need to do is actually download that audio file.
So go ahead and add Another Slack odule.
Then you can scroll down to download a file.
And then for this, we're gonna use the file from step No. 1.
Go ahead and click into this,
go to files, and then you can click URL,
private download and click. Okay.
Now here you need to add a filter
so that we only continue if that file exists.
Add a condition. You're gonna look for the.
And then you just need to make sure that it exists.
Pick exist, and then you can go ahead and click. Okay.
Now the next thing we need to do
is create the transcription from the downloaded file.
So go ahead and go to transcription chat GPT,
open AI, and then you're gonna scroll down to create a transcription.
Make sure not to pick create a translation.
And then it should automatically detect that we have a file from Slack.
You'll want to use the whisper model.
You can leave the prompt blank and response for format as Jason.
Go ahead and click. Okay.
And then in this next module,
we're going to use chat GPT to create the main points of the audio.
we're gonna look at the audio and just extract all of the main points.
So I'm gonna go here to create a completion.
I'm gonna use the new 4 o model right here.
Max tokens you can put in zero.
I'm gonna go ahead and add a system message here,
and then I'm gonna just Cut and paste this in from my other automation.
You are a detail oriented person
who can extract all the details from written content.
And then I'm gonna go ahead and add another message.
This will be a user.
And then I'm gonna cut paste this in for my other automation template.
And we're going to extract all the details as bullet points
from the text below
and we're gonna use the result from the transcription.
So we see here. I'm gonna go ahead and add the text.
Then I will go ahead and click okay.
And now from here I'm gonna go ahead and save the automation.
Make sure you're saving periodically as you go
cause if you leave this page it will be lost.
And then I'm just gonna run everything to make sure everything is okay.
I'm gonna go ahead and go to choose where to start.
Choose manually. Gonna pick that top recording here.
And then I'm gonna go ahead and just click run.
I was able to get the file,
I downloaded it. Now it's creating the transcription
and now it's creating the bullet points.
We come in here now and we take a look at the result.
Now we have all of the main details from the audio transcription.
And I just like to use this in my future prompts
to make sure that chat GPT always uses all the details as it creates
creates content. And now
the next thing we need to Do
is actually create the row in air table to store this transcription.
So I'm gonna jump into air table.
I'm going to create a new base from scratch.
You have to select a workspace.
I will select production, and this is what a new base looks like.
I'm gonna go ahead and close this.
I'm gonna rename the title here to speak to social demo.
And I'm gonna go ahead and build out this entire table from scratch.
I'm gonna rename this view to spoken word.
That I'm gonna rename the table to speak.
I'm gonna change this main column here,
which is the primary field,
to an auto incrementing field.
Call it the Speak ID. I'm gonna rename the notes to transcription.
I'll leave it as a long text.
I will click save. I'm gonna go ahead and delete this default field
that came in when we created the table.
I'll go ahead and delete this one as well.
And then I'm going to create a new field for Creative Time
just to have that as a reference.
If you leave the field name blank,
then it will simply just give you one for you.
So that's all we need. Now
I'm gonna jump back to the make.com automation.
Now the next thing we need to do
is to create a new row in our air table database.
Create a record. Next,
I need to create a connection for the new base I added in Air Table.
I'm Gonna go to air table,
O off.
I'm gonna give the connection name,
speak to social demo, click save.
Gonna expand this window so I can see it better.
I'm gonna add a new base. Gonna look for that base,
speak to social. Here it is.
I'm gonna add that base. I'm gonna grant access.
Gonna add that connection,
then I can select the base,
speak to social demo. And I'm gonna select the table.
Speak. And I'm simply going to drop in the transcription
from the previous step. Make sure not to grab this one,
which was the detailed bullet points.
I'm gonna grab the transcription that we can go ahead and click. Okay.
Then I'm gonna zoom back out just a little bit,
and I'm gonna rerun this just to make sure everything's working.
Choose where to start, choose manually.
Gonna grab that top audio recording, click. Okay,
run the automation.
What we should see is a new row coming into our new air table base.
Well, that's running.
I'm gonna go ahead and delete these default ones that were created,
come back to the automation.
Looks like it ran to air table.
So now we have a new row, which is our transcription.
So so far, so good.
I'm gonna jump back over to make
and then continue to build everything out.
Next, what I'm gonna do is I'm gonna build a router.
This allows us to create multiple paths for different automations.
I'm going to add Another chat GPT completion here.
In this case, we're going to write the LinkedIn post again.
I'm gonna pick the chat GPT 4 O model.
I'm gonna go ahead and add a new message.
I'm gonna go ahead and pick the system roll.
I'm gonna go ahead and copy and paste the prompt from my template.
Automation. I'll expand this a bit.
It just simply tells the automation that you're an expert
content and automation and AI expert.
You like to create audio brainstorming notes for ideas
and convert them into written content.
And then I give it some guidelines
what the post should look like and how it should be formatted.
And then some additional guidelines
that I wanna make sure the post has.
Looks like I got a little cut off there,
so I'm gonna come back to my template,
make sure I got everything.
I don't want it to include hashtags or emojis.
So I just detailed everything that I wanted for the post.
Then I'm gonna go ahead and add a new message.
The role will be user. And then
I'm gonna cut and paste my prompt from my template
into this message here. And it simply says,
take the transcript below in quotes and write a concise LinkedIn post.
And then I say, use the detailed points below as reference
to make sure you included all the important details.
And I do need to replace this
because it was from a different automation.
So I'm Gonna place in the text from the transcription,
and then I'm gonna replace this with the actual details
from this previous step here.
Before I can click okay, I gotta add in the max tokens,
put in zero. Then I'll go ahead and click okay again.
And then next step, what we need to do is we need to create the.
The actual social post in our air table database.
So I'm gonna jump back to air table
and build out the second half of our air table database,
which is the social side. So I'm gonna go ahead and create a new table,
start from scratch. Call this social.
Go ahead and click save. Now,
for the primary column,
I'm going to make this an auto incrementing field as well.
I'm gonna call this my Social ID.
Click save. I'm gonna rename this to content.
Leave it as a long text. Go ahead and click save.
I'm gonna go ahead and delete these other columns
and then rebuild what I need from scratch.
Next, I'm gonna add a platforms column.
I'm gonna go to single select,
I'm gonna type platforms. Then down here,
I'm gonna add a few options.
I'm gonna add Instagram, real,
LinkedIn X, Twitter,
Facebook, and Instagram
so that we can differentiate between an Instagram post and a real.
Then I'll go ahead and click create field.
And now we have all of those options here.
Next, I'm gonna create a column for type.
So we Can keep track of that.
I'm gonna add another select field.
We'll call it type here. We're gonna add three options. Text,
image, and video.
I'll go ahead and click create field.
Now we're going to create another column for the status.
Another single select will say review,
approved and published. We'll go ahead and click create field.
Then I'm also going to create a created time.
Roll down here to created time.
Can leave this blanket. Make that for you.
Then I'm also going to create a column for modified time.
Scroll down last modified time.
Just so we have that. And then finally,
what we need is a way to link this table back to the speak table.
Because every time we add a transcription,
we are going to link that transcription
with all of the social posts that we create for that transcription.
I'm simply gonna come here.
You can do it really anywhere.
You can add it here if you'd like.
But just so it's not at the end of the screen,
I'm gonna add it here. I'm gonna go ahead and insert to the right.
I'm gonna link to another record.
I'm gonna link to speak.
We don't need to allow to linking to multiple records.
And I'm simply gonna call this field speak.
I'll create that field. You can go ahead and skip.
And now we have this column here.
And now if I jump back to the speak table,
we're gonna see that We also have a link to the social table.
And both of these, you can hide this if you'd like
because you don't actually need to see it.
Come back to social. We're gonna hide this one as well.
Hide field. And now we can come back to make and our automation,
and we can finally create that row.
Let's add the next automation here.
We're gonna add the air table row.
We're gonna create a record.
In this case, we're gonna pick the base.
We're gonna pick the same base again.
Speak to social demo. This time for the table.
We are going to pick the social table for content.
We are going to use the result from this previous step.
You can just grab that result for platforms.
You can uncheck this, and then we can hit LinkedIn.
Now, in this case,
I realize we need to change this field.
Type in air table because we can select multiple platforms.
So I'm gonna come back here,
gonna adjust this to edit
and turn this into a multiple select.
I'll click save, come back to the automation,
and I'm gonna go ahead and refresh.
Now, if I turn off this map,
it will allow me to add multiple values.
So we have LinkedIn here.
I'm gonna uncheck this just so I can select it from the drop down.
Then I'm gonna add another item here.
I'll unselect this again so I can use the drop down.
And then I'm Gonna pick Facebook for the type.
I'm going to unselect this map so that I can select from the drop down.
I'm gonna pick text the status again.
I'm gonna uncheck this map so that I can select from the drop down,
and I'm gonna pick review.
And then here we need to attach this specific record
that we're adding to this table, social,
to this previous transcription that we already created.
So here we are going to add an item.
And for the Record ID,
we are going to use the Record ID that we created in Step 6.
So go ahead and click into that.
We'll click this ID here, and this should be everything that we need.
We can go ahead and click. Okay,
I'm gonna go ahead and click save.
We've done quite a bit of work at this point.
Gonna zoom back out a little bit.
Go back to that first module,
choose where to start, choose manually.
Click this first object, which is the most latest recording.
And then I'm gonna go ahead and click and run this automation.
Create the transcription. Then we're gonna create the details.
Created the transcription row.
Now it's creating the actual post.
And now it created the social post in our air table database.
So now we have a new row in our speak for that transcription.
And if we jump over to social,
we are now going to see our new social post.
And if we click In here
we can see the content that was written from chat GPT.
I'm gonna go ahead and remove these blank rows
that were created in the beginning.
I'm gonna go ahead and just adjust the sort
so that it's always putting the most recent bros
on top. I'm gonna do that on the speak side as well.
Go to the sort, go to the speak ID.
Alright, so now we're rocking and rolling.
But let's just keep going and get through this automation.
So now we've got a couple more to build.
Now we're gonna go ahead and build out the tweet.
So I'm gonna create another chat GPT completion here.
Create a completion. Gonna go ahead and use the same model here.
We're gonna use chat GPT 4 o.
Gonna add a new message for roll.
We're gonna use system going to copy in the from my example.
Basically,
we're just saying you're an expert social media content writer.
And some additional guidelines
that are very similar to the ones before.
We'll add another message for the role.
We're gonna use user gonna copy this from my template.
Automation gonna read in the transcription.
We're gonna create one concise tweet
for each of the important points that we created here.
I'm gonna have to fix this here
and make sure I'm actually grabbing the transcription,
which was in step number three.
So I'm gonna use step number three here.
Click on the text. I need to replace this From the automation,
because I cut and paste it from my other automation,
which is not here. So we're gonna use step 4 right here.
For max tokens, we're gonna put zero,
and then we can go ahead and click OK and continue.
Now we just need to write this back to air table like we did before.
I'm just gonna go ahead and clone this and just change what I need.
Might be a little bit easier.
Gonna have to change everything here.
I have to replace anything that was used in this step.
I'm gonna have to use this step instead.
So I'm gonna grab this result instead of the one that was there.
That's why it looked the way it did with no color in this case.
I'm gonna delete these two platforms.
I'm gonna add a different platform.
I'm gonna uncheck this. This is an X and Twitter tweet.
The type is text. We're gonna leave the status and review.
We can use the same transcription row that we created in air table.
So that should be good to go.
I'm gonna go ahead and click okay and click save.
I'm not gonna test now.
I'm gonna go ahead and continue to build all this out,
and then we'll do one final test
and correct any issues that we had at that point.
So I'm gonna create another route there.
Go ahead and align it. Gonna make another chat GPT completion open AI
create a completion Gonna use the model 4 o.
As always, gonna add a new message.
In this case, I'm gonna go ahead and just use a user message.
And right now, what we are doing is
we're creating the slide deck messages for the Instagram carousel.
So I'm gonna put in a prompt here.
Say, read the transcript below,
and summarize it into five main points that are 15 words or less.
So then when we create those slides,
will have a. It's a synced sentence on each one.
Then I need to add the transcript.
So I'm gonna come down here and add that.
For max tokens, I'm gonna go ahead and put zero,
and then I can go ahead and click. Okay,
now we need to create the air table record for that post.
I'm gonna go ahead and clone it,
add it to this out here.
Then let's change all the information relevant to this.
Again, we're gonna have to change the content.
So I'm gonna take that out and add the content from here.
This time, it's gonna go to Instagram.
So I'm gonna go ahead and remove that,
add a different platform, remove the map,
and then select it here. Instagram.
Make sure not to pick real.
That's for the video. For type,
we're gonna change this to image.
And the status can stay in review.
And we can go ahead and click. Okay,
so one more automation to add for this first part of this system.
Now I'm gonna add one more route chat GPT completion.
Again, we're gonna use the 4 O model.
We're gonna add the message for the role.
I'm gonna go ahead and use user.
Now, in this automation here,
I'm building out the voice over script for the video
that we're gonna create for the vertical video on Instagram reels.
So I'm gonna copy over my prompt from the other automation
and I'm gonna say,
read the transcript below and summarize it into a script that,
if read aloud, would be 18 seconds or less.
And I just said that
because the roll video that I'm gonna put this audio on top of
is only 28 seconds. So I just wanted to make sure it was less than that.
And then I need to add in the transcript so we have that.
Then I can put in the max tokens to 0.
Go ahead and click. Okay.
Then we need to add in the air table row.
I'm gonna straighten this out just a little bit.
Clone this air table row connected up here.
And we need to fix everything again.
We need to change the content to content produced in this GPT here.
I'm gonna change the value of the platform to Instagram real.
The type is going to be video
and the status will come in as review.
So now I can go ahead and click okay
and save it.
And the reason why I'm not building the graphics Or the video.
In this stage is so that when we add the content to our social table,
we'll have a chance to update the text and the content
before we click approve. And that ultimately,
the automation to push it to social media.
So I'm gonna go ahead and save this back out a little bit.
Let's go ahead and run this from the beginning.
I'm gonna choose where to start,
choose manually. I'll pick the most recent voice note,
click OK,
and then let's go ahead and run this and see if we have any errors.
It's creating the transcription now.
It created the row and air table of that transcription.
We have that right here, actually.
That was right here.
Now it's actually creating the individual posts now.
It's gone through each of the different automations,
and we can see that we have those five new posts
just created right now.
So now we can format the table just a little bit.
And then you can always look inside.
Of the various pieces of content that is being created.
And then you can tweak it.
You can come back and you can tweak your prompts
to generate the type of content that you want.
We can see what platforms
that everything is going to be distributed to
once we set up the automations,
and then we create the new.
Make automations to create the content,
create the videos, the images,
and then to actually post everything once
We adjust the status to review.
So on that note, just to get ready for the next step,
I'm gonna go ahead and create a couple more views here.
I'm gonna rename this one to approve.
Then I'm gonna duplicate this to publish.
And then finally one more to published.
And then I'm gonna adjust the filters of each of these.
I'm gonna go to approve
and add a filter where we only see the status of review.
And then here,
we wanna make sure that we only see the status for approved.
And then here, we want to see only the status for published.
That way, if we come here and we approve something,
we'll see it here. And then if something's published,
we'll actually see it right here.