HomeVideos

Automating Shopify Product Descriptions with n8n (AI + SEO Workflow)

Now Playing

Automating Shopify Product Descriptions with n8n (AI + SEO Workflow)

Transcript

174 segments

0:00

All right. So in this workflow, we will

0:02

start by fetching a product from our

0:05

Shopify store and then we will check

0:08

first if it needs context. And let me

0:12

just try and start the workflow here. So

0:14

basically we'll check if it needs

0:16

context. For example, if it does it have

0:17

data, does it have a description or you

0:19

know product attributes and if it does

0:22

not have it, we'll use OpenAI to do

0:25

product research of this product. So

0:28

it's actually able to search the web. So

0:31

it can search and uh in this case we'll

0:33

use it to search information about our

0:36

product and and this information it's

0:38

going to use in a later step for the

0:40

product description to write a product

0:43

description based on that context. So it

0:45

can take a while and in my test it can

0:48

also become a little bit expensive if if

0:50

it does multiple web searches. So

0:53

sometimes it does like five or six web

0:55

searches and if you use an expensive

0:57

model for example the newest GBT5 it can

1:01

become quite expensive and in some of my

1:02

tests it cost like almost 50 cents per

1:06

run and in this workflow we have several

1:09

calls to an LLM. So one full run can

1:13

potentially become very expensive

1:14

especially with the the search here.

1:17

Sometimes it will have errors. I've

1:19

experienced that sometimes it doesn't

1:21

really understand how to, you know, take

1:23

the the query into the the API calls,

1:27

but uh most of the time it it it does

1:30

work, but that's something I will need

1:31

to to fix. All right, now that it's done

1:33

with the web search, it's going to merge

1:35

some data and pass it over to OpenAI. So

1:38

again, we use actually OpenAI to check

1:40

the existing description if it conforms

1:43

with our requirements. And if it does

1:46

not, we're going to prompt the LLM to

1:49

write an a description. And so it's

1:51

going to write the description based on

1:53

our requirements that we put into the

1:54

prompt, but it's actually also going to

1:56

do an internal link to a relevant

1:58

product in this example. So I actually

2:01

hooked into a tool which allows it to

2:03

search for products on our store.

2:07

After it's done that, it's going to

2:08

prompt the LM again to test if the link

2:11

works that it got from the search

2:13

products. And if it does, it's going to

2:15

pass it to Google Sheets. So you can see

2:17

now we have a description that's ready

2:19

and we have a uh let me see we have yeah

2:22

so we have a link here

2:24

uh that you can see here

2:27

and then it's going to continue to write

2:29

a title tag. You see it actually also

2:31

written a title tag already. So for the

2:34

title tag it basically checks the title

2:37

tag if there's an existing title tag and

2:38

what length it is. It's going to set a

2:41

counter because we uh want to make sure

2:44

that it has a correct length for the

2:46

title tag. Then it's going to write the

2:48

title tag with the context from a

2:50

previous step. Increment and then check

2:53

the length. If the title tag is not

2:55

within the length that we specify, it's

2:58

actually going to increment this count

2:59

and then do it again until it gets the

3:01

correct length. So you can see here it

3:04

was correct and passed it over to Google

3:06

Sheets. And I see the meta description

3:08

is also ready.

3:10

So then it's going to go over here,

3:13

check if the product that we fetch in

3:15

the first step has a meta description

3:17

and if it's within the correct length.

3:20

Then it's going to set a counter, write

3:22

the meta description based on our prompt

3:24

and requirements, increment the counter

3:26

and then it checks the length of the

3:29

meta description. If the length is

3:31

correct, it's again pass it to Google

3:33

Sheets. If not, it's going back and

3:36

write the meta description again. And

3:39

then I've said I I put this counter here

3:42

uh where I increment the counter. So we

3:44

don't want to just have an infinite

3:46

loop. We want to stop it at one point.

3:47

So like if it if there's a case where it

3:49

cannot get the correct length like at

3:52

all, we have to stop it. Otherwise, it's

3:53

going to be very expensive. So in this

3:55

case, we just don't do anything. We just

3:58

skip it. Here we probably want to record

4:01

this somewhere in our system that hey

4:03

this one we had an issue with this.

4:05

Could not write the meta description. So

4:06

maybe we just do it mainly. But in my

4:09

test, and now I've done this quite a few

4:10

times, it seems like OpenAI has gotten

4:13

really good at writing text within a

4:17

certain length. So, and I've done many

4:19

tests and I have I have yet to

4:21

experience one time where it did not fit

4:24

fit within the length that I specified

4:27

in the prompt. All right. And so, for

4:29

the product description that we we

4:31

wrote, let me just copy it into uh

4:34

Shopify here. And then you can see how

4:36

it looks like. And we have so this is

4:38

based on the requirements that I've u

4:42

specified in in the prompt right and

4:44

then you can see here that we also have

4:45

a link to a different product than this

4:49

generator. So we have this generator and

4:52

you can see here that it will recommend

4:54

another generator. Uh so let me just try

4:58

and um see if this works. So we have uh

5:02

the link here and this I can pass over

5:04

to my website here. So you can see here

5:08

it actually found this product that it

5:10

recommends. So this is kind of an

5:12

efficient way of creating some kind of

5:14

an internal linking between products

5:16

that is relevant to each other uh where

5:19

it simply just hooks into our search

5:21

engine and then finds a similar product

5:24

based on the the product title in this

5:27

example. So yeah, that's how it works.

5:29

And for the next step, what I'm going to

5:32

add to this uh workflow is another node

5:36

which will generate product features. So

5:39

for example, in the example of a

5:41

generator, we can we can you know get

5:43

information about like the you know the

5:46

power of the generator, what kind of

5:48

fuel is it, electric, does it use gas,

5:51

diesel and stuff like that. Get all

5:53

these features of the product and we can

5:56

use that as filters on Shopify. making

5:59

it easier for people to search uh for

6:02

products in case we don't have this data

6:06

already and especially if you have a

6:07

very large store with thousands of

6:09

products. This can be a very big task to

6:13

achieve if you're going to do that

6:14

manually. But actually using AI and

6:16

using N8N, you can actually, you know,

6:20

uh do this much faster than you would

6:22

otherwise have done if you did it

6:25

manually. You could also go and add a

6:28

human step into it. So for example, an

6:30

idea that I'm tinkering with now is now

6:33

I've added all the data here to my

6:35

Google Sheets. I can do that for all the

6:38

products. We could also go and actually

6:39

have, you know, a manual check within

6:42

our Google sheet. For example, we add a

6:44

checkbox here. And then if we check it,

6:46

that means that it's approved. And then

6:47

we're going to have our workflow

6:49

actually populating Shopify with this

6:51

data. But that's the next step. So, this

6:54

is just an example of how you can create

6:56

a workflow using this system here and

6:59

automate a lot of the boring tasks that

7:02

you might have in your Shopify

Interactive Summary

Ask follow-up questions or revisit key timestamps.

This video demonstrates an automated workflow for Shopify stores using OpenAI to enhance product data. The workflow fetches products, determines if context (description, attributes) is needed, and if so, uses OpenAI for web research. It then generates product descriptions, title tags, and meta descriptions, iteratively ensuring they meet specified length requirements. A key feature is the automatic generation of internal links to relevant products within descriptions. The speaker also discusses the cost implications of using LLMs for web searches and outlines future enhancements, including generating product features for filters and integrating a human approval step. This system aims to automate boring and labor-intensive tasks for large Shopify stores.

Suggested questions

6 ready-made prompts