How to Post Everywhere Automatically with Sheets → n8n/Make → Blotato

Full video transcript

How to post everywhere on social media with natnake.com. In this tutorial, I’ll walk you through a simple system where you can track all of your content in a Google sheet. And when something is ready to post, you change its status to ready to post. And then your n8n or Make.com automation pulls the content that’s ready to post and then pushes it out to nine social platforms and finally updates the status of the item in your Google sheet.

This system is really powerful because you can customize every single step. For example, if you want to post slideshows to TikTok, carousels to Instagram, videos to YouTube, long-form threads to Twitter, threads and Bluesky — you can do all of the above. By the way, you can download these templates; check the video description for the link. You don’t need to sign up for any community to get these templates.

Real quick, if you don’t know me, my name is Sabrina Ramonov. I’ve grown from zero to 1 million followers in the past year. I previously sold an AI company for millions of dollars, and now I’ve built an AI app called Blotato that you can use for publishing to social platforms.

First, we’re going to walk through a high level of how the automation works, and then I’ll walk you through how to set it up for both n8n and Make.com. So this section over here in purple basically checks your Google Sheets every 3 hours, looks for anything that is ready to post, grabs one of the items — so even if you have multiple items, it’s only going to grab one so that you don’t spam social platforms with too many posts at the same time. It fetches the unique Google Drive ID of the media, the image or video that you’re posting, uploads it to Blotato, and then this green section over here is what pushes it out to all of the social platforms.

Now, for each of these sections, I’ve put a lot of documentation on what you need to get it going, how this template works, links to helpful stuff, as well as platform-specific notes. It looks like a lot, but I wanted to be thorough with the documentation. Over here in Make.com, it’s the same exact process. So this checks for anything ready to post, gets the ID, uploads the asset to Blotato, and then pushes it out to all the social platforms.

Okay, so how do you actually set this up? In order to post to social media, we’re going to use an API that I’ve built called Blotato. I built it for myself because it was really painful to publish to social media through n8n and Make.com. So sign up for this. Once you’re in, go to settings on the bottom left, go to API, and generate your API key. Note that this is a paid feature, so I’m trying to reduce spam — this feature is not available on the free trial.

Once you have your API key, you’re going to install the Blotato node. Go to the admin panel of your n8n instance. The Blotato node is an approved n8n community node, so you can install it on cloud-hosted n8n as well as self-hosted n8n. Go to your admin panel, scroll down, make sure you have this beta feature enabled — the ability to use verified community nodes. Save changes. Make sure you install the community node first. But if you went ahead and imported this template and now you see a bunch of question marks, go to the right-hand side, make sure verified community nodes is enabled in your admin panel like we talked about, and then search for Blotato and click install node. Once it’s installed, all of these question marks will go away. I recommend installing the Blotato node before importing the template, because if you try to do it after importing the template, everything here will be blank. Just open up any existing n8n project, search for Blotato, install it, and then import this.

Once you have that set up, you’re going to add a credential with your Blotato API key. Copy the API key to Blotato here, click save, and it’s going to test the connection. Once you’ve done that, go ahead and open this up and make sure you select the Blotato credential that you just created. You don’t need to change anything else.

The next step is to connect your account. Open up each node, make sure your credential is selected, and then choose the TikTok account that you want to publish to. You don’t need to change anything else. Then do that for each one: choose your LinkedIn account, choose your Facebook account — for Facebook, you’ll have to choose a page as well. Choose your Instagram, Twitter, YouTube, Threads, Bluesky, and Pinterest. For Pinterest, you will need to put your board ID as well, so I’ll show you how to get that. Go over to Blotato, create a post, create a sample Pinterest post, then click publish. In this dropdown, select the board you want to publish to, and you’re going to see your board ID right here. Go ahead and type that into the Pinterest board field.

I recommend when you’re testing this out to deactivate the nodes that you don’t need. Start with one at a time — let’s deactivate them all — and just start by testing TikTok or start by testing LinkedIn.

Now the last piece we’re going to set up is the Google sheet. I tried to make this as simple as possible, but you can always customize and build complexity on top. This is just the bare minimum that you need for your Google sheet. This will be a title for your video, and this will be used in YouTube as the title. This is the media URL — drop the image or video into a Google Drive folder that is publicly accessible so that our automation can go ahead and fetch that image or video. This is the caption that will be published along with the video. And then this is the status — really simple: in progress (you’re currently working on it), ready to post, or posted.

If you go back to the automation, you can see the link to this Google sheet — copy this sample Google sheet, copy it to your folder, and ensure that your Google Drive folder containing your media is actually public, so that Blotato can grab the images and videos to post to social media. Once you have that, you’re pretty much ready to go.

When you’re testing it, change one of these items to ready to post. What I like to do for testing is to run this section first, then pin the data at this step, and then test each of these platforms. To run just this section, you can click this play button above here and it’s just going to run this initial section. When it’s done, open this other menu, click pin, and what this is going to do is just save the data at this step, so you don’t have to rerun this section every time that you want to test these nodes. Then to test one at a time, open up TikTok, make sure your account is selected, and then you can click execute step up here or click the play button here to test one at a time.

I want to show you some other links as well. To go to the Blotato API docs, just click this link — help.blotato.com — to troubleshoot errors. This is super handy. If you go to blotato.com/api dashboard here, you can see all of the requests so far. If there’s an error, you’ll see it highlighted in red, or yellow like this for things that are completed. You can even view the successful post — you can see the entire request payload. This is incredibly useful for debugging. Each platform does have specific media requirements, so here is a list of media requirements per platform — that’s this link here. And if you need additional help, I’m always happy to help troubleshoot people’s automations — click this orange button on the bottom right corner, and I try to answer everything within 24 hours on most weekdays.

That’s pretty much it to get it up and running. Step one was to set up this Google sheet, and you will need to configure this node — you’ll need to select your own Google sheet, not my Google sheet. Make sure that we’re filtering on the column status. What this means is we’re looking for records that are ready to post. And then return only the first matching row, because you don’t want to take three items and then post them to nine social platforms — that would be considered spamming. You just want to take one thing that’s ready to post. Then this automation will check again in 3 hours to look for another thing that’s ready to post and then go post it. Obviously you can tweak this as well if you want it to check more frequently — reduce this; if you want a bigger spacing, increase this. Don’t touch this — all it does is extract the ID.

Step two, just make sure you set up your Blotato credential. And step three is just to choose the social accounts you want to publish to. And that’s pretty much it and it should work.

On the right-hand side here, I put platform-specific notes. A couple things I want to point out that are really important: please don’t use any third-party tool or automation when posting to TikTok if your account is brand new and not warmed up yet — you will be shadowbanned instantly and it will ruin that particular account. So follow this warm-up guide — this is a complete warm-up guide for new TikTok accounts. And for each platform, there’s a set of best practices and specific troubleshooting FAQs. For example, for TikTok: how to connect your TikTok accounts, brand-new-accounts best-practices playbook — this is based on my own experience growing from zero to half a million TikTok followers — and a troubleshooting section. You’ll see this link for each platform, and it’ll contain best practices and troubleshooting tips for each social platform.

Okay, that’s pretty much it for the n8n version. I’ll walk through Make.com really quickly, but it’s very, very similar. First, to set how often this will run, click here down at the bottom — right now I have it running every 3 hours, so 180 minutes, but obviously you can tweak this. Open it up and make sure you have Google Sheets connected, pointing to the correct sheet ID. And this should be the query: select all records that are ready to post, but limit it to the first one again, so we don’t spam the social platforms. Get the Google Drive ID — you don’t need to do anything.

By the way, there’s a little note on top of each of these: here’s the Google sheet you can copy — this one says don’t touch this; this one says all you have to do is select your Blotato account. Open this up, select your Blotato account — you do not need to change this URL, it already works. Just like n8n, select the accounts that you want to post to, and I’ve put helpful documentation here. Select your TikTok account — you can post images, videos, and slideshows.

Let’s open this up — create that Blotato connection, choose your platform, choose your TikTok account, and additional parameters here — but for your first run-through, you don’t need to change any of these things. I just want to show that if you do want to customize some parameters, click show advanced settings and you’ll see a lot more parameters, for example your slideshow title, music for the slideshow, whether you want to disable any of these things.

Similarly for LinkedIn, make your connection, choose your LinkedIn account, if you want to publish to a page, here it is, and do the same thing. For Pinterest, this is where you’re going to have to put in your board ID. Last step: it updates the spreadsheet — the item that has just been posted will have the status posted.

If you need any additional help or have questions on the API, go to help.blotato.com — there’s a whole section for the API. If you want the detailed API docs, I have a reference over here that goes into a lot more information, but these templates should work out of the box. Again, all you have to do is set up that Google Sheet, connect your Blotato accounts, and then choose which social accounts that you want to publish to.

If you have any questions or need help debugging your automation, remember to go into Blotato, click this orange button, and send me a message. Thanks for watching. If you want more tutorials on n8n and Make.com, hit like, hit subscribe, and drop a comment below — would love to hear from you.