---
title: 'ChatGPT & Make.com Automation: Write Hundreds of Blog Posts in an Hour'
source: 'https://youtube.com/watch?v=i8iR4Y4Wct4'
video_id: 'i8iR4Y4Wct4'
date: 2026-07-31
duration_sec: 492
---

# ChatGPT & Make.com Automation: Write Hundreds of Blog Posts in an Hour

> Source: [ChatGPT & Make.com Automation: Write Hundreds of Blog Posts in an Hour](https://youtube.com/watch?v=i8iR4Y4Wct4)

## Summary

This video showcases a no-code automation pipeline that uses make.com, Google Sheets, the OpenAI API, and WordPress to generate and publish blog posts automatically. The creator demonstrates a live run that produces dozens of fully formatted articles with almost no manual intervention.

### Key Points

- **Introduction to the Automation** [00:02] — The video presents an automation that connects ChatGPT (via the OpenAI API) with WordPress using make.com, avoiding a long written tutorial in favor of a live demo.
- **The Core Stack** [00:14] — The tools are a free make.com account, a Google Sheets document containing topics, the OpenAI API, and WordPress. The free account includes about a thousand operations, which is sufficient.
- **Google Sheet Content Plan** [01:08] — The spreadsheet contains keyword ideas, titles, URL-friendly slugs, excerpts up to 500 characters, and manually added categories and featured image IDs for each post.
- **OpenAI Config and Prompt** [01:53] — The automation uses OpenAI's Chat Completion endpoint with GPT-3.5-turbo. The prompt asks the model to write an article about the title, not to output the H1 (imported from the sheet), and to use HTML formatting.
- **WordPress Plugin Mapping** [02:22] — A make.com WordPress plugin creates the post using the title, OpenAI-generated content, excerpt, slug, category, and featured image ID from the sheet.
- **Finding the Featured Image ID** [02:48] — In WordPress Media, hovering over an image reveals a URL containing 'post=86', meaning the media ID is 86, which is entered into the spreadsheet.
- **Batch Execution Settings** [03:14] — The creator sets the Google Sheets execution limit to 40 and chooses 'published' instead of 'draft' so the posts go live immediately.
- **Timeout Issue** [05:26] — A single make.com run is forced to time out after 10 minutes. Running all 40 articles in one execution eventually caused an OpenAI timeout, even though the automation worked well.
- **Results: 21 Posts in 10 Minutes** [05:57] — Before the run there were 3 published posts; after about 10 minutes there were 21. The sitemap showed the automation generated roughly 2 articles per minute.
- **Scaling and Scheduling** [07:38] — Posts can be scheduled for future dates rather than published immediately. Adding internal linking from the spreadsheet is also a recommended next iteration for SEO.

### Conclusion

This automation proves that a no-code pipeline can generate dozens of publish-ready blog posts quickly, but you need to respect platform limits like the 10-minute timeout and use scheduling to avoid overwhelming your site and Google.

## Transcript

found this really cool automation to uh to work with jet GPT and your WordPress so instead of making an endless document about how to do it I might as well just
create this video um what I did is I'm using make.com I have a free account which has I think a thousand animations which you don't need
necessarily and what I did is I made I made a Google and what I did is I made I made a Google Drive sheets with topics in it I'll show you in a little bit then it's sending that information to open AI with the API
so not the chat GPT version but the actual open AI actual open AI API and then it uses the information of both the Excel sheet and the open AI generated text from jet GPT to create a
WordPress article and one of the reasons why I'm doing this live is because I think we're going to see how many articles this thing is able to create within a certain amount of time time recording is seven past three
so this is the Excel sheet that I created I that open I do this as well not using gpt4 because I didn't have access yet so I basically asked for a access yet so I basically asked for a list of keyword ideas for Litecoin
um then I asked it to make titles create slugs which are basically you URL friendly titles or keywords and then a small excerpt which is up to 500 characters and I manually inserted the
category and the featured image of my WordPress website which I'll get back to in a second then it feeds this automation basically the Excel sheet and I send it to open AI which I set to
and I send it to open AI which I set to use the chat completion using GPT 3.5 turbo and the only prompt I gave is write an article about the title and the title is the one from the Excel sheet don't output the H1 title because I'll
import that from the Excel sheet itself but do use HTML for the market formatting the reason why I use this is because the output of openai is just one flat like basically one piece of information
so it's not possible for WordPress to extract the separate title from it so I rather use the Excel sheet and then we go to Wordpress itself which and then we go to Wordpress itself which needs a plugin from make.com as well
where I use the title as title the content is from open AI then I also have the excerpt and the slug in this as well I manually set the
category because it's one category only this time and I have the featured image ID which if you go to your WordPress setup and you go to media and you just hover over the image then on
the bottom left you'll see the URL and it says post is 86 so the media ID is 86 which I put over here um
actually already wrote a couple of Articles so I already did the technical analysis in the Bitcoin one so we have 17 till 56 left which is 40 articles so I'm going to set the Google Sheets
so I'm going to set the Google Sheets limits of executions to 40. limits of executions to 40. and to make this more fun I'll put the output um published instead of draft
just to see the first one so at the time of writing I have these two posts up light conference Bitcoin and Litecoin technical analysis and it should now do Litecoin price analysis going back to make press run once you
can also do this automatically every 15 minutes just keep adding new title ideas and just scrapes the the Google Drive document it already got the information from the Excel sheet and now it's
sending it to open AI where you can see the loading bar it also gives you like live updates on the bottom right
I think this takes like a couple of seconds not that long actually if we refresh this now Litecoin price analysis
it's in the right category it has the featured image which is set for to be the same for each of the Litecoin articles written by me articles written by me April 29 it got the HTML formatting H2S
and h3s and that's it basically and it got the excerpt this is the excerpt for the article so it's now working on the second article and it will keep doing so that's number
two and it will do so until it's finished with all 40 articles which I think should take about 30 minutes um it's now 11.3 so update you in a bit so it's now about 10 minutes later and I
ran into a tiny problem which was basically that the automation was forced to time out after 10 minutes one single run so instead of using a lower number
run so instead of using a lower number lower limit and every couple minutes I did all of them in one run which eventually led to a timeout from open eye even though it was working perfectly if we're looking at the amount
of articles that are published now I had three published before this and we can now see that I have 21 published and if you look at the site map
we can see that it basically did about two articles per minute which is insane and all of them look like this so with the featured image and with the correct category with the excerpt with
correct category with the excerpt with the HTML and one thing that I had forgot to include in this specific run is that it can also use internal linking which would be a great addition to this um which you can probably do based on
text which I didn't include this time lot of text and Google has a bit of an issue with indexing those Stacks so at the time of creating this Excel sheet it didn't make sense to me to include
text but you might be able to use them to do interlinking faster so that might be a nice iteration it's really easy to set up as well you just go to Wordpress you select text and then if you have them in the Excel sheet you
can easily just insert the text based on the mapping which you do here I'm going to include whatever you want so that's it for now um I'll do the other ones later this was just a demo case the website is blank
other than these articles now um I hope you learned something I think this is really really powerful if you use it wisely don't spend your website with articles but you could potentially also plan them in using the um
time scheduler so instead of doing them as published you can also set them as scheduled which means that like in the future that you can publish them on a certain date
your Excel sheet so that like every other day you publish an article or like two or three a day I'm not really sure what the threshold would be for SEO but uh I think doing 40 in one day might be a bit Overkill
um but who knows with Google right so uh I hope you learned something and see you I hope you learned something and see you next time