I Made A FREE Automatic ChatGPT SEO Content Generator

[@walpoleandworcester]

You’re dropping knowledge constantly on here and people are complaining? Wow. For me, I take whatever works best and run with it in my own way. I don’t do everything exactly how you do it but it’s in the same spirit! I play around myself and experiment too and have my own process down that’s been working wonders!

[@muzyshah]

This is like the enclycopedia of SEO 100 volumes squeezed into a playlist of 23 videos...... great work thanks.....Much appreciated...

[@visibilityacademy2685]

Hey man, dunno if anyone already said this in the comments, but see the link to your sheet? Change “edit” at the end to “copy”, and anyone who clicks the link will be prompted to make a copy to their G drive

[@numgun]

Pure magic, this is amazing! My only lament is that I lack products to actually market for. Still, for anyone that already has existing products to sell and market, this is incredibly useful!

[@mahy2362]

Hamish, thank you so much. You deserve tons of success.

[@darwinchan5573]

Thank you ! Hamish you did it again, such wonderful content for free!

[@artificial_director]

Great method! Thanks so much for this. Now, how could we somehow let this workflow make web searches (as doable w GPT4 web search) to research data from the web to implement into the post? That would be amazing and a total game changer. Ideas?

[@mohammedelidrissi-z5r]

I follow you from Morocco and I love your explanation. I wish you success . I want to ask you, have you ever posted how to get traffic on Etsy?

[@RoadtrippinwithTakacs]

Nicely done. A couple of months ago, you said many articles are getting lots of impressions but not many click. Are the clicks now catching up? It would be cool to have an update on some older articles from a couple of months ago.

[@andyfankhauser191]

Keep up the awesome info sir. You’re changing lives and I appreciate you ❤

[@marianblake]

Thanks for the video. I am very slowly getting my head around SEO.

[@marcusjones1110]

First off, great video! All your videos are gold. Would you say your other methods still work as well too? Like the ones in your other playlist about up-to-date ChatGPT SEO Keyword and Blog Writing? And the two videos about ranking in under 8 hours a few months ago?

[@bulltrap]

Keep doing what you are doing.. I always wait for new videos from your channel.

[@Brayden-Crossley]

this is amazing. Does anyone else get the error Exceeded maximum execution time (line 0) ?

[@OGEETOMO]

I get this non stop doesn't work for the first input for me but makes the table complete aids

[@DOcasio]

Subscribed. Thank you, for all you do!

[@SatisfaitouRembourse]

Hello , unfortunatly i have a Bad Request Error 400 when i try to install GPT for Sheets . Any solution ?

[@SatisfaitouRembourse]

for those with the same issue : I have found the solution. You either need to sign out of all other accounts or use incognito mode. This was not the case before, but now our Google overlords have decided to make it behave like this.

[@SecretsofancientEgypt]

great vid. as always. I have set my settings as you have in the google sheet extension, but I only see an error message in the column beside the keyword column..? So there is no prompt..? I copied your sheet, not using yours. But I can't get past this point? any suggestions? Hamish can you please give us a hand on this part?

[@billy.the.maker.]

same here

[@billy.the.maker.]

have you solved it?

[@SecretsofancientEgypt]

I have tried everything I know, and not know, and I still can't get it to work. I also tried to set it to higher tokens, higher than the vid here.. but nope it won't work... I hope Hamish will help us on this part. or I will have to leave it.. Anyone else here that knows why it might not work for some of us?@@billy.the.maker.

[@nichesite]

Have tried concatenating the articles generated in cell E. =B2&C2&D2

[@alexandertestel]

Why dont you include the introduction in the keytakeaway promp and the conclusion section in the further reading one? Wouldnt that increase the word count of the article?

[@Incomestreamsurfers]

The best thing about this content machine is you can change it as you like

[@That.Channel593]

I launched this but the articles still say "error" and haven't written anything. How do you initiate the writing?

[@Incomestreamsurfers]

Change something small in the prompt and press enter - or press rerun formulas on the sidebar

[@ericmarquez754]

Hello, I just wanna know if the API key only working for a paid account on open ai? I only have a free account. Thank you.

[@thipchart]

I keep getting "Exceeded maximum execution time (line 0)". Any idea what I did wrong?

[@hopguides]

Same here

[@billy.the.maker.]

@@hopguides same

[@billy.the.maker.]

have you solved it?

[@Incomestreamsurfers]

It means that the API call ran for more than 60 seconds - which is the maximum limit for OpenAI. Normally running it again works

[@thipchart]

In my case, the execution time always exceeds 30 seconds (I timed it!). I ran it many times already. Google Sheet will wait 30 seconds maximum when it executes a function. The error appears after passing 30 seconds. It's Google Sheet limitation.

[@sebleb]

Didn't work for me, I followed exactly all the steps in your video, I have openai credits, API key works, but I get "Error Exceeded maximum execution time (line 0)." in the cell under ARTICLE column, and the other cells don't work too. I didn't change the formulas. Meanwhile, Openai debited $0.09 from my credit.

[@billy.the.maker.]

same here

[@billy.the.maker.]

have you solved it?

[@eugamehost5467]

I wanted to test this out sadly I've the same error.

[@sebleb]

@@billy.the.maker. I haven't solved it. I just tried again, but no result. There must be a bug either in the formula or in the GPT for Sheets™ and Docs™ settings ? It could be related to API limit for new users : A rate limit is a restriction that an API imposes on the number of times a user or client can access the server within a specified period of time. Rate limits are automatically adjusted based on history of good use.

[@Incomestreamsurfers]

It means that the request to the API took longer than 60 seconds which is the maximum run time for the OpenAI API - make sure you’re using ChatGPT 3:5 and run it again

[@Digitalcataloghub]

Awesome I’ve been looking for how to create a worthy topical map

[@vincentchen2938]

Hi, I remember you use tool to fix the HTML output from chatgpt, what's it? I can not find it

[@Incomestreamsurfers]

Markdowntohtml

[@vincentchen2938]

Thank you!@@Incomestreamsurfers

[@ImranWaheed-ms5mj]

Thanks for this Valuable content

[@gatika865]

Im getting this error: Error: Invalid value parameter. Received: #ERROR!. (line 4818). everytime, even before I get to do anything. Anyone how why? Cool tool though! Love all your stuff!

[@BogdanPukish]

how is you tinyhouse site doing? how much do you earn on monthly basis

[@kennypowers6106]

Always appreciate the content good sir. I'm also having an issue with Errors. If anyone resolves the Error "Exceeded maximum execution time (line 0)." under the Article tab or the "Error: Invalid value parameter. Received: #ERROR!. (line 4818)." under Key TakeAway Table. Let me know. It would be very much appreciated. I have creativity set to 0.8 and tokens set to 8192. GPT 3.5

[@JawnInsight]

me as well.

[@gatika865]

Same!

[@garantax]

same for me

[@FlexFunds]

Same

[@FlexFunds]

Same

[@robertoz190]

Getting "Error" on every table, is not working..

[@Incomestreamsurfers]

Did you try for more than 5 seconds

[@robertoz190]

@@Incomestreamsurfers yes, it only generated one content "further reading table" , and nothing else fpr other kws

[@Incomestreamsurfers]

@@robertoz190 so keep trying.

[@exoticescape]

Thanks so so much 🙏❤

[@KarmicDebtCalculator]

this unfortunatly does not work. I got it the first time and it did what it was supposed to do but everytime after that, it would just do it's own thing and not write the article based on the keyword after i drag it down. i've been doing this for about 4 hours and have tried to troubleshoot 14 different things but unfortunatly, it just doesn't want to work. You can't reference the GPT model on the bottom or it gives you an error. Out of all the models, everything times out except for 3.5 turbo 1106. if you don't put the url in the bottom, it invents its own article, if you put the urls at the bottom it write a paragrah for every link based on it's keyword. like i said it worked fine the first time but every time after that, it just did it's own thing... damn i was really hoping this would work. I'm guessing it's because it's a fairly new product, so it's glitching madly.

[@giuntamarco]

Love the work. Sorry you left italia

[@clpylato9480]

In column C What is: value parameter error? (Line 4840)? In column B What is: exceeded maximum execution time (line 0).? I have created an account and purchased more credits and I am doing everything in the proper Gmail account. I appreciate any help you can give me or anyone else that knows how to resolve these errors. Thank you

[@coldcommunications10]

Is anyone else having this issue?

[@KarmicDebtCalculator]

@@coldcommunications10 yes delete the gpt model at the end

[@MohamedakrameddineBenratmia]

Thank you so much

[@SmallC]

Awesome

[@billy.the.maker.]

Why do I have error (exceeded maximum execution time)?

[@BlackStudies]

I was reading somewhere a while ago (I can't remember where) that absolute links are better than relative links for SEO. From what I recall, the only real advantage to relative links is it may make the page load faster. What are your thoughts?

[@Incomestreamsurfers]

Fzzz a

[@earnwithbots2783]

​@@Incomestreamsurfers is this a reply or a stroke? Lol

[@grantwylie4302]

im going to watch this plsy list a thousand times until I know this backwards and blind.

[@sam-bartlett]

You are fab ❤

[@SearchMyExpert]

thank you

[@illbelieveanything]

YES

[@POWPOWpowlll]

You’re overwhelming us with too many videos and methods and it’s already confusing which to use

[@Incomestreamsurfers]

Use whichever works for you

[@gardenflorida]

@@Incomestreamsurferskeep them coming

[@BlackStudies]

I was overwhelmed at first too. The more you watch, though, the more you get a sense of which methods work best. You can also get a good sense of how to tweak them to better meet your specific needs.

[@RoadtrippinwithTakacs]

This is gold. Hamish is leading discovery and innovation. Let the man share what he is learning so you can test some techniques out. That's what I'm doing.

[@Fedgery007]

Stop complaining! Figure it out my god! He’s giving you all this for free and you’re complaining???!!!!

[@Fedgery007]

Thank you!

[@iamme9949]

Are you ILLUMINATI 😮😮