an ai generated image of a laptop with automation symbols on the screen

How I Automated Blog Post Creation Using Make.com in 3 Easy Steps (for Less Than 5 Cents!)

September 27, 20245 min read

Automation can sound complicated, but let me show you how I created a super simple blog post automation using Make.com with just three easy steps. This setup saves time and effort and costs me less than five cents per post—yes, you read that right! 😄

If you're tired of spending hours writing content or want to make your content creation process faster and more efficient, this guide will walk you through the exact automation I created using Make.com, Google Sheets, and ChatGPT.

Let’s break it down step-by-step!


Step 1: Set Up Google Sheets as Your Input Source

The first thing I did was create a simple Google Sheet. This sheet only contained one thing: blog post titles. Each row represented a new blog post idea that I wanted to automate. No complex setup—just one column of blog post titles that I wanted to expand into full articles.

Google Sheets is an ideal tool for this kind of automation because it’s easy to use, accessible, and works perfectly with Make.com integrations. In my case, I used it as the starting point to kick off the entire automation workflow.


Step 2: Connect Google Sheets to Make.com and ChatGPT

Next, I set up Make.com (formerly known as Integromat) to connect Google Sheets to ChatGPT. Here’s what this looked like:

  • Create a Scenario in Make.com: I created a new scenario that would listen for new entries in the Google Sheet. Whenever I added a new blog post title, it would automatically trigger the automation.

  • Link Google Sheets to ChatGPT: Using an API key from ChatGPT 4, I linked Google Sheets to ChatGPT. This way, whenever a new blog title was added to the sheet, it would send the title to ChatGPT to generate an outline or draft of the blog post.

  • Make.com Setup: Make.com describes its automation as a way to "boost productivity by integrating OpenAI's ChatGPT, Whisper, and DALL-E with Google Sheets, enabling real-time responses and insightful analysis." For my use case, I only needed to integrate ChatGPT and Google Sheets to get the output back into the sheet. The process was quick and straightforward.


Step 3: Get the Output from ChatGPT Back to Google Sheets

After sending the blog post title to ChatGPT, I needed a way to get the output back into my Google Sheet. This was the magic of Make.com—it made it possible to send the generated content straight back into the same Google Sheet, right next to the original title.

  • Real-Time Content Generation: As soon as I added a new title to Google Sheets, Make.com would trigger ChatGPT to generate the blog post draft based on that title. Within a few moments, I’d have a draft version of the blog post right there in the next column of my Google Sheet.

  • Cost Efficiency: The best part? The entire process of generating the blog post draft cost me less than 5 cents per post. This is a game-changer for small businesses, bloggers, and content creators who want to automate repetitive tasks without spending a fortune.


Why This Automation Is a Game-Changer

Using Make.com with ChatGPT and Google Sheets has completely changed how I approach content creation. Here are a few reasons why this automation is so effective:

  • Time Saver: Instead of sitting down to write out an entire blog post from scratch, I can now generate a draft instantly, giving me a head start on content creation.

  • Cost-Effective: At just a few cents per post, this automation is incredibly affordable—even for those on a tight budget.

  • Simple Setup: This automation only required three steps, and none of them were overly technical. Make.com’s interface is intuitive, and setting up the scenario was a breeze.

  • Scalable: Whether you want to create 5 posts or 50, the process is the same. Just add the titles to your Google Sheet, and let the automation do the work for you.


How You Can Set Up Your Own Blog Post Automation

If you’re interested in setting up your own version of this automation, here’s what you’ll need:

  1. A Google Sheet: Add your blog post titles here—keep it simple.

  2. Make.com Account: Use Make.com to create a scenario that connects Google Sheets to ChatGPT.

  3. ChatGPT API Key: You’ll need an API key from ChatGPT 4 to enable the connection.

  4. Set Up the Scenario: Link Google Sheets to ChatGPT via Make.com, and set it to output the response back into your sheet.

Once everything is set up, all you have to do is add new blog post titles to your Google Sheet, and within minutes, you’ll have content ready to refine and publish. No more staring at a blank page wondering what to write!


Conclusion: Automation Made Simple

Automation doesn’t have to be complex or expensive. With just a few simple steps, I’ve managed to create an automation workflow that saves me time, energy, and money—all for less than the cost of a cup of coffee. ☕

Whether you’re a busy mom, a blogger, or an entrepreneur looking to streamline your content creation process, this 3-step blog post automation using Make.com, Google Sheets, and ChatGPT is an easy and affordable way to boost productivity and get more done in less time.

If you’re ready to stop wasting hours on content creation and start automating, why not give Make.com a try? You’ll be amazed at what a few simple steps can do for your workflow!

AI Disclaimer:
This blog post was partially generated using AI tools, including ChatGPT. The content has been reviewed and edited for accuracy, relevance, and quality by the author to ensure it meets the needs of our readers. Please note that while AI contributes to the content, all opinions, experiences, and insights are those of the author.

I'm Drea, a resilient single mom to three incredible boys who are my motivation for everything! I know firsthand the joys and challenges of raising kids while striving to create a better life for them. I help empower moms like you with the tools, tips, and motivation they need to thrive.

Drea @ Mom Meets World

I'm Drea, a resilient single mom to three incredible boys who are my motivation for everything! I know firsthand the joys and challenges of raising kids while striving to create a better life for them. I help empower moms like you with the tools, tips, and motivation they need to thrive.

Back to Blog