Outsmart Google’s Search Algorithm with Content Automation.

Summary

この動画は、Googleの検索エンジンアルゴリズムの変化に影響されない、時間に耐える記事自動化ソリューションを紹介しています。データのSEO、op APIツール、Google Sheetsを使用して、トップランキングのウェブサイトからコンテンツを抽出し、チャットGPTを活用して新しいタイトルや要約を作成し、ウェブフローに投稿する方法を説明しています。このプロセスは、常に最高のランキングのウェブサイトを基に内容を作成するため、時間に耐えることができます。

Takeaways

• 🔍 研究と設計に1ヶ月を費やし、Googleの検索エンジンアルゴリズムの変化に影響されない自動化ソリューションを考案しました。
• 💰 Data for SEOでアカウントを作成すると、無料で1ドルが提供されます。これは長く使用できます。
• 🛠️ OP APIツールは、柔軟性により私のお気に入りの自動化ツールです。カスタム自動化を作成するための無料のシナリオが提供されています。
• 📊 Googleスプレッドシートを使用して、キーワードを入力すると、Data for SEOにプッシュされ、トップ5のウェブサイトを検索します。
• 🔗 ウェブサイトのコンテンツを収集し、HTMLボディにまとめ、H1、H2タグ、段落タグ、URLタグで分類します。
• 🤖 Chat GPTに適切なテキスト形式でコンテンツを提供し、新しいタイトルや要約を生成させます。
• 📝 ブログコンテンツはHTMLに変換され、スタイルが追加され、Webflowに投稿されます。
• 🌐 コンテンツ生成は、常に最高順位のウェブサイトに基づいて行われることで、タイムプルーフな方法となります。
• 🔑 データの取得元を指定可能で、地域コードや言語コードを設定することで、より正確な検索結果を得られます。
• 📈 より多くのウェブサイトをスクレイプすることで、コンテンツの品質は向上しますが、コストも増加します。
• 🎯 キーワード研究を行い、回答パブリックなどのツールを使用して、関連する質問やフレーズを見つけることが重要です。

Q & A

この自動化ソリューションの主な目的は何ですか？

この自動化ソリューションの主な目的是は、Googleの検索エンジンのアルゴリズムの変更に影響されずに、時間に耐え得了した記事の投稿を自動化することです。

Data for SEOというツールの何が特徴的ですか？

Data for SEOの特長は、無料で1ドルのクレジットが提供されることであり、このクレジットは非常に耐用性があり、長期間使用できます。

op APIツールの利点は何ですか？

op APIツールの利点は、柔軟性とカスタム自動化の創造性を与えることです。また、その機能から、このツールは非常に安価であり、他のプラットフォームと比較して非常に安く利用できます。

Google Sheetsを利用する理由は何ですか？

Google Sheetsは無料で利用できるため、費用をかけずに自動化プロセスを開始できることが大きな理由です。また、Google Sheetsを使用することで、データの整理や分析を簡単に行うことができます。

この自動化プロセスでどのような種類のコンテンツが生成されますか？

この自動化プロセスでは、タイトル、サマリー、本文、スラッグ、画像、代替テキストなど、ブログ記事に必要な全てのコンテンツが生成されます。

コンテンツ生成において、トップランキングのウェブサイトは何のために使用されますか？

トップランキングのウェブサイトは、コンテンツの参考として使用され、検索エンジン最適化されたコンテンツを生成するために使用されます。これにより、生成されたコンテンツは、現在のトップランキングのウェブサイトのスタイルに非常に類似しており、Googleの検索アルゴリズムに適応します。

コンテンツ生成プロセスを開始するために、どのようなキーワードを利用すべきですか？

コンテンツ生成プロセスを開始するために、検索ツール（例: answer the public）を使用して、検索するキーワードに関する質問やフレーズを見つけ、それを利用すべきです。また、キーワードの興味度やオーディエンスサイズを確認し、適切なキーワードを選択することが重要です。

データの取得元を特定する際、どのようなコードを使用しますか？

データの取得元を特定する際には、地域コードを使用します。例えば、data for SEOのAPIエクスプローラーのSCPセクションで、目的の地域に対応するコードを取得します。

この自動化プロセスを設定する際、何が最も重要な設定ですか？

最も重要な設定は、Googleシート内の認証情報を正しく設定することです。これには、Data for SEOのメールアドレスとAPIキーをハッシュ形式で保存し、make.comのtriggersに設定する作業が含まれます。

Webflowにコンテンツを投稿するために必要な手順は何ですか？

Webflowにコンテンツを投稿するためには、まずWebflowのサイト設定でApps and Integrationsからmake.comのアプリを選択し、自分のWebflowアカウントに接続する必要があります。その後、make.com内で自動化プロセスを設定し、Webflowへの投稿を可能にします。

この自動化ソリューションを実際に試すために、何を入力する必要がありますか？

実際に自動化ソリューションを試すためには、Googleシートにキーワードを入力する必要があります。その後、自動化プロセスが始まり、コンテンツが生成されてWebflowに投稿されます。

この自動化プロセスを管理するための注意点は何ですか？

自動化プロセスを管理する際には、費用を考慮し、データ取得元のウェブサイトの数を適切に設定することが重要です。また、プロセスの各ステップが正しく機能していることを確認し、必要に応じて調整する必要があります。

Outlines

00:00

自動化されたコンテンツ作成の紹介

この段落では、Googleの検索エンジンアルゴリズムの変化に影響されずに時間に耐え得了する自動化ソリューションを紹介しています。このソリューションは、データfor SEO、op APIツール、Google Sheetsを使用して、キーワードを入力し、トップランキングのウェブサイトからコンテンツを抽出、集約し、チャットGPTを使用して新しいタイトルや要約を生成する方法を説明しています。

05:01

タイムプルーフな方法の説明

この段落では、この自動化方法がどのようにタイムプルーフであるかを説明しています。トップランキングのウェブサイトが変化しても、常にトップ5のウェブサイトからコンテンツを抽出することで、コンテンツの質と関連性を保証するためです。また、チャットGPTにトップウェブサイトの構造を教えて、スタイルに合わせたコンテンツを生成することで、Googleの検索アルゴリズムに適応させることができます。

10:01

デモと実践的なアドバイス

この段落では、実際のデモを行い、キーワードを入力してコンテンツが自動的に生成される様子を示しています。また、コンテンツの質を向上させるために、answer the publicのようなツールを使用して、人々が尋ねる質問を特定し、それをキーワードとして使用するアドバイスも提供しています。

15:01

設定方法の説明

この段落では、データfor SEOのアカウントを作成し、APIダッシュボードから必要な情報を取得する方法を説明しています。また、Google Sheetsに情報を入力し、make.comを使用して自動化プロセスを設定する方法についても詳細に説明しています。

20:03

make.comの自動化プロセスの説明

この段落では、make.com上で実行される自動化プロセスについて詳しく説明しています。ウェブフックを使用してGoogle Sheetsから情報を受信し、データfor SEOからウェブサイトのコンテンツを取得し、チャットGPTを介してブロックコンテンツ、タイトル、要約、代替テキストを作成し、最終的にWebflowに投稿するプロセスを解説しています。

25:05

ビデオの締めくくりとフィードバックの提供

最後の段落では、ビデオの内容を締めくくり、視聴者のフィードバックを求めています。また、データfor SEOの設定方法、make.comの自動化プロセス、Google Sheetsの設定方法などを説明し、視聴者が自分のウェブサイトで同じプロセスを実践できるようにしています。

30:26

音楽の終了

ビデオの最後に音楽が流れ、視聴者が次のビデオを期待するように促しています。

Keywords

💡SEO

SEO（Search Engine Optimization）は、ウェブサイトが検索エンジンの検索結果でより前面に表示されることを目的とした一連の最適化手法です。この動画では、データforSEOというツールを使って、検索エンジンから最高位にランクするウェブサイトを特定し、その内容を参考にして記事を作成する方法が説明されています。

💡API

API（Application Programming Interface）は、ソフトウェアアプリケーション間の通信を可能にするためのインターフェースです。この動画では、APIを利用してGoogleの検索エンジンにアクセスし、上位のウェブサイトからデータを取得する方法が紹介されています。

💡Google Sheets

Google Sheetsは、Googleが提供するオンラインのエクセルシートアプリケーションで、データを入力、整理、分析することができます。この動画では、Google Sheetsを使用してキーワードを入力し、自動化プロセスを開始する方法が説明されています。

💡Content Aggregation

コンテンツの集約とは、複数のウェブサイトや記事からの情報を一つにまとめ、一つの大きなHTML本文を作成することを指します。この動画では、上位のウェブサイトから抽出されたコンテンツを集約し、それをチャットGPTに入力して新しい記事を作成する方法が紹介されています。

💡Chat GPT

Chat GPTは、OpenAIが開発した自然言語処理技術を用いたチャットボットです。この動画では、集約されたウェブコンテンツをチャットGPTに入力し、タイトルや要約、画像の代替テキストなどの新しいコンテンツを生成する自動化プロセスを説明しています。

💡Webflow

Webflowは、ウェブサイトをデザイン・開発するためのオンラインプラットフォームです。この動画では、自動化プロセスで生成されたHTMLコンテンツをWebflowにプッシュし、ウェブサイトに直接記事を投稿する方法が紹介されています。

💡Time-proof method

タイムプルーフな方法とは、時間が経ても効果を失わない解決策を指します。この動画では、常に最新の検索エンジンのアルゴリズムに適応し、上位のウェブサイトから情報を取得してコンテンツを生成する手法が紹介されており、それがタイムプルーフな方法であることが説明されています。

💡Open AI

Open AIは、人工知能の研究と開発を目的とした非営利組織です。この動画では、Open AIの技術を用いた自動化プロセスによって、効果的なウェブコンテンツを作成する方法が説明されています。

💡Automation

自動化は、手動での操作を必要とせずにプロセスを実行することを意味します。この動画では、キーワードを入力し、自動的にウェブコンテンツを生成するプロセスを設定する方法が紹介されています。

💡Niche

ニッチとは、特定の市場のセグメントを指します。この動画では、ブログコンテンツが特定のニッチに関連していることが重要であることが強調されています。これにより、検索エンジン最適化のために、特定のウェブサイトとのリンクを構築することができます。

Highlights

The speaker has developed an automation solution for posting articles that is time-proof and not affected by changes in Google search engine algorithms.

The solution uses an automation tool called data for SEO, which provides $1 for free upon creating an account.

The speaker emphasizes the importance of using the top five ranking websites for a keyword as these are the most valuable sources of information.

The automation process involves extracting content from the top-ranking websites and aggregating them into one big HTML body.

The aggregated content is then segmented and classified by its H1, H2 tags, paragraph tags, and URL tags.

The speaker mentions the use of the op API tool, which allows for the creation of custom automations and is cost-effective.

Google Sheets is used in the automation process, and the speaker notes its free availability.

The speaker's automation method ensures that the content generated is relevant and appreciated by Google's search algorithm.

The speaker provides a live demonstration of the automation process, showing how it can generate a blog post with a proper title, summary, and even an image.

The speaker explains that the time-proof aspect of the method comes from always basing the content on the highest-ranking websites at the time of generation.

The speaker advises on conducting keyword research using tools like 'answer the public' to find questions people are asking about a topic.

The speaker discusses the importance of targeting a specific niche and building links from higher-ranking websites within that niche.

The speaker provides a step-by-step guide on setting up the automation, including creating accounts and linking them with Google Sheets and make.com.

The speaker mentions the use of a basic4 encoder to encrypt authentication details for the data for SEO API.

The speaker explains how to set up triggers and scripts in make.com to handle the data received from the Google Sheet and generate content.

The speaker concludes by encouraging viewers to provide feedback and suggests that the demonstrated automation can be adapted for different platforms like WordPress.

Transcripts

I might have broken the way people

create articles using chat GPT forever

hear me out I have spent the last month

researching designing and creating an

automation solution for posting that is

fully time proof because it is not

affected by changes in Google search

engines algorithms over time simply

because of the way it

works and today in this video I will be

showing you for

free how this automation works so give

me a like and a follow to support this

channel so that I can keep posting

things like this no more fuzz let's go

out through the tools that you will need

as well as understanding what's

happening under the hood because this is

where the potential is let's go so these

are the tools that I will use in this

video the bottom three are the same

tools that I've used in a previous video

on blog post in automation so I'll leave

a link in one of the top

corners and and I just want to point out

that this video is a continuation to

that previous video I'm just building a

functionality on top of the previous uh

tool that I had and I'll explain now

what it does so the first tool is data

for SEO when you create your account

they give you $1 for free it sounds

little because you see and it's a dollar

but trust me that it's going to last you

a while for you to have as reference I

have used it for the past two months for

testing I've done some pretty heavy

testing on this tool and I still have

that dollar I don't even think that I

have used a half of it okay then we have

the op API

tool which then again I told you about

it in the previous video and I explained

you how to set it up so I'll put the

link again if you want to go to that

video so make is my favorite automation

tool out of the bunch because of the

flexibility that it gives you to create

custom

automations and I use it my myself in my

agency just for you to to see how how

good it is so they give you some

scenarios that you can set up for

yourself for free and then it's a

monthly payment but to be fair regarding

the other platforms that are out there

make.com is very cheap for what it's

able to do so yeah I dropped a link in

the description uh use it to sign in uh

and yeah uh give it a shot cuz I think I

think it's it's worth it and and lastly

we have Google Sheets which you guys

know it's free so something quickly that

I want to point out is that whenever I

make these tools I always try to find

the cheapest way to do them without

having to resort to code so you see a

lot of people making YouTube videos out

there that go on and they already use

platforms like a table and similar

things that cost you already $20 a month

$30 a month and and then on top they

make you use make.com or

zapier right whenever I make these

videos I do think of the cheapest ways

to do it because I understand that many

of you that are getting started in the

AI automation space are afraid of just

jumping into expensive tools cuz it

could be expensive for many of you so

just for you to know that I think about

you guys when I do these tools because I

am aware of the price of these things as

well and I don't want to overwhelm you

that's my main objective to try to not

overwhelm you with uh the costs that

these automations have okay so so yeah

all right so now I will show you how

this works so we're going to do

everything from a Google sheet all you

have to do is type in a keyword in that

Google sheet we're going to get that

keyword that keyword is going to be

pushed to data for SEO via an API then

data for SEO is going to give us access

to Google's search engine from which

we're going to search the highest

ranking websites for that keyword okay

in this case it's five so we're going to

search for the five highest ranking

websites for that keyword we are going

to extract all the content from it so

this is the structure how everything is

actually placed the images the actual

text and so on so on and using the

content from these individual websites

now what we're going to do is we're

going to aggregate everything together

into one big HTML body okay once we have

this big HTML body we're going to

segment it and classify it by it's H1

tag H2 tags paragraph tags URL tags okay

so this is the content from all five

websites just aggregated together and

for it to be able to be understood by CH

GPT and for it to generate proper

responses we have to convert it to text

okay so that's going to be pushed to a

couple of chbt modules that are going to

generate new new titles new new

summaries and so on and so on and the

blog content is the only thing that is

going to be converted to HTML again

because we want to give it some styling

so that's converted to HTML and the rest

such as the slug the title and all that

we can leave it as text and both of

these will will be pushed to webflow

you might still be asking yourself well

why is this a Time proof method well let

me explain you

so this section

here is what makes it time proof let me

explain you why so let's say you have

the top five ranking websites for a

keyword okay let's say over time uh a

couple of them fall out of the top five

ranking

because they're not performing well as

they're not abiding properly to the new

changes in Google search algorithm so

they don't perform as well okay that

doesn't matter for us because if some of

these websites drop in ranking some

other websites are going to go back in

that top five ranking and we don't care

because we are always going to pick the

top five every time we type in a keyword

we're going to pick the top five at that

time this is a very important concept to

understand we're always going to be

basing our content from the highest

ranking

websites right this is where the gold is

at since we are all having access to AI

it doesn't matter anymore that you're

able to generate content using chbt

because chbt by itself doesn't do much

you got to give it context right you

have to give it a point of reference to

generate content if you're just allowing

it to generate content by itself you're

going to gain much value for it because

it's going to tap into this vast general

knowledge that it has right but if you

give it as reference the way the top

five the top five websites are

structured right what are they putting

for the H1 tags what are they putting

for the H2 tags how's their paragraphs

looking like how are they styling or

structuring the way they say things in

their blog posts right all of this can

be bundled up given to chat gbts pre

context or as reference and then you're

going to get really nice content really

relevant content right content that at

the time of the

making is going to be really appreciated

by Google search algorithm because the

content that you make is exactly or very

similar to the style of the content that

has been posted has been made already by

the highest ranking websites at the

moment of the generation right so have

this in mind because this this explains

why this is a Time proof

method so yeah hopefully that made sense

if not drop a comment down below and

I'll be happy to answer any of your

questions doubts ideas okay now I think

it's wise that I show you a demo of how

this works once it is all set up which

I'll explain you how to do all you have

to do is type in the keyword

or set of keywords or key phrase that

you want to create a blog post for okay

you go here and you just start typing so

let's

do sofa

bed

um relax okay

whatever it could be structured as you

see here best tips for building SAS okay

it doesn't matter but I'm just going to

show you that doing it like this works

as well okay so you can see here it's

scraping right now scraping websites

given the couple of keywords that I gave

it it finished

scraping so look at how simple it is to

visualize as well what's happening

behind the scenes as well right I made

it so that you have a little indicator

here what's

happening now it's generating the

content so it's going through those uh

open ey API steps right okay so it's

generating the

content it's posting

now and it's posted look at

it there you

go so you see here that it put sofa bed

relax but it made a proper title all of

it right why sofa beds are actually the

perfect solution for ultimate

relaxation um in even made an image

let's have a look you can access this

online VI URL right really

cool and it made the alternate text

right this helps for

SEO uh made a

summary has the content in

markdown you want to see

it right really cool stuff it also even

has the content in HTML in case you want

to use it

and put it somewhere else HTML and then

this L okay really cool stuff and now I

will show you how it looks on the

website so this is how it looks right

now and look at it it has the image the

title the summary right looks really

nicely so it has the titles right the

H2S the H1 it has different styling you

see how it's in italic

right that's thanks to the HTML

formatting right really cool so I think

it's really cool and in some which is

something I think that it's really

valuable is that it puts in

some links as well so this is great for

building links right it helps with SEO

as well so since these links are from

higher ranking websites it helps with

your own ranking cuz your link in You're

Building links that are from high

ranking websites obviously you have to

think about the niche you can't just

post about sport cars and then sport uh

and then post about AI your blog content

has to be specific to a niche so that

you can keep building links to websites

from that specific Niche right but yeah

it's it it even posts the URLs from the

websites that is script right so

very very valuable stuff all right so

now that you've seen how it looks let's

go back and let me explain you how you

should do it properly so you've seen

that I typed the keywords without

thinking much about it the thing that

you should do is you go to a tool like

answer the public right and what this

tool

does is that it searches based on a

keyword or a few keywords that you

search in here what are people asking

about regarding so in this case I typed

open Ai and you can see here that

there's many

questions right I will click on this one

and I'll copy this okay and then what

you do is you get any of those questions

or or phrases that people are asking

about and you type it in there okay

since it's what people are asking you

should check as well uh how much much

interest it is actually having so there

was a metric there that tells you about

the audience size right so you check all

these things you do a little keyword

research before actually coming to this

tool okay but once you have that you

type in the keyword and you sit down and

relax and wait for it to do high quality

content right

so one thing that I want to mention is

that you have this tab below

here this is is for when you send that

keyword to the first service which is

data for SEO first of all you need to

put in your authentification details so

you know your account and your password

it's encrypted as a hash which I'll

explain you how to do later it's very

simple you just have to follow some

simple steps but the great thing about

this API is that you can choose where

you're searching from right because if

I'm searching about open in Spain the

the top ranking websites are not going

to be the same as as if I search for

open AI in United Kingdom or in the

United States right the results are

going to be different because the

demographic is different so with a

location code the language code you can

specify the place you'll be searching

and the language of course but the cool

thing is that you can even Target a

specific device you can Target a

specific operated system as well as

indicating data for SEO about the number

of websites that you want to scrape okay

so it's always going to be the top

ranking websites in this case it's the

top five ranking websites but you can

put 10 you can put 15 whatever you want

okay so just for you to note that the

more websites that you put in the higher

the quality of your content since it's

being based off more content but that

also means that your costs are going to

go up okay I I think from experience

that five is enough between 5 and 10 is

good enough for you okay especially if

you're are starting out especially if

you're starting out with your website

and you're starting to generate content

5 to 10 is is a good number to start

with and then you can bump it up if you

want so there you go you can ignore this

this T that was just for testing but but

yeah that's that's all you have to do

okay so now that I shown you the demo

I'm going to explain you very quickly on

how to settle the accounts up and how to

link this with your own website with

your own data and I'm going to show you

how to link everything up for yourself

okay so what I've come to realize is

that all of the few tools that I've seen

out there that ultimate blog

posting solely rely on chat gbt to

generate the content for you that's it

without any context and nevertheless if

it were to have context it's probably

static right in the sense that you Chuck

in some information about websites into

a knowledge base and that's it that's

the information that chbt has to

generate

stuff so you either have that which is

the best possible

outcome or if it involves a process like

the one

here you have to do so many different

things in order to generate the blog

content so I seen this

tutorial that it's not even free to use

you have to get in a community and give

in your your your email just to be able

to see the video right it's not even

publicly on YouTube so I've seen this

one and it works it works like the

quality of the output is great but it's

not userfriendly at all first of all the

setup requires such an insane amount of

work like insane amount of work I'm

telling you like days and days of work

just to set up the Automation and then

in order to use it in a table it takes

you it takes you a decent amount of time

right so if I have to be honest it is

not really automated because there's a

lot of friction in it you have to click

a lot of things you have to

you know you have to mess around with a

lot of things before you actually get

the content and that's the reason to why

I've took the effort so that it becomes

easy for you so that the only thing that

you have to do is type in a keyword

after you done do your research of

course but after that you just have to

type in your keyword okay so now I will

show you how to set this up right we'll

first um create the accounts right

because there's some useful information

that you will need there in order to

make some authentification calls okay

this sounds a bit uh complicated but

trust me it's it's very easy so let

let's get to

it all right so we are in data for SEO

and once you create your account and you

log in you're going to get $1 in your

balance which trust me it's good enough

it's going to last you a decent amount

of time and then you're going to go to

your API dashboard right here and once

you click on that you're going to see

two useful things that you're going to

grab first of all you email or the user

and then just below you're going to get

your API key okay and with those two

things you are going to paste them onto

uh no taking up of your choice in this

case I'm using Google Docs and you're

going to put it in the following format

the email then a colon and then your API

key okay anyways I'll I'll drop this uh

in the description so that you can copy

paste it and you can do it straight away

but it's it's really simple okay now

once you have that there there you are

going

to copy that all right and now we are

going to this website which I'll drop a

link in the description it's a basic4

encoder okay you don't need to worry to

why we're using it but yeah what you're

going to do is paste it there right

leave the settings as they are and

you're going to click en code and this

is called a hash okay

so you're going to get that hash and

you're going to go back

to your not taking app and you're going

to leave that there okay just paste it

below this is what we're going to

use to get us access to the data for SEO

API okay so you're basically knocking on

the door of data for SEO and you're

saying

hey this is is my encoded email and

password please let me in and use your

API Services okay once you have this

hash you're going to go back to the

tracker and you're going to place your

hash there right under this tab and now

we're going to set this up okay so it's

really important that you set this up

correctly based on your current location

okay it's good practice to do it from

your current location unless you have a

very specific audience that you want

your website to rank for if you have

that then then okay but typically you do

your current location okay so how do we

get the location code we're going to go

to data fa SEO under the API Explorer

section we're going to go to

SCP okay and all these can be set up um

back in the tracker but what you want is

to set your location you get a code

example and you're going to see here a

post request okay it doesn't really

matter but

what you want here is to get this

location code okay that's the important

thing so once you have that you are

going to go back and paste it there okay

okay so now with the language

code English and Spanish is fairly

straightforward Spanish is es okay but

if you want some other language then you

go back to data phrase

o and you choose uh let's say Chinese

for example and then you're always going

to click code example okay and you're

able

to see the code that they use okay so

yeah that's for language code device I

encourage you to keep it as it is

desktop and same for operating system

just because there's much more people on

Windows than on Mac always okay and the

depth this is where you can have have a

bit more of uh variability so if you're

starting I would suggest the value

between 5 and 10 is good enough and then

if you want to get a bit more traction

once you have a solid audience then you

can push it for 15 around 15 okay

between 10 and 15 is fine you can go

further if you want but I have to advise

you I have to remind you that the more

websites you scrape the higher the cost

it's going to

have okay not only for the data for SEO

API but also with the chat gbt

operations that are going to happen in

make.com okay it's just how the

automation works okay so okay once you

have that the Google sheet actually

saves everything as it goes so that's

fine and now I will show you what's

going on behind the scenes with regards

to make.com okay so let's go there all

right so this is where the magic happens

so what you have here it all starts with

a web hook and this web Hook is an

object that is being pushed by the

Google sheet right how is this happening

well as soon as you type in the keyword

that keyword alongside other things are

going to be pushed to

make.com Via this address okay so you're

going to type your web hook URL you're

going to find this right here if you

click here right you add your own one

and then you copy the address to the

clipboard and then you

will put it in between the quotations

okay that's the only thing that you have

to edit from here and then something

else that you have to put in is you're

going to go to

triggers okay

and you will add a

trigger okay you need to choose the

function okay so if you only

have the one that is called onedit

1B head from

spreadsheet on edit you you can leave

this as it

is click save you can leave this as it

is click

save and there you go so you should only

have one okay the reason I have two is

cuz I made one right now for

demonstration so I will delete that

should look something like this and once

you have set up the URL right as I

explained before on code V1 GS and as

well you have set up the trigger then

you're good to go so let's go back to

make and let's keep explaining you

what's going on so once you have that

make sure to uh test it you can reder

determine data structure

and try typing something here right so

let's do that now whatever going to go

back and you you should see that it's

been successfully determined

right okay so that means it it received

the web hook successfully and now we can

move on to the rest okay so it makes not

request right to data for SEO as I

explained before we we get some URLs

format them with chat GPT and what was

going to happen here is that based on

the URLs that we have scraped we are

going to enter those URLs and basically

get all the content inside those

websites right and this is called an

iterator because it's going to iterate

on this process as many times it needs

so

if there is six websites to scrape this

process is going to run six times in a

loop until it gets to the aggregator so

once these six Loops happen you're going

to have information on those six

websites but they're going to be in

separate objects okay so what we want is

we want to get all of those together

aggregate them and join them in a simple

tool okay and

once all that information is together

now we can pass it through the chat gbd

steps it's going to create us the block

content the title this log the summary

the alternate text okay and what it's

going to do with the blog post content

specifically it's going to switch it to

HTML so that it has some styling and

then we post it on web flow okay

so depending if it's web flow WordPress

you can um eliminate these modules and

put WordPress on it and you surely can

figure out by yourself uh once you start

playing with it how to input the the

fields on WordPress I'm pretty sure but

yeah um I put webflow in this case

because I seen no tutorial that does it

the way I'm doing it with web flow well

I haven't seen with WordPress but I also

use web flow in my agency as well so so

yeah if you want to see a tutorial like

this with WordPress on it let me know

but yeah so if you have a web flow site

what you need to do is that you should

go to your site settings okay and you're

going to go to apps and

Integrations right and you're going to

find an app which in this case is going

to be make okay so in the case that you

don't find it here for some reason you

can still

um add a new connection and you might

get a window popped up where you need to

sign in to your um make account I mean I

mean to your webflow account and yeah

you can do their verification and give

access to the websites through there

okay but yeah all of this you don't have

to change if you're using webflow so

yeah that's that's pretty much uh what

it does okay it it's a pretty

decent but trust me I've seen longer but

longer doesn't mean better hell because

I've seen very long automations that do

really really complex things but if you

can shorten that automation as much as

possible it's it's cool to include 100

steps and all that but the hard thing is

to try to have the same quality of

Automation and make it as less steps as

possible so that you save on

costs and and and yeah you save on costs

and you save on time as well right

because every step takes some time even

though it's a second or half a second or

whatever the more steps you put the more

time it's going to

take

so I've shown you how to set this up so

I've gone through how to set up the data

for SEO I have also shown you through

the make automation as well as showing

you how to set up the triggers and how

to set up the script behind the Google

sheet as well as setting the Google

sheet itself so thanks for watching the

video I really appreciate that you

watched it if you didn't like the video

drop a comment and let me know why so

that I can uh make changes to further

videos and if you liked it definitely

give it a like subscribe and yeah any

other things let me know as well in the

comments so thank you and and see you

[Music]

soon

[Music]