Free Intensive Nov 21–22Free 2-day hands-on Vibecoding Intensive on Nov 21–22 at 16:00 MSK (Sat–Sun) · Live Cohort 3 starts Nov 23Join Free →Cohort 3 (Nov 23)

Claude Code writes and publishes SEO articles three times a day on a schedule

Company blogs often stall when the team gets tired of writing SEO articles, the texts that help a site show up in search. Oleg Shestakov of Rush Agency handed this job to Claude Code: on a schedule, three times a day, it takes a query from a Google Sheet, writes an article according to the rules, checks it, and publishes it. A person writes the rules once and reviews the first 10–20 articles. That's why it makes sense to start by putting the texts into drafts that are hidden from search engines and releasing them with one click.

AI-processed from TG: @solokumi (Kumar & Solo); edited by Hamidun News
Claude Code writes and publishes SEO articles three times a day on a schedule
Source: TG: @solokumi (Kumar & Solo). Collage: Hamidun News.
Listen to article
Article Fact Sheet & Key Figures
ParameterDetails
Primary sourceTG: @solokumi (Kumar & Solo) ↗
Editor-in-Chief
StackGoogle Sheets, GitHub, Cloudflare Pages, Routines in Claude Code
Key metric #2Routines are scheduled tasks, for example three runs a day
Key metric #3Skills write the article, check facts, and look for broken links

A familiar story: a company launches its blog with enthusiasm, writes two or three articles, and then the team burns out and new texts stop appearing. Meanwhile, sites often grow in search precisely because of new material. Oleg Shestakov, founder of the SEO agency Rush Agency, handed this routine to Claude Code.

It is an AI assistant from Anthropic that works with code and files and can carry out tasks on its own. An SEO article here means a text written for a query that brings people to a site from a search engine. Claude Code, run on a schedule, for example three times a day, takes the next topic from a spreadsheet, writes an article, checks it, and publishes it.

The scheme was broken down in the Telegram channel Kumar & Solo, and it can be reproduced in one evening.

How the pipeline works

The task queue lives in an ordinary Google Sheet. Each row contains three things: the search query you want the site to be found for, a short brief, and the address where the article will appear. Every few hours, the agent opens the sheet and takes the next row.

Publishing also runs without manual steps. The site lives in a GitHub repository and is connected to the free Cloudflare Pages service. When a file with an article appears in the repository, the site rebuilds itself.

Two sets of materials that sit alongside the site determine quality:

  • a rules file: heading structure, tone, and a list of what must not be written;
  • skills, meaning ready-made instructions for Claude: one writes the article, another checks the facts, and a third looks for broken links.

The result is a checklist that you compile once and that is applied to every text in the same way.

How to set it up

You will need a simple website and Claude Code or Codex. The order is as follows:

  1. Create a Google Sheet with queries, briefs, and addresses.
  2. Put the site on GitHub and connect Cloudflare Pages.
  3. Add the rules file and skills to the repository.
  4. In Claude Code, open Routines, that is, scheduled tasks. Connect GitHub and Google Drive and give the instruction: "take the next query from the sheet, write an article according to the rules, check it, and publish it."
  5. Set the schedule, for example three runs a day.

After that, you need to do two things: write the rules and skills once, and review the first 10–20 articles. Shestakov advises not to release them to the open web right away. First, the agent puts the texts into a draft hidden from search engines. You read the result and publish it with one click. When the rules are debugged and the same mistakes stop recurring, publishing can be switched to automatic mode.

What to keep in mind

The post does not say how much a single run costs or what traffic the sites received. The author does not disclose those figures. You will have to work out the economics yourself. Take the cost of a run on your plan, multiply it by three runs a day, and compare that with what a copywriter charges per article. Also count how many edits you make to each draft. If there are many edits, look for the cause in the rules, not in the model.

There is also a risk the post does not mention. Search engines do not favor mass-produced content with no value for the reader, and a stream of similar articles may bring no traffic. For that reason, the briefs in the sheet should be filled with things that are not in ordinary search results: your own data, examples, and client figures. The model will not invent them by itself, and fact-checking remains a human responsibility until you are confident that the skills work reliably.

For developers and founders, the conclusion is simple. Routines turn Claude Code from an assistant you launch by hand into an executor that works on a timetable. For such a scheme to produce results, three things are needed: a clear task queue in a spreadsheet, automatic deployment, and a check at every step. Start with drafts for 10–20 articles, see what you edit most often, and move those corrections into the rules file. With each cycle, the agent will need less of your intervention.

Story

Key Questions Answered

How the pipeline works?

The task queue lives in an ordinary Google Sheet. Each row contains three things: the search query you want the site to be found for, a short brief, and the address where the article will appear. Every few hours, the agent opens the sheet and takes the next row. Publishing also runs without manual steps. The site lives in a GitHub repository and is connected to the free Cloudflare Pages service. When a file with an article appears in the repository, the site rebuilds itself.

How to set it up?

You will need a simple website and Claude Code or Codex. The order is as follows: Create a Google Sheet with queries, briefs, and addresses. Put the site on GitHub and connect Cloudflare Pages. Add the rules file and skills to the repository. In Claude Code, open Routines, that is, scheduled tasks. Connect GitHub and Google Drive and give the instruction: "take the next query from the sheet, write an article according to the rules, check it, and publish it." Set the schedule, for example three runs a day.

What to keep in mind?

The post does not say how much a single run costs or what traffic the sites received. The author does not disclose those figures. You will have to work out the economics yourself. Take the cost of a run on your plan, multiply it by three runs a day, and compare that with what a copywriter charges per article. Also count how many edits you make to each draft. If there are many edits, look for the cause in the rules, not in the model. There is also a risk the post does not mention.

ZK
Zhemal Khamidun — CPO at Alpina Digital, product manager of AlpinaGPT. Building AI products since 2019. Hamidun News is a pet project that grew into a production aggregator with 6,000+ readers.
✦ Hands-On AI Engineering · Hamidun Academy

Build & Ship Production AI Agents Without Boilerplate Code

Start your free 72-hour trial at Hamidun Academy (academy.hamidun.com) — interactive lessons on Claude Code & Cursor, live Tech Radar, and production agent templates.

Start 72h Free Trial →Vibe-Coding Intensive
What do you think?
Loading comments…