How I Built an Automated Social Media Content Planner (No-code Tutorial)

Minty Analyst
11 Jul 202426:54

Summary

TLDRThis video script outlines the process of building a custom social media post automation tool using Google Sheets for data storage and Make.com for automation. The presenter details creating a user interface with Frontapp for ease of use, setting up a database for post scheduling, and automating posts to platforms like Facebook, Twitter, and LinkedIn via Buffer. The script also covers error checking and notifications, emphasizing the efficiency gains and customization of no-code solutions for specific business needs.

Takeaways

  • 🚀 The video discusses building a custom social media post automation software using Google Sheets for data storage and Make.com for the automation process.
  • 📅 The creator dislikes manually entering posts in Google Sheets and plans to build a simple UI for easier management.
  • 🔗 The UI will allow editing of posts, scheduling them with specific URLs and images, and storing them in a database with their respective schedule dates.
  • 📝 The database is prepared with social media posts created using CH GPT, promoting an Excel add-in with time-saving features.
  • 🖼️ The importance of having different images for posts is highlighted, rather than using the same image from a URL.
  • 🔑 The script mentions using Front Le (likely a typo for Front App) for building the UI on top of the Google Sheets data for better user experience.
  • 🔄 The Make.com scenario will check daily for posts that need to be published and will handle posting to Facebook, Twitter, and LinkedIn using Buffer.
  • 🛠️ Error checking is incorporated to send notifications about the success or failure of the posting process.
  • 🔍 The video includes a detailed walkthrough of setting up the UI in Front App, including data relations and field validations.
  • 📝 The process of automating the posting itself is covered, detailing the steps to create posts on different platforms using Make.com.
  • 🔔 The video concludes with the setup for email notifications to alert the user of successful posts or errors encountered during the process.

Q & A

  • What is the main purpose of the software being built in the script?

    -The main purpose of the software is to automate the process of posting social media content. It uses Google Sheets to store data and Make.com for the automation of posting to platforms like Facebook, Twitter, and LinkedIn.

  • Why is Google Sheets used to store social media post data?

    -Google Sheets is used because it's a simple and accessible way to store and organize data for social media posts, making it easy to manage content and scheduling.

  • What is the role of Make.com in this automation process?

    -Make.com is used to automate the posting process. It checks the Google Sheets database for posts scheduled for the current day and then posts them to the respective social media platforms.

  • Why is a UI being built on top of Google Sheets?

    -A UI is being built to provide a more user-friendly interface for managing social media posts. It allows for easier editing, scheduling, and monitoring of posts without directly interacting with Google Sheets.

  • What is the significance of the 'reference feature' in the database?

    -The 'reference feature' is used to link the social media posts to specific features of the presenter's product, Minty Tools for Excel. It helps in organizing and identifying the content of the posts.

  • How does the automation handle different images for each social media post?

    -Different images are assigned to each post by storing the image URLs in the Google Sheets database. The automation process then retrieves these URLs and includes the appropriate image in each post when publishing.

  • What is the strategy for handling errors during the posting process?

    -The automation includes error checking and sends notifications via email to inform the user whether the posting process was successful or if there were errors. It uses conditional paths in Make.com to handle success and error scenarios.

  • How is the status of a social media post updated after it has been published?

    -After a post is published, the automation updates the status of the post in the Google Sheets database to 'posted', indicating that it has been successfully published.

  • What is the reason for using Buffer for posting to LinkedIn?

    -Buffer is used for LinkedIn because it allows for easier scheduling and management of posts. The automation takes advantage of Buffer's free version, which supports up to 10 posts.

  • How does the automation ensure that only posts for the current day are processed?

    -The automation uses a filter in Make.com to check the 'schedule date' in the Google Sheets database. Only posts with a 'schedule date' matching the current date are considered for posting.

  • What is the benefit of using no-code tools for building this automation?

    -No-code tools allow for the creation of tailored solutions that meet specific needs without the need for extensive coding skills. They can save costs on recurring fees from other platforms and provide flexibility to customize the automation process.

Outlines

00:00

🤖 Building Social Media Automation Software

The speaker introduces a project to create custom social media post automation software using Google Sheets for data storage and Make.com for the automation process. The goal is to avoid manual entry in Google Sheets by building a user interface (UI) with Front App. The software will manage posts, including editing, scheduling, and posting on platforms like Facebook, Twitter, and LinkedIn. The speaker uses their own Excel add-in, Minty Tools for Excel, as an example, showcasing how posts are prepared and stored with scheduling dates, URLs, and images. The UI will facilitate easy editing and posting, with Make.com scenarios checking daily for posts due for publication.

05:02

📋 Setting Up the Social Media Automation UI

The speaker details the process of setting up the UI for the social media automation tool using Front App. They discuss linking the Google Sheet as a data source and creating data relations for features and post statuses. The UI includes a table for social media posts with fields for editing post content, scheduling dates, URLs, and image URLs. The speaker emphasizes the flexibility of the tool, allowing for edits and new posts as needed, and the importance of setting up the UI to ensure that the automation process is smooth and error-free.

10:04

🔄 Automating Social Media Postings with Make.com

The paragraph explains the automation process using Make.com. The speaker sets up a Make scenario to filter posts scheduled for the current day and with a 'scheduled' status. They detail the steps for posting on Facebook, Twitter, and LinkedIn, including handling images, post content, and URLs. For Facebook, they use the 'create a post with photos' action, for Twitter, they mention a limitation in uploading media directly via Make and opt for text content only, and for LinkedIn, they use Buffer due to its ease of scheduling. The speaker also outlines the process for error checking and notifications to ensure successful posting or to identify issues.

15:06

🛠️ Finalizing Automation and Error Handling

The speaker concludes the automation setup by updating the status in Google Sheets to 'posted' after successful posting and implementing error handling with email notifications. They use flow control routers to manage paths for successful posts and those that encounter errors. The email notifications will inform the user whether the posts were successfully published on all platforms or if there were issues with specific platforms. The speaker also sets a filter to ensure the automation only proceeds if there are posts to process and mentions the importance of scheduling the Make scenario to run earlier than the desired posting time to account for potential delays.

20:07

📅 Scheduling and Testing the Automation

The speaker discusses the importance of scheduling the Make scenario to run at an appropriate time, earlier than the desired posting time, to ensure posts are published on time. They mention the limitation of Twitter's API not supporting scheduling and how they work around it by posting directly at the desired time. The speaker also talks about testing the automation with a post scheduled for a future time to ensure everything works correctly before relying on it for regular posting. They demonstrate how to edit and schedule a post for testing and how to adjust the scenario for regular use.

25:08

🌐 Leveraging No-Code for Custom Automation

In the final paragraph, the speaker reflects on the power of no-code tools for creating custom solutions tailored to specific needs. They compare their custom solution to existing platforms like Feedly and Buffer, highlighting the cost savings and the ability to tailor the tool exactly as needed. The speaker also teases an upcoming video where they will share additional ways to use Make.com for automating routine tasks to save time, and they thank the viewers for watching.

Mindmap

Keywords

💡Social Media Post Automation

Social Media Post Automation refers to the process of scheduling and automatically publishing social media content without manual intervention. In the video's context, the creator discusses building a custom solution using Google Sheets and Make.com to automate the posting process across platforms like Facebook, Twitter, and LinkedIn. This is a central theme of the video, showcasing how to save time and streamline social media management.

💡Google Sheets

Google Sheets is a web-based spreadsheet program that is part of the Google Workspace productivity suite. In the video, it is used as a database to store and organize data for social media posts, including content, URLs, images, and schedule dates. It plays a crucial role in the automation process by providing a structured way to input and manage post information.

💡Make.com

Make.com is a no-code automation platform that enables users to create automated workflows without writing any code. The video script describes using Make.com to automate the posting process for social media, checking Google Sheets for posts scheduled for the day and then posting them on various platforms, which demonstrates the utility of no-code tools for automating routine tasks.

💡UI (User Interface)

A User Interface (UI) is the space where interactions between users and a digital product occur. The video mentions building a simple UI on Frontapp to manage social media posts more conveniently. This UI allows for editing posts, scheduling them, and handling images and URLs in a more user-friendly manner than directly interacting with Google Sheets.

💡Frontapp

Frontapp is a no-code platform for building user interfaces on top of existing tools and databases. In the script, the creator prefers to use Frontapp to create a UI for their social media post automation system, which makes it easier to input and manage posts without directly interacting with the underlying Google Sheets database.

💡Buffer

Buffer is a social media management tool that allows users to schedule and publish content across various platforms. The video discusses using Buffer as an intermediary for posting to LinkedIn, due to its limitations on direct integration with Make.com. This highlights the flexibility of using multiple tools in conjunction for a comprehensive solution.

💡Scheduling

Scheduling in the context of the video refers to the process of setting specific dates and times for social media posts to be published. The automation system uses the schedule dates from Google Sheets to determine which posts should be published on a given day, illustrating the importance of timing in social media strategy.

💡Post Content

Post Content is the actual material that is posted on social media platforms. The video script describes preparing social media posts using GPT to generate content for promoting an Excel add-in. This content is then stored in Google Sheets and used in the automation process to populate posts on various platforms.

💡Image URL

An Image URL is the web address of an image that can be linked or embedded in digital content. The video mentions the importance of having different Image URLs for social media posts to enhance visual variety. These URLs are stored in Google Sheets and used in the automation process to include images in social media posts.

💡Status Update

A Status Update in social media terms is a message posted on a profile or feed. In the video, the term is used in relation to updating the status of a social media post in Google Sheets after it has been successfully published. This helps in tracking the progress and outcome of the automated posting process.

💡No-Code

No-Code is a term used to describe tools and platforms that allow users to build applications and systems without writing code. The video emphasizes the power of no-code tools like Make.com and Frontapp in creating a tailored social media post automation system. It highlights how no-code solutions can save costs and provide customized functionality.

Highlights

Building a custom social media post automation software using Google Sheets and Make.com.

Creating a user interface with Front App to manage social media posts without direct Google Sheets interaction.

Utilizing Make.com for the automation of daily posting tasks to streamline the process.

Storing social media post data in Google Sheets, including content, URLs, images, and scheduling dates.

Incorporating a reference feature for image URLs to customize posts with different images.

Scheduling posts for specific dates and times to automate the publishing process.

Implementing error checking and notifications for monitoring the success of automated posts.

Using Front App to create a table for social media posts with linked data sources and relations.

Configuring data types and display settings in Front App for an optimized user interface.

Creating a detailed view for editing and adding new social media posts with various fields.

Automating the posting process with Make.com by filtering and scheduling posts based on the current date.

Integrating with Facebook, Twitter, and LinkedIn to post content automatically.

Using Buffer as an intermediary for posting on LinkedIn due to its limitations with Make.com.

Updating the status in Google Sheets to reflect whether posts are scheduled or posted.

Setting up flow control and email notifications for error handling during the automation process.

Ensuring the automation only proceeds if there are posts to process for the current day.

Testing the automation workflow and receiving confirmation of successful posting via email.

Discussing the advantages of no-code tools for building tailored internal tools that save costs.

Transcripts

play00:00

today we're ditching page tools like

play00:02

feed hiive and buffer and building our

play00:04

own social media post automation

play00:07

software we'll use Google Sheets to

play00:09

store all the data for our social media

play00:12

posts and we'll use make.com to automate

play00:15

the process of posting and because I

play00:17

don't really like having to go into

play00:19

Google Sheets to type in all the posts

play00:22

and set when they should be posted we'll

play00:24

also buil a simple UI in front Le to run

play00:28

everything for us now before we in let

play00:30

me show you what we'll be building so

play00:32

we'll be building this interface where

play00:35

we have our posts we can go in edit them

play00:38

at URLs images to be posted schedule

play00:41

them for a specific date and uh also

play00:44

will be saved in this uh database with

play00:47

the schedule date URLs and so on and so

play00:50

forth and then we'll have this make.com

play00:52

scenario that would go through all those

play00:55

posts each day and see if there are any

play00:58

posts that should be published it will

play01:01

then go through Facebook Twitter for

play01:03

LinkedIn we'll be using buffer update

play01:06

the status for the post and we also do

play01:08

some error checking so we can get a

play01:10

notification and see whether everything

play01:13

worked fine or if there were some errors

play01:16

so here's my database what I did here is

play01:19

uh I've prepared the social media posts

play01:23

I used CH GPT to do that and those are

play01:26

all posts I use to promote my addin

play01:29

minty tools for Excel which is an Excel

play01:31

addin with various time-saving features

play01:35

a little plug here the whole idea is

play01:38

that uh I have the post content I

play01:41

obviously have front Le ID because I

play01:43

want to build the UI on front Le if

play01:46

you're not using front Le or if you

play01:48

don't want to use it you can do

play01:50

everything here in Google sheet and then

play01:54

uh use the make scenario to run and

play01:57

everything will still be automatic I

play01:59

just prefer to have an II on top of that

play02:01

after the post I have this thing

play02:04

referenced feature and uh this is from

play02:07

here I have all my features the only

play02:10

reason I have that is because I'm using

play02:13

my UI to upload the images and then the

play02:17

URL is stored here so that's the only

play02:20

disadvantage you'll have if you don't

play02:22

use front Le or any other no code web

play02:26

Builder you have to upload your images

play02:28

somewhere and then place URLs here so

play02:31

this is just for reference for me you

play02:33

can you can definitely skip that then

play02:36

what's really important is the schedule

play02:38

date so I'll add a date here for each of

play02:41

the posts and when this date comes make

play02:45

will pick this post and schedule it for

play02:48

posting I usually post everything around

play02:51

6:00 p.m. so I won't be dealing with

play02:54

time here but you can also do it uh with

play02:57

specific uh times that you can pass pass

play03:00

through here a URL that I might want to

play03:03

share and then the image URL for the uh

play03:07

image that will be in the post I don't

play03:09

want all posts to just have the same

play03:12

image that's uh being gathered from the

play03:14

URL I want to add different images to

play03:18

all the posts and then just at the end

play03:20

of the post have check it out and the

play03:23

URL and here is the status and uh i' I

play03:27

have it in a separate table so it would

play03:29

be easier to link it in frontally have

play03:31

new scheduled posted and that's it now

play03:34

let's uh go ahead and uh start uh

play03:38

building uh things out so going to go to

play03:41

front Le to pages in my admin app and

play03:43

I'm going to add a new page social media

play03:47

automation that's good before that I

play03:51

have to uh link my data source it's

play03:54

really simple and frontally just copy

play03:58

the URL Google sheet paste it here and

play04:02

I'm importing all those three and then I

play04:05

need to add the data relations so going

play04:08

to add two relations one will be with my

play04:12

referenced feature the front Le ID the

play04:15

ID of the feature should match the

play04:18

social posts referenced feature and I

play04:22

want the feature name to be the display

play04:24

name and my second one is my status

play04:28

again to my social post the status

play04:32

should match the front Le ID in uh my

play04:35

post status uh table and I'm going to

play04:38

display the status go up here save

play04:41

changes and I can go back to my page and

play04:45

uh start building it out and uh once

play04:47

again you can skip that and go directly

play04:50

to building the functionality in um make

play04:54

but uh in my opinion it's much better to

play04:56

have some form of UI like uh it makes it

play04:59

much easier to add things and be sure

play05:02

that you're not breaking anything I'm

play05:04

going to add a simple table here going

play05:06

to link it to my YouTube social post

play05:10

complete setup and uh you see that it

play05:12

messed a lot of the things up so the URL

play05:15

is an image and things like that so

play05:17

actually going to delete that and uh do

play05:20

something yep leave without saving I'm

play05:22

going to go back to uh my data sources

play05:25

and for my social posts I'm going to

play05:28

click on it I'm going to set everything

play05:31

up in here so the post content is text

play05:34

the reference feature doesn't matter

play05:36

it's linked but uh I can always say that

play05:39

uh it's a select then the schedule date

play05:42

that's really important I want to switch

play05:43

it to date the URL will be just text and

play05:48

uh the image URL is an image that's good

play05:50

and the status because it's also going

play05:52

to be a drop- down also going to uh

play05:55

switch it to a drop down to select okay

play05:57

save changes go back to to uh Pages open

play06:01

the social media automation page and uh

play06:04

now I can add a

play06:06

table complete the setup and everything

play06:10

is as it's supposed to so here I don't

play06:13

want to show the reference feature

play06:15

because it's a number I want to show the

play06:18

referenced Feature Feature so this is

play06:21

the actual text that's being pulled from

play06:23

the other table going to say here

play06:26

reference feature okay uh for schedule

play06:30

date going to make sure that it's a date

play06:33

URL is fine image URL and I'm also going

play06:36

to hide the status and rename this one

play06:38

to status and uh that should be about it

play06:42

I'm also going to extend this a bit make

play06:44

it a bit longer when I'm clicking on any

play06:48

of those I'm going to use the default

play06:50

detail view just before that I'm going

play06:53

to see that everything is a post so I

play06:56

get new post here and things like that

play06:58

let's say

play07:00

and uh here edit detail view we're going

play07:03

to start by making sure that this is a

play07:05

text area and I'm going to make it the

play07:09

Min High to like 200 and going to show

play07:12

the advanced settings and make it two

play07:14

columns so that I have a nice big area

play07:17

to edit then the uh schedule date will

play07:21

be right after that and my status will

play07:24

be right after that then I have the

play07:27

reference feature the URL

play07:30

and the image URL I also want to make

play07:33

sure that those are not all required so

play07:36

for example if I am editing something

play07:40

and I'm still not ready to set a date or

play07:43

add the URL or the image I want to still

play07:46

be able to save it so here I'll say edit

play07:49

field validation remove the check

play07:51

unrequired for the uh status again going

play07:56

to remove uh the required and uh don't

play08:00

don't worry that it shows nothing here

play08:03

because it's a related field so those

play08:05

settings won't apply same for the

play08:07

referen feature I don't want it to be

play08:10

required same for the image URL

play08:12

shouldn't be required and the URL itself

play08:17

again shouldn't be required okay save

play08:20

that and uh we should have our uh page

play08:24

ready so if I hit preview and let's take

play08:27

a look at it so we have our post post

play08:29

here you can hover to see the entire

play08:32

post we have the reference feature and

play08:34

we can start editing them so we can at

play08:37

today's date a status can be new the

play08:41

feature and then for URL going to say

play08:45

Min tools.com and uh for an image I'm

play08:50

using this reference to know which image

play08:52

I should pick so pick the audit formula

play08:55

uh image so I'll add my image here

play08:59

that's uh used to portray the audit form

play09:02

feature and I can hit save and you can

play09:05

see that this updated and I can now see

play09:09

my schedule date the URL and uh the

play09:12

image and I can go along and set

play09:15

everything else up or add new posts as I

play09:19

need them now let's uh figure out how to

play09:22

uh actually automate the posting itself

play09:25

going to go to uh make and I'm going to

play09:28

start by using Google Sheets and uh I'm

play09:32

going to search for row I say search row

play09:36

going to leave it at uh select from my

play09:38

drive and uh I'm going to use YouTube

play09:41

social media post my sheet name will be

play09:44

YouTube social post it has headers and

play09:48

now I want to filter we'll have two

play09:50

filters first I want the schedule date

play09:53

switch that to date time uh operators

play09:57

should be equal to the date that uh to

play10:01

today's date so I'm going to go here and

play10:04

use this uh format date function and in

play10:08

here I'm just going to add now so

play10:11

today's date and in here for the format

play10:14

I'm going to say ear ear ear Dash month

play10:18

month Dash day because this is the

play10:21

format that I'm saving everything in

play10:23

frontally if you come here you see that

play10:25

the date is uh the year the month the

play10:28

day back here we also going to add

play10:30

another rule so we'll need two rules to

play10:33

be uh true in order for a post to be

play10:37

considered ready to post so the first

play10:39

thing is that the date should be the

play10:42

same date and the other one is that I

play10:44

want the status to be here it is one

play10:48

because we left it at new but I want it

play10:50

to be two scheduled I need to go over

play10:53

and make sure it's scheduled so that uh

play10:56

make will gather it status equal to to

play11:00

sending going to limit it to like five

play11:03

posts or something like that although I

play11:05

never post more than once a day hit okay

play11:08

and uh this is our um initial place

play11:12

where everything uh would happen so next

play11:15

we can start posting essentially so I'm

play11:17

going to look for Facebook first and uh

play11:19

going to say Facebook pages create a

play11:22

post I'm going to say create a post with

play11:24

photos because I want to add this uh

play11:27

image I already have my connection set

play11:29

up you need to add one if you uh don't

play11:32

have it going to pick my page then for

play11:35

photos going to add one photo going to

play11:38

switch that to download photo from URL

play11:41

then my URL will be my image URL from my

play11:45

first note here I won't have any caption

play11:49

then my message will be my post content

play11:53

and then going to go on your line and

play11:55

say check it out here and I'm going to

play11:58

add the URL

play11:59

and that way I know that the URL is

play12:02

always at the end and people can click

play12:04

it if they want to but they'll be seeing

play12:07

this image instead of always seeing the

play12:10

same preview of the website also going

play12:12

to show advanced settings and for the

play12:15

date I'm going to schedule it for the

play12:18

same date that's coming from here but

play12:20

for a specific hour so for example

play12:23

because right now it's 900 p.m. so for

play12:26

testing let's say you want to schedule

play12:27

them for 10 p.m. I'm going to go to date

play12:30

and time here and I'm going to say at

play12:33

hours and then in at hours I'm going to

play12:36

pick the date so the schedule date and

play12:41

because there's no hours in this date

play12:44

the hour would be zero so I'm just going

play12:46

to add 22 hours so it's 10 p.m. and I'm

play12:50

going to hit okay next I'm going to add

play12:53

X and uh say create the post going to

play12:57

link my Twitter account and for my text

play13:00

content I'm going to add the post

play13:03

content and then going to say check it

play13:06

out and add the URL unfortunately it's

play13:10

kind of hard to add an image to a

play13:13

Twitter post I couldn't figure it out

play13:16

because there's no upload media option

play13:19

in uh make and that's what their API

play13:21

goes for so let me know in the comments

play13:24

if you know how to do it but uh for now

play13:26

just going to leave it like that without

play13:28

an imit

play13:29

on Twitter and uh hit okay and last but

play13:33

not least we need to post on LinkedIn

play13:35

and uh if you know from previous videos

play13:38

that I've done I don't really like the

play13:40

way LinkedIn works so instead of using

play13:43

its integration I'm actually using

play13:45

buffer and uh buffer is a social media

play13:48

posting platform but uh using it that

play13:51

way I don't have to schedule multiple

play13:53

posts there so I can always use their

play13:56

free version which only allows up to 10

play13:59

posts and uh by doing our own automation

play14:03

that's all we need from them so going to

play14:06

pick buffer going to say create a status

play14:09

update I already have my buffer

play14:11

connection going to pick my LinkedIn

play14:13

page and for my text it's going to be

play14:16

post content and then on a new line

play14:19

check it out here the URL you're going

play14:22

to see post an update at scheduled date

play14:25

and time that would make it easier for

play14:27

us to see uh to test things because

play14:30

we'll be able to schedule for a few

play14:32

hours later as we're doing right now and

play14:36

then we'll be able to test that and see

play14:39

if the post appears in buffer before it

play14:41

goes live on LinkedIn after you're done

play14:43

with your testing you can always switch

play14:46

that back to post immediately date

play14:48

scheduled will be again going to go here

play14:52

to the date and time going to say at

play14:54

hours in here going to pick my schedule

play14:57

date and in here here going to add 22

play15:00

for 10 p.m. and you need to do that when

play15:03

you're testing and building this this

play15:05

needs to be like 1 two 3 hours after the

play15:09

time you're testing just to make sure

play15:11

that everything works and then you can

play15:12

switch that to the time of day that you

play15:15

want to post so for me this will be 18

play15:17

because I always post around 6:00 p.m.

play15:20

going to show the advanced settings here

play15:23

I'm going to see here that I don't want

play15:24

to shorten the links and I also want to

play15:26

attach media no link no no title uh no

play15:30

description just a link to an image will

play15:33

be my image URL and uh the thumbnail

play15:37

will also be my image URL and those are

play15:39

my settings for buffer once we're done

play15:41

with all the posting what we can do is

play15:44

we can go to Google Sheets and pick the

play15:48

update row to make sure that we switch

play15:51

the uh status to post it because make

play15:55

sure that it's posted it's not scheduled

play15:57

anymore here I'm going to

play15:59

select by path from my drive and I'm

play16:02

going to use this to to find my

play16:05

worksheet then my sheet name will be

play16:08

social posts and uh my roll number will

play16:11

be the roll number from this note here

play16:14

roll number and the only thing that I

play16:18

want to change is my status I want it to

play16:20

become three for post hit okay and uh

play16:24

that's the main part of it but I also

play16:26

want to make sure that I get notified

play16:28

whether whether this worked or not so

play16:30

I'm going to add a flow control router

play16:33

and we'll have two paths one will be an

play16:36

email that you'll get if there's no

play16:38

error so if everything went fine and the

play16:41

other is an email we'll get if there

play16:43

were some errors and to also add error

play16:47

handling for those just to make sure

play16:49

that uh we can see here which one C the

play16:53

error so I'm going to right click at

play16:55

error Handler going say resume and my

play16:58

post ID and I'm going to say it zero

play17:01

okay then for X I'm going to add a

play17:04

Handler resume and post ID will be zero

play17:09

and uh for buffer I'm going to add an

play17:12

error Handler resume and I'm going to

play17:15

add the item and uh status ID will be

play17:19

zero okay really don't like how they

play17:22

Auto format those so now what we can do

play17:26

is uh we can add two email notes here

play17:29

and then check within the router add two

play17:33

filters so this will be no errors

play17:35

everything is fine and this will be if

play17:36

there's errors let's start with the no

play17:38

errors one so here I want to send an

play17:41

email I'm going to pick email I'm going

play17:44

to grab send an email I already have my

play17:48

uh email address here for Min analyst

play17:50

and uh I'm going to say add the

play17:53

recipient going to add my email here the

play17:56

one I want to get it at and I'm going to

play17:58

add it in a bit my subject will be minty

play18:02

tools promo post all good content type

play18:06

HTML is fine and content can be all good

play18:10

going to add my email here and uh hit

play18:14

okay now in terms of uh adding a filter

play18:17

here I'm going to say no errors and uh

play18:20

we'll have three conditions so the first

play18:22

thing we want is our Facebook post ID we

play18:26

want this to not equal to zero we also

play18:31

want an ENT rule we want our Twitter or

play18:34

X post ID to be not equal to zero and we

play18:40

want our uh statuses status ID to be not

play18:46

equal to zero so if all those three are

play18:49

not equal to zero so there is no error

play18:52

then we'll get an email saying okay fine

play18:55

all good no errors on the other hand

play18:57

we'll also get an email say sent an

play19:00

email a recipient my subject will be mty

play19:05

tools promo errors content type HTML and

play19:10

in terms of uh content I'm going to say

play19:12

there was an error posting on the

play19:17

following platforms I'm going to add two

play19:20

uh new line tags because this is in HTML

play19:25

and then I'm going to say go to uh this

play19:29

General functions Tab and say if and in

play19:32

this if I'm going to say if my Facebook

play19:37

post ID and then from General I'm going

play19:40

to say equals zero then I want to say

play19:45

Facebook and a new line otherwise I'll

play19:49

say nothing on the next line again I'm

play19:51

going to say if and in here I'm going to

play19:54

grab my post ID from X and after that

play19:59

I'm going to say equals zero I'm going

play20:02

to say x and then a new line otherwise

play20:07

nothing so the idea is that whichever

play20:09

one of those is zero will be listed here

play20:13

and that way I'll know which one through

play20:16

the error and here I again have if here

play20:20

we're going to see buffer statuses

play20:23

status ID equals zero give me link then

play20:29

I don't need the new line here otherwise

play20:31

give me nothing going to hit okay here

play20:34

and now let's set uh this filter going

play20:37

to right click set up a filter going to

play20:40

say errors and uh my conditions for that

play20:44

will be one of three things so one of

play20:47

those three has to be uh zero so either

play20:51

this is equal to zero I'm going to add

play20:54

an or rule or this equal to Z Z and

play20:59

another or rule which will be statuses

play21:02

stus ID is equal to zero so the whole

play21:05

idea here is that if just a single one

play21:07

of those equals zero then I have an

play21:10

error and I want this to go that way and

play21:13

this is not errors it's uh errors okay

play21:18

and another thing that I want to do so

play21:20

the last thing is here I want to make

play21:22

sure that I only continue if there are

play21:25

post to process on a right click set up

play21:28

a filter

play21:29

when I see anything to post and my

play21:32

condition will be that the the total

play21:34

number of bundles will be a numeric

play21:38

operator greater than zero so if it's

play21:41

zero if there are no posts for today

play21:44

this won't move forward okay that was a

play21:47

long one so now let's uh go ahead and uh

play21:51

test it going to save it and uh by the

play21:54

way because in my case will be running

play21:56

at 6:00 p.m. so

play21:59

I want to make sure that this is

play22:01

scheduled to run like a bit earlier than

play22:03

that and also keep in mind that uh

play22:06

Twitter does not have like a scheduling

play22:09

so for Facebook and for buffer you can

play22:13

provide a a future time so you can

play22:15

schedule at 5:00 p.m. and it will be

play22:17

posted at 6:00 p.m. but for Twitter you

play22:20

don't have that so what I do is I'll

play22:23

remove those uh dates from here and I

play22:26

make sure that I'm posting directly at

play22:29

the time that this runs if I now go back

play22:31

here and I edit this and make sure that

play22:35

it's uh scheduled and just save it now I

play22:39

should be able to run this once it found

play22:42

one thing to post it's now creating a

play22:45

post for uh 1000 p.m. in my case and uh

play22:49

Facebook let's see if that would work

play22:51

okay then it went to Twitter to buffer

play22:53

it updated everything and there were no

play22:56

errors so it went that way and I should

play23:00

receive an email if I go to uh my admin

play23:04

here and uh I refresh that I should have

play23:07

my status as posted and if I go to

play23:09

Twitter you see here that uh I have this

play23:12

post I'm remove it because I posted it

play23:15

already if I go to business. face.com

play23:18

content calendar I can see that I have

play23:21

this post scheduled for 1000 p.m. with

play23:23

the image and everything Gmail says

play23:26

published by make going to delete that

play23:29

because I already posted this and I

play23:32

wouldn't see anything on LinkedIn but on

play23:34

Buffer you can see here that uh I have

play23:37

this uh post scheduled with the image

play23:39

and everything for LinkedIn I going to

play23:42

delete this one so our scenario works it

play23:46

takes new posts if it's the same date

play23:49

and it goes through all those and post

play23:51

them for you I prefer to keep those

play23:53

separated but uh if you want you can

play23:55

even go in buffer and I was trying this

play23:58

out you can add the Facebook and the X1

play24:01

as well the reason I kept them

play24:04

separately was uh one thing for uh X is

play24:07

that you still have like a limit on how

play24:09

long your post can be so what I do here

play24:13

is I'm actually going to go to the uh

play24:16

text and binary functions and uh use the

play24:19

substring function so in here I'm going

play24:22

to move this post content and I'm going

play24:26

to trim it essentially remove this empty

play24:29

space I'm going to say from character

play24:30

Zero to character let's say 180 the

play24:35

whole concept here is that I have my URL

play24:37

I have this text here and uh I want to

play24:41

make sure that the post doesn't get too

play24:43

long for Twitter and usually I'm fine

play24:47

with it just being cut off at some point

play24:49

if you want to make it fancier you can

play24:51

add an if here that check the length and

play24:55

if it's above 180 it's trim it and then

play24:59

add three dots but uh I'm not going to

play25:02

do that so from now on you can just come

play25:05

in here you can set up all those or you

play25:08

can add new posts and be able to post

play25:11

them automated at specific times without

play25:14

you having to each time go in and post

play25:17

to all the platforms and that's another

play25:19

great example of uh the power of no code

play25:22

and especially when you're trying to

play25:24

build something that's tailored to your

play25:27

exact use case now a lot of people are

play25:29

trying to build products and customer

play25:32

facing businesses on top of no code but

play25:34

for me the no Cod Advantage has always

play25:37

been in scenarios like this that uh we

play25:40

just went through building internal

play25:42

tools that exactly match your need and

play25:45

cost much less than what's available out

play25:47

there I know platforms like uh feif and

play25:50

buffer those are my two favorite ones

play25:53

actually have a lot of features that we

play25:56

didn't build and we probably couldn't

play25:58

build built in this Tex stack but at the

play26:01

same time I personally never used those

play26:03

features so for me it made a lot of

play26:06

sense to just take the simple things

play26:10

that I use from those platforms and

play26:12

build them for myself saving from uh

play26:15

recurring monthly fees and uh also being

play26:19

able to fully Tor everything exactly as

play26:23

uh I want it next I want to share a few

play26:25

other ways that you can use make to

play26:28

automate routine daily tasks and

play26:30

literally add hours to your day and I'll

play26:33

be doing that in this video right here

play26:35

thanks for watching Kenta I'll see you

play26:37

in this video

play26:39

[Music]

Rate This

5.0 / 5 (0 votes)

Etiquetas Relacionadas
Social MediaAutomationGoogle SheetsMake.comContent SchedulingNo-Code ToolsPost AutomationBuffer AppMarketing StrategyExcel AddinMinty Tools
¿Necesitas un resumen en inglés?