Guide: How to create 150,000 blog posts with AI

Written by Tapio Kauranen

Written 21 July 2024 – Updated 19 August 2026

Table of contents
  1. Warning! AI-generated content doesn’t work on Google!
  2. Tools you need
  3. Create a Google Sheet
  4. Install GPT for Work
  5. Generate topics
  6. Generate headlines
  7. Generate content
  8. Duplicate
  9. Save as CSV
  10. Export to WordPress
  11. In Drag & Drop, place the title and content in their spots
  12. In the next step, click "auto detect"
  13. Ready in minutes!
Table of contents: Introduction

Warning! AI-generated content doesn’t work on Google!

This article was created because Finnish entrepreneurs are being sold low-quality AI articles at high prices.

I want to show that you can generate thousands of articles yourself for a tiny cost (150,000 articles for €39) in just a few minutes.

However, these articles will not appear on Google. In the worst case, they could even destroy your Google visibility completely!

Consider yourself warned.

Tapio Kauranen and the headline “Opas: Näin luot tekoälyn avulla 150 000 blogiartikkelia hintaan 39 €” (guide: how to create 150,000 blog posts with AI for €39)

Tools you need

These tools will get the job done

Create a Google Sheet

Or copy this template of mine

Create a new Google Sheet and name three separate columns.

  • Topic = will be the subject the blog is created from
  • Title = the blog post’s headline
  • Content = Content

Copy template from here

A Google Sheet named “Blogipostaukset” (blog posts) with the columns Aihe (topic), Otsikko (title) and Sisältö (content)

Install GPT for Work

Add the GPT for Work add-on to Google Sheets

This connects AI to Google Sheets

Install from here

Google Sheets' Extensions menu: Open under the GPT for Sheets and Docs add-on circled in red

Generate topics

=GPT_LIST("") command creates a list of topics

When GPT for Work is installed, you can use its features.

One of them is gpt_list.

For example, type:

  • =GPT_LIST("Questions about starting a business", 50)
  • Replace the text inside the quotes with your own topic
  • The number indicates how many list items will be generated
A GPT_LIST formula in cell A2 of Google Sheets that writes 50 topics on “Yrityksen perustamisen kysymyksiä” (questions about starting a business)

Generate headlines

=GPT("Create a headline for this article. Only the first letter should be capitalized", A2)

With this command you can create a headline for an article based on its topic.

For some reason the AI tends to capitalize every word. That’s why I asked it to use only the first letter as a capital.

Google Sheets: topics in column A, and in cell B2 a GPT formula that writes a title for the topic

Generate content

=GPT("Create the article content in HTML format. Allowed tags are <h2><h3><p><li><ul><a>", A2)

Next, we’ll create the article content.

You can edit this however you like.

The GPT formula of the Sisältö (content) column, which writes the article in HTML with the tags h2, h3, p, li, ul and a

Duplicate

Once the first article is created, duplicate the formula down to the lower rows

If there are thousands of rows this may take a few minutes.

The formulas copied down the sheet: row 2 has a finished title and HTML content, most other cells are still loading

Save as CSV

Download the sheet as a CSV

The File menu of Google Sheets, under Download: Comma-separated values (.csv) circled in red

Export to WordPress

Install the WP All Import plugin and use the CSV "upload a file" feature to import it

The WP All Import plugin's New Import screen, where the file is uploaded to WordPress with the Upload a file button

In Drag & Drop, place the title and content in their spots

WP All Import's Drag & Drop: the file's otsikko (title) and sisältö (content) fields are dragged into the post's title and content

In the next step, click "auto detect"

WP All Import's Unique Identifier field set to the otsikko (title) field, with the Auto-detect button beside it

Ready in minutes!

The GPT for Work add-on costs €39 and includes 97 million tokens. That’s enough to generate nearly 150,000 articles.

  • Avg. tokens per blog post: 650

  • Total tokens: 97,000,000

  • Estimated number of blog posts: ~149,230

An article created with AI, published on the site: the headline “Yrityksen liiketoimintaidean määrittely” (defining a company's business idea)

Need help?

Book a free SEO check: in a 60-minute video call we look at how your website shows up on Google in Finland and what to fix first.

Email

tapio@tapiokauranen.com

Tell me briefly what you need. I will reply as soon as I can.

Free SEO check

A 60-minute Google Meet call: we look at how your website shows up on Google in Finland.

Book a free SEO check

Read next