Automate Content Creation and Scheduling with this Workflow (Make.com and Airtable Tutorial)
Summary
TLDRIn this video, the presenter explains their content creation workflow using Airtable and Make.com. They demonstrate how to generate, schedule, and publish posts automatically on LinkedIn, Twitter, and Facebook. The tutorial covers setting up Airtable fields, creating automations for publishing, and using AI tools for content generation. The workflow aims to streamline content management and reduce reliance on multiple software tools. The video concludes with an invitation to viewers to subscribe, like, and book a call for business consultations.
Takeaways
- 😀 The video presents a content creation workflow using Airtable and Make.com to streamline posting on LinkedIn, Twitter, and Facebook.
- 🛠️ The workflow is built on Airtable and incorporates automation to save time and reduce the need for multiple software subscriptions.
- 📅 It features a visual scheduler and automatic publishing capabilities with calendar views for scheduling content.
- 🔄 The system allows for automatic repurposing of content to different platforms, enhancing efficiency.
- 🆓 The presented solution is offered for free, contrasting with other paid platforms, and aims to maximize the return on investment for content creators.
- 📝 The workflow includes two main processes: AI content building and publishing/scheduling, both facilitated by Make.com automations.
- 📈 It uses the GPT API for AI-generated content and image generation, providing a hands-off approach to content creation.
- 📝 The video provides a step-by-step tutorial on setting up the workflow in Airtable, including the necessary fields and views.
- 🔗 The tutorial also covers how to set up automations in Airtable that trigger Make.com scripts for publishing content.
- 📸 The AI image generator within the workflow can create images for social media posts, further automating the content creation process.
- 🔗 The video instructs viewers on creating webhooks in Make.com to connect with Airtable for the automated publishing process.
Q & A
What is the main focus of the video content?
-The video focuses on demonstrating a content creation workflow using Airtable and Make.com for platforms like LinkedIn, Twitter, and Facebook.
Why is Airtable mentioned as a crucial tool in the workflow?
-Airtable is highlighted because the workflow interface is built on it, allowing for easy content management, scheduling, and publishing.
What does the video claim about the benefits of using Airtable and Make.com together?
-The video claims that using Airtable and Make.com together can streamline content creation, save money on various software, and automate the posting process.
How does the video suggest using AI in the content creation process?
-The video suggests using AI for generating copy and images, which can then be edited and formatted to create high-quality posts quickly.
What is the role of Make.com in the described workflow?
-Make.com is used for creating automations and custom webhooks that interact with Airtable to automate the posting process on social media platforms.
How does the video ensure that the content is relevant and up-to-date?
-The video describes a process where content ideas are validated and then used to generate posts with the help of AI, ensuring that the content is current and engaging.
What is the significance of the 'status' field in the Airtable setup mentioned in the video?
-The 'status' field is crucial as it tracks the progress of content from 'idea' through 'validated', 'to create', 'scheduled', 'published', and finally 'posted'.
How can users customize the content categories in the workflow?
-Users can customize content categories by adding different options to the 'AI generator' field in Airtable, such as 'news', 'examples', 'case studies', etc.
What is the purpose of the 'schedule date' field in the workflow?
-The 'schedule date' field is used to plan when the content will be automatically posted to the respective platforms, allowing for timed releases.
How does the video guide viewers on setting up automations for content publishing?
-The video provides a step-by-step tutorial on setting up automations in Airtable and Make.com, including creating webhooks and linking them to social media posting.
What is the final outcome viewers can expect after following the video tutorial?
-After following the tutorial, viewers will have a complete content workflow that automates idea generation, content creation with AI, scheduling, and publishing on social media platforms.
Outlines
🚀 Content Creation Workflow Automation
The speaker introduces a streamlined content creation workflow using Airtable and Make.com to automate posting on LinkedIn, Twitter, and Facebook. The process involves creating content, scheduling, and publishing without manual intervention. The video offers a free tool for ultimate automation, accessible through the description, and encourages viewers to support by using affiliate links. The tutorial demonstrates setting up the workflow with Airtable's interface, AI copy and image generation, and automatic publishing through a visual scheduler.
📝 Setting Up the Content Workflow in Airtable
This paragraph details the initial setup of the content workflow in Airtable, including creating fields for ideas, content, attachments, AI generator instructions, and status. It also covers setting up the schedule date and platforms for posting. The speaker guides viewers on creating specific views for different stages of the workflow, such as ideas, creation, scheduling, and publishing, and explains how to filter and organize these views for better management of the content pipeline.
🤖 Automating LinkedIn Post Publishing
The speaker explains the automation process for publishing to LinkedIn, which involves setting conditions based on the schedule date and updating records to a 'publish' status. The automation then triggers a webhook to Make.com, which executes a script for automatic posting. The paragraph includes instructions on setting up a connection between Airtable and Make.com, creating webhooks, and the necessary code for the automation to function correctly.
🔗 Integrating Airtable and Make.com for Automation
This section delves into the technical setup of the automation between Airtable and Make.com. It describes creating scenarios on Make.com, using custom webhooks, and the process of testing these webhooks. The speaker provides a step-by-step guide on configuring the automation to handle different platforms, such as LinkedIn, Facebook, and Twitter, based on the content's intended destination.
💡 AI-Powered Content Generation and Scheduling
The speaker discusses the AI aspect of the workflow, focusing on generating content and images using AI. The process involves selecting ideas, setting AI generator instructions, and triggering the automation to create posts or images. The paragraph outlines the conditions for triggering the AI generation, the use of OpenAI's API, and how to input the generated content back into Airtable, updating the status from 'generate post' to 'post generated'.
🌟 Conclusion and Call to Action
In the concluding paragraph, the speaker summarizes the workflow and its benefits for content creation, emphasizing the potential for leveraging the system for various types of content beyond just text posts. They encourage viewers to engage with the content, subscribe, and book a call for businesses interested in implementing similar systems to save time and increase profitability.
Mindmap
Keywords
💡Content Creation Workflow
💡Airtable
💡Make.com
💡Automation
💡AI Copywriting Tool
💡AI Image Generator
💡API (Application Programming Interface)
💡Scheduling
💡Drag and Drop
💡Ultimate Automation Page
💡Affiliate Links
Highlights
Introduction of a streamlined content creation workflow for LinkedIn, Twitter, and Facebook using Airtable and Make.com.
Content can be automatically posted without manual intervention after being dragged and dropped into the calendar in Airtable.
The workflow includes an AI copywriting tool and an AI image generator for content creation.
Integration with the GPT 4.0 API for content generation.
Free access to the tool is provided through the ultimate automation page link in the description.
Tutorial on setting up the workflow using Airtable and Make.com for content creation and scheduling.
Explanation of the workflow's interface built on Airtable with different views and filters.
Demonstration of generating an idea and scheduling it for publishing on LinkedIn.
Instructions on how to add necessary fields to the Airtable base for the workflow.
Guide on creating views in Airtable to filter and organize content by status.
Setup of automations in Airtable for linking with Make.com to automate the publishing process.
Creating webhooks in Make.com to establish a connection with Airtable for automated tasks.
Detailed steps to configure the LinkedIn publishing automation within Make.com.
How to generate AI-based content and images and integrate them into the Airtable workflow.
Use of custom instructions for the AI generator to tailor the quality and style of the content.
Finalizing the workflow setup by saving and activating the automations in Make.com.
Potential applications of the workflow for various types of content creation beyond social media posts.
Invitation for businesses to book a call to discuss implementing similar systems for efficiency gains.
Closing remarks and an invitation to engage with the content by liking, subscribing, and activating notifications.
Transcripts
hello everyone in this video today we're
going to be going over my content
creation workflow basically just
LinkedIn X or Twitter and Facebook I
just need to go on N table you know
create my contents and automatically
drag and drop it to my calendar and N
table it will automatically be posted I
don't need to do anything else and this
has a lot of views when you're trying to
sleep streamline and you know save money
on a bunch of different softwares the
interface is all built on air table so
just just need air table and make.com
basically to make this and you can
replace most of the softwares out there
with these just two tools so yeah if you
want the tool you just go down below in
the description and you can get it for
completely free by getting the ultimate
automation page down below in the
description like I said it's completely
free and if you want to support me you
can go down to the affiliate links and
sign up to make an air table with those
links all right guys let's go into the
tutorial okay so here we are on the PC
I'm going to show you how this actually
works out so here on the doc which you
can find Down Below in the description
this is basically explaining everything
that's happening in this workflow so as
you can see the workflow uh has an easy
to use interface it's built on a table
and different views with filters has an
AI copy running tool has an AI image
generator to Tool make with make.com and
using
tgbt uh 4.0 G uh you know API and it
uses a visual visual scheduler autom
automatic publishing with air table
calendar views automatically repurposing
to other platforms and as you can see
this is completely for free as you
compare to other platforms you can get
most more of your bank for your book
right here by building this tool and
this tool has two workflows it has an as
a make.com workflow for AI content
building and and another workflow for
make.com publishing and scheduling they
all Al has a few automations inside of
air table which I will show you how to
set up cuz it has a little bit of code
in here but yeah let's test this out
let's start by generating an idea and
then scheduling to then publishing it to
LinkedIn so you guys can see how this
actually works so you have an idea right
once you once you validate the idea you
click to create and it's going to be
ready here to create the idea and I have
a few ideas here to create which are
only ideas that I'm ready to create you
know I'm ready to work on so I'm going
to tell the AI how to write this you
know edit the content that's going to
pop up here you know maybe generate an
image whatever but here you canot add
the images yourself or you can generated
by AI okay let's say here I want to
generate content about gbt 5 okay let's
say we generate something like this we
go to the AI generator and we're going
to click generate post once we click
generate post it will actually run
through this automation right here and
it will start to generate on GPT as you
can
see once it's generated it's going to go
back to air table and it's going to
generate the LinkedIn post draft through
about the future of AI so we are opening
has been transforming okay so here you
have your your basic post right and
let's say you want to generate an image
you just click generate an image and
it's going to generate an image which
you can use for your LinkedIn post you
know it's incredible how you can do this
in a matter of seconds even though it's
not as good content as if you were
writing this but you can pretty much
edit a few things and make this a very
good very very good post just depends on
how you format your your prompts you can
see image image generated and you know
this is a bunch of random stuff because
I didn't change the AI generator
instructions this these instructions AR
going to determine the quality of your
response okay and once you're once
you're generated your post you edited
whatever you click and you're going to
go over to calendar view which is where
you will schedule your contents so as
you can see open AI news CH bt5 you can
just drag it let's say I wanted to post
it
tomorrow and drag and drop it's gone
from you know to create to scheduled
once I put in in the calendar and once
it's tomorrow it's going to be
automatically posted and run through
this workflow which is pretty
crazy um and this is done through an
automation we're going to set up later
but yeah this is how this actually works
and you know you can choose a platforms
you want to post interiew want LinkedIn
Twitter Facebook you can post to all
platforms it's depending on on whatever
you want so yeah let's go to the
tutorial okay so I created here from a
new table and we're going to actually
delete all of these fields okay you can
name this table however you want I'm
just going to leave it like cuz this is
where most of the things are going to be
happening and you're going to have to
add the following Fields okay what you
need to do is you need to add all of
these fields okay so you need to add the
for the field for
ideal which is just uh single line text
you need to add the content which is a
long text you need to add the
attachments which which is an attachment
and that's the image that's going to be
published with the post uh you need to
add the AI generator instructions which
is uh log text you need to add the AI
generator uh which is like a a single
select with your multiple categories I
have a lot of categories on my content
this is optional if you want to add
these you know you can classify them as
news examples and case studies you know
agency Journey content or whatever and
you can just add this is to to give you
a little bit more reference and what
kind of poy you're going to create this
is the status this is super important
this is idea validated to create
scheduled published and published okay
these are super important so you need to
copy these by step okay now now you need
to add the schedule date which is a
normal normal dates uh dates field which
the local time of yours whatever and
yeah you set it up save it and whatever
okay now you need to add the platforms I
like to include LinkedIn X Twitter um
and Facebook which is the platforms I
mostly post on these three are the main
for especially for text kind of post
kind of content like text and an image
so that's why I like to use those only
the P the platform publish status and
this is super important as well you know
publish to LinkedIn publish to Facebook
publish to the X this just gives you a
little bit more details on what kind of
platform it was published to and and
yeah as you can see not every post is
published to to Facebook to LinkedIn tox
some are just published to LinkedIn the
next thing you would need to do is to
create the the views okay how to create
the views okay you create a new view uh
let's say you want to name it ideas and
but I want to only show the ideas how do
I do this I'm going to hide the fields
which are not important in the ideas
like the content like the attachments
cuz they're going to be uh empty anyway
so I'm going to remove this as of the
the fields so I don't see them and
they're just on the way we're just going
to remove the AI generator AI generator
instructions um platform publish status
and the schedule date because that's
really not important so we're just going
to have have the idea and the content
just to just to uh help me you know
develop a little the idea before I
actually generate it with AI so I going
to have the idea but what if I only want
to show the ideas right here as you can
see here is showing publish content you
ready to post content whatever I'm just
going to go to filters I'm just going to
add a
filter where status
is an idea
and this is just going to show me the
ideas if you want to to St this any of
an idea and valuated idea okay once you
set up the main views which is which are
ideas into creates you can set up a
publish view if you want you know this
is just filter by status and sorted by
the date published and you can set up a
calendar for this as well you know it's
a calendar where you basically linked it
with the dates you know you create a new
view and the date fields and you're
done but for this you just you can add
just the colors select the field select
the field as status and that's it that's
how you get the colors and as for
filters you know just filter down
by where status is any of you know to
create schedule publish or published all
right and that's how you only get these
so you can just drag and drop here try
and drop here and yeah okay so what
we're going to do now is we're going to
go over to the automations tab which is
the pretty much the the backbone of this
of this tool we're going to go we're
going to go to automations we're going
to first go over the first automation
okay so the first automation is the
Linkin publishing automation where the
schedule date is today as you can see
right here which when record matches
condition linked and flow when schedule
dates which is a date is
today um
today
PD you update the record with the status
to publish okay you update the record
from the same record ID status to
publish okay and after you run that
record uh the status to publish we're
not going to actually use publish to
send that automation over to to.com
going to run a script we're then going
to run a script to send the web hook
over
to to make.com which will automatically
publish the post
okay so how do we set up this connection
between air table and make.com that's
what we're going to do for these two uh
for these two posts when need to set
this up for these two so yeah for this
you need to follow me for a second I'm
going to create an example web hooks to
show you how you can send this up for
yourself okay so yeah once once you once
you you're ready you create a new
scenario on make.com you're going to
click custom web hook okay you're going
to click custom web hook and you're
going to well the lighting is going to
appear and you're going to click add a
hug just add a random hook whatever you
you want your name to be you know
contents
work it's whatever this is not the name
is not important and you're going to go
back and you're going to edit
code okay once you click edit code you
can't copy my web hook of course
not but you need to create another one
uh for yourself like I said here and
make that comment side your usern name
scenario what you're going to do is
first you're going to go to input
variables you're going to add your
record ID just like this you're going to
add the value air table record ID you're
going to copy this code this exact same
code I'm going to leave this down in the
description it's going to be on the
templates I don't know what but it's
probably going to be on the
templates and in this two columns right
here you're going to copy address to
your clipboard and you're going to click
paste okay this is going to send the
record ID that is being triggered
okay okay once we test this uh this web
hook we're going to
actually okay once we test this uh web
hook we're going to actually keep
building this specifically for the
publishing part okay right now we're
doing the publishing part was you set
this first two steps up and set this
inside of air table we need to go on and
do all of this
okay so I'm just going to explain it
step step by step so so just click and
add an air table module you know get a
record and with this you're going to
select the table you're working with
okay so in my case it's content
workflow you know table is the my
LinkedIn my LinkedIn workflow and you're
going to actually input your record ID
as a variable okay once you input your
record ID as a variable you have to try
this out you know to get the run this
modu and you know click uh record ID and
you know look for examples okay just run
this once to get the example now you go
to http get a file and this going to be
the attachments your post is going to
have most of the posts are going to have
attachments so you're just going to go
to
attachments um right here here and
you're going to go to URL and that's
pretty much it you get the URL and then
you get the file cuz like for example in
Facebook you need to get the HTTP get a
file function for it or an X to all
right once you do that you're going to
go over and add a router just like this
and you're going to add a filter where
post to LinkedIn and you add the
platforms the platform which is the
variable uh you know you have to contain
LinkedIn go over to here you don't set
this to equal cuz it will can be more it
can be LinkedIn Facebook and X so you
just click contain right here and the
variable will be
platforms uh right here
platforms and contains LinkedIn so if it
contains LinkedIn it's going to go over
to LinkedIn if it just contains Facebook
it's going to go over just to Facebook
Okay post to Facebook this just contains
the five the platforms okay so it just
contains the platform Facebook is going
to go over
here but it can go over the two branches
if it contains both okay this contains
Twitter okay so this all depends on how
you name the the platforms over here so
let's say you name them Facebook
LinkedIn whatever this is perfect here
as well cuz for example I named X
Twitter with uh inside of two two
columns here so so yeah that's what
that's why Twitter is like this
okay okay now once you do this you're
just going to add a LinkedIn which
created which user generated post and
you click the file where it says HTP
geta file and you just create the cont
with the content uh field as the content
you're going to publish which is this
and which end up and end some being
looking something like this the content
variable so yeah I put the content
variable which Republic the main
distribution whatever you
want and you know the air table content
workflow will be
done because now you just got to you
know create a new updated record module
so that you know that it's going to be
published you're just going to be go
over here to record ID you know delete
and put your record ID
you know choose your LinkedIn workflow I
didn't mention this but you should
choose before status change it to
publish platforms you know add the
platforms you're going to add the
platforms that it was linked
in
and oh my God I'm not you're not going
to add the platforms platforms publish
status this is going to be published to
LinkedIn all right
and that's pretty much it published
published to LinkedIn and here it's
published published to
Facebook and yeah pretty much the same
thing for these three and pretty much
the same thing for these three as in
terms of the the photos you know you
choose your page you choose your file
you choose your message and it's just
editing the variables and stuff like
that so yeah we finished the LinkedIn
workflow publishing so that every time
the date passes so let's
say um the date is this is scheduled for
tomorrow okay the date comes and it's
tomorrow now it's today the automation
is going to run it's going to run you
can pretty much do a lot with this this
is just this was just a simple
example but yeah I mean you can you can
um you can do a lot with this like I
said just with this but now we're going
to go over the AI part and how to
actually generate your content with AI
okay so the first part is you're going
to go to ideas and you're just going to
select a few you know to create so that
I can use them as examples so you go to
AI generator instructions this is
absolutely necessary you go to AI
generator you need to generate a post
post generated generate image image
generated so that once you select one of
these variables it activates the
automation once you select generate post
or generate image it will trigger the
Automation and generate a linked content
well uh text content either it's an
image and it's basically the same thing
you will R be running in script to a web
hook so but the the conditions are these
ones when record matches conditions in
the table LinkedIn workflow when AI
generator is any of you need to select
generate post generate image meaning
that when you change the status to
generate post or generate image it's
going to trigger this automation that is
going to run a script which is basically
the same instructions at the at as the
the
one the one in the on the on the other
automation the same script same
everything you need to put your input
variable right here on the side and you
need to just copy and paste the script
okay copy and the script paste your
script you know build your own own web
hook right here on mega.com once you
build your own web hook you're going to
do the same thing and'll get a record
inside of air table this is just
to this is just to get all the data all
the information and then go from there
okay so you get a record based on the
record ID you know you select your
tables and whatever and after that you
will filter down by whether the US
should want to generate a post or
generate an image it's a pretty simp
this this is really really a pretty
simple build especially if you did the
scheduling automations this is pretty
this will be pretty easy for you to
build so you just create a filter which
is going to be Genera post you know you
got
the the condition is the AI
generator is equal to generate post it
will go through here and if the AI
generator is equal to generate image it
will go down here this is just basically
to avoid creating multiple scenarios and
run it all at once
okay so yeah and then you you know
create your prompts you know to to
generate the prompt content I usually
prompt just like this you know first a
message with the system and then I
message with the user system you're a
LinkedIn expert you're in charge of
content creation Department generating
High quality post women structures given
a never separate title from bu just
right please generate LinkedIn post
structures for the following you select
the now you actually input the variables
idea you know you select the idea
category you put the category stru extra
information you know you just add you're
just adding variables from your
Fields so that the has thei has a little
bit more context on the post you're
trying to great okay Max tokens you can
do whatever you want here I set it to
300 but that's just
me and then you're going to go back to
air table and you're going to input all
the data chbt has given to you so that
it's generated and it's posted over here
on the
contents so what you're going to do so
we here on content you're just going to
go to choices to the message and the
content okay that's pretty simple I mean
that's that's all that is you're just
going to put the content and you're
going to change the status from gener
generate post to post
generator and yeah that's pretty much it
just put your record ID from the past
year same thing same thing here just
generate an image you know provide the
custom instructions I'm using di 3 for
better image
quality and you just input the B will
generate image for this post and it's
going to display the idea like for
example what are some PE some of the
people I have R their M from a couple
last months post categories probably
going to be Journey content these custom
instructions for the image like if I
have some custom instructions like make
a guy you know learning or something
like that it's going to follow only
those instructions if you see them as as
you can see if I don't have a time to
put the instructions I will just
generate like that
okay and and is of course is going to
input this to the attachments part uh as
you can see attachments image one file
URL which everything it gives you right
here URL response image name re bu
prompt it's the same thing okay and then
you just change the status to image
generated and the ID to what the ID
that's pretty much it now you have your
automation you click save you turn it on
and you can go ahead and play with this
and you have now a full content workflow
which you can use for everything you
want when it comes to content creation
this is just for text kind of contents
but you can probably use this in any
kind of kind of content not just for
this but to generate a lot of like
YouTube descriptions you can go very
very far with a table and make that com
specially with open AI API you can do a
lot okay so yeah that was pretty much it
on how I built the this workflow right
here hey everyone thanks for watching
this video till the end I hope you find
a lot of value in it if you did just
make sure to leave a comment and like
subscribe activate the Bell cuz I'll be
posting a lot of content like this in
the next following weeks and if you're a
business trying to implement systems
like this make sure to book a call down
below we'll talk about it we'll see what
we can do and we'll see how we can save
you enormous amount of time and energy
inside your business so we can leverage
systems like this to you know elevate a
bunch of profit and you know multiply
your output on your business okay so
yeah if you're interested in that book a
call down below and that's pretty much
it for today's video guys thank you for
watching to the end I hope you found a
lot of value and see you in the next one
bye-bye
Ver Más Videos Relacionados
How I Automated My Workflow with AI Agent Teams (NO-CODE)
How to generate and post Instagram images from Notion with Make.com
Automated Ai Social Media Content System Will Post Daily For You
Save and work on Github for Javascript | chai aur #javascript
How to Rank #1 FREE With Perplexity AI SEO
Make 1,000 YouTube Shorts with THIS AI Automation in 19 Mins! 🤯 (ChatGPT + Canva + Make)
5.0 / 5 (0 votes)