Speaker 1: Hey everybody, in this video you'll learn how to create an Airtable content calendar which will automatically post any scheduled content that you schedule in Airtable. So let's just jump right into it. This is the content calendar inside of Airtable as you probably already saw in the blog post. So the field types are as following. So topic is a single line text, which, you know, you can just write whatever topic this post is. It could be like, I don't know, Christmas or, you know, New Year's or new promotion or a new product, any kind of topic, and you can sort them out by topics. You can sort the posts by topics. If you wish like to see like a more bird's eye overview of all posts. Next up goes copy which is the copy is a long text so obviously you can write more text inside of copy and you can also write hashtags and everything you wish. Next field is content which is an attachment field type and in here you're just gonna be uploading any photos or videos that you wish to upload. Next up are the channels, and this is a multiple select field, so in here you'll be basically choosing the channels that this post will go on, and you do that by just clicking on and adding a post, I mean the channel. Next up, type of post. This is just a single select, so you can choose either a text or photo or video. I think it's pretty self-explanatory. And then next up is the date. So this is a date field. And in here, you'll just schedule the time for, you'll just schedule the post. So you can say, okay, I want this post to be, I want this post to be scheduled on like 18th of December at, you know, 12. And then these next two fields are just for the integration. And their purpose is to take the date you chose here and make it, convert it into a string. So the IntegraMath or Zapier or any other integration tool we use. So that tool can actually use the date because tools like for integrations tools can't read, so they don't know that this is 18th of December and this is 12 o'clock. So we need to simplify that data for them into a format that's easily readable by them. And that's why we have these formatted date and formatted time fields. And these are just formulas. So this is a formula type of a field. And this is the formula you put in for the date. And this is the formula that you will put in for the time. And what this is doing is basically telling Airtable, okay, format date cell and format it into this format. So give me the hours and give me the minutes. And it's the same for date. It's just converted this date into a string. And this is the date we are looking and the date we are looking at is the date cell. And in here, we just have a status field which will be updated by the integration tool. And what it does is just the integration tool will add a tag whenever it posts a tag whenever it posts the post to Facebook, Instagram, LinkedIn, Twitter or whatever and this is just a multiple select field and in here you also have notes so you can write you know whatever you wish. One more cool thing about this social media calendar is that it has this calendar view so you can click on it and you can actually see that you can have a bird's-eye by overview of all posts that you scheduled. So it's a really, really useful and cool feature of this Airtable calendar. And you do that just by adding a, you go here, you go create and click on calendar view. And it's gonna add this and it's gonna read the data from the calendar field here. And that's it. That's going to be the end of this part of the tutorial, let's move on to the integration tool. In my case I'm using IntegraMath, you can be using Zapier or whatever, I just like using IntegraMath. This is how the integration looks, I know it looks scary but it's really not, you have to have all these modules, but you can imagine having just like a Facebook, Twitter, Instagram and LinkedIn module. Let's start from the beginning. So the first module, it's gonna search records inside of Airtable content calendar, inside of this. And it's gonna go into that calendar and it's gonna go look at the content schedule. So it's gonna look at this sheet every 60 minutes from 12 all the way to eight on every day, basically. Yeah, and I just set this up because I know I will be uploading my content in this time interval. So, you know, there isn't point of IntegraMath looking at the schedule because it won't find anything, you know, and it's just gonna be wasting my credits. So first thing you're gonna set up is this module and it's gonna, you're gonna tell IntegraMath go look at, you know, at this sheet every 60 minutes and you can basically do this, you know, you can say once or every day or, you know, whatever timeframe you wish. Inside of the module itself, we have this, basically this is the hardest part of this integration. So it's going to go look at this table, content schedule, and it's going to take a look at the schedule, not the calendar. And it's going to bring any records that, any records that are matched to this formula. And what this formula does, it's looking at the formatted date and formatted time. So it's looking at these two fields. and this is why we set them up. It's looking at these two fields and it's saying, is this field, is formatted date the same as now? You know, the current date and time. And is formatted time the same as now? So it's basically looking at these two and it's calculating if this post was scheduled for this time. Obviously, if you wanna schedule posts that are gonna be like at item like 4.15 or like, you know, 3.48 or anything but round numbers, so, you know, one, two, three, four, five, whatever, you're gonna be, you will need to set, you will need to adjust this time interval to be less. And you're gonna be, you have to calculate the time interval properly. So in my case, I know that I'm gonna be scheduling posts only on like round numbers. So for me, it makes sense that it just goes and looks every 16 minutes. You're going to be, you have to do a bit of calculation, but I think, you know, worst case scenario, it's going to go look every 15 minutes and then it can schedule posts at like 4.15, 4.30, 4.45, you know, every 15 minutes. But you have to, you have to think about this formula and this interval and make them work together. And you're just gonna put the limit of records here. So to recap, this module goes to Airtable every 60 minutes from times 12 to eight. And it looks at these two fields, formatted time, formatted date. And it looks and searches for any posts that are scheduled for now. So for the current date and time. and it will only return one post. So that's the hardest part of this integration. And next up is the HTTP get a file, which just get this module is just going to be downloading the file from the URL from the content field. So we are doing this in order for everything else to work. When I did it, it didn't include this module. I don't know, for some reason, LinkedIn didn't want to upload the photo or video. It was same with Facebook. So just as like a safeguard, you're gonna put it in this HTTP get a file. And everything this module does is it goes to the content field and it downloads any content that you have in that field. And then you have this router and then this, you know, you have these, all of these modules, which are pretty much the same. They're just for different kind of posts and different kind of social media. One really important thing that you have to set up is these filters. And these filters are gonna be, they're gonna be taking a look at the channels field and type of post field. And that's basically why we have them. And these filters, what are they doing is they are determining where, so what kind of post is this? So what, what, what module should IntegraMath use? Is it like a photo or a text post, you know, same as Twitter, same for Twitter and for Instagram. And second thing it's determining is where should this post go, you know, is it for Facebook and Instagram, you know, Twitter, or is it just for one social media? It's basically determining those two things. And that's why we have all of these filters. And they're pretty simple to set up. You're just gonna click here. You're gonna say, okay, condition is that type of posts is equal to video. And so it's really important to have this. And channel contains Facebook. And so to simplify this in English, this module will be only executed if this post, if the post that we scheduled is for Facebook and is a video post, and that's all. So that's why we have this filter. So if this post is a video and this post is for Facebook, do this module. It's the same for the rest of these modules. If this post is photo and it's for Facebook, execute this. And you just go, you will just go and do this for every module. So if this post is text and it's for Facebook, do this. In this case, if this post is photo and it's for Twitter, do this. And this is set up because, at least in IntegraMath, there isn't a way for us to basically create four modules for, you know, Facebook, Twitter, Instagram, and LinkedIn. And then IntegraMath figures out if that post is a photo or a video or a text, and then it executes, you know, the command according to that. And because we don't have that ability, we have to basically hold hands, hold IntegraMAT hands and tell him, okay, go and look at the type of post and channel and then execute the correct action. So after you set up those filters, I'm just gonna basically create a module for Facebook video, Facebook photo, Facebook text. Twitter video, Twitter photo, Twitter text, Instagram video, and Instagram photo, and then LinkedIn image, LinkedIn text. Unfortunately, LinkedIn doesn't support video as of right now, but they might actually add that module. And this is very easy. So you're just gonna be creating all these modules and you're gonna be mapping data. So you're gonna connect your Facebook account, you're gonna tell which page you're gonna use, and then you're just gonna be telling, okay, upload a video, use HTTP get a file, and as description, put in copy from Airtable. For photo, Facebook photo, same, you know, set up the page, set up the connection, http get a file use the copy from Airtable and then for text it's the same just without the HTTP get a file. For Twitter same as Facebook set up the connection adding the copy from Airtable upload a video so you can see you can't do image or gif or video you can do only image or gif or a or a video. That's why we have two modules. HTTP get a file, leave everything blank. Same as, same for photos, image or GIF. And then you just add in the HTTP get a file here and then you're gonna get a result like this. Same for text, just without the HTTP. Instagram you can only do this if you have a business business account so Instagram for business and they allow you to basically add the video straight from the URL so you don't have to use the HTTP get a file module you just link the content from Airtable here URL you add the caption for copy from Airtable also and then you the same do the same for photo set up the connection page photo URL copy you can see that we also have to have separate module for every medium which is really annoying because you then you end up with integrations like this but it is what it is. LinkedIn, set up the connection, source file, HTTP get a file, link the data from Airtable. These two don't really matter because they're not displayed anywhere so you can just put in wherever fields you wish as long as they are like semi connected to the the title, description could be the file name, title could be ID, just put in some text, map some text to these two fields because they're not displayed in the feed. People will actually see this. And then this, you'll add the copy from Airtable and for text, you just add in the content from Airtable, public, simple text, and that's it. And that's your setup for all of the social media. And then after each, which is, this step is optional, but you can do, what you can do is, you can add an additional module after each social media module that will go back to Airtable and add that tag that we talked about. You know, this tag, posted LinkedIn, posted Facebook, Instagram, or Twitter. And you just add a tag inside here, just map the data, social media calendar, content ID, date, the record ID from air table here. Then just scroll down to status, add the, which is this field, you know, just say, add posted Facebook or whatever. And that's it. And you do that for every other social media. And that's it. That's your integration. This can be created really easily. If you need any more, you know, if you need my help, reach out to the email that is in the blog post. Otherwise, you know, happy integrating. I'd love to see you guys create these. Thank you.