Automate Blogger

What I mean by automating Blogger

Automating Blogger means a bot handles the publishing work, not the writing. Taking drafts from a sheet and posting them with the right title, labels, and formatting, scheduling a backlog so posts go out over time, updating a detail across many old posts at once, and pulling comments or stats into a sheet. The words are yours. The mechanical part of getting them onto the blog is what a bot takes on.

Publishing is a pipeline

Think of a blog less as a page and more as a pipeline. A draft comes in, it gets a title and labels, it is formatted, it is published or scheduled. Done once, that is a few minutes. Done for a backlog of fifty posts, or every week forever, it is a chore that crowds out the writing.

Blogger has an API if you want to script against it directly, but most people just want their drafts to become posts without the clicking. That is the pipeline a bot runs. Keep your posts in a sheet, one row each, and let the bot publish them down the list, on the schedule you set. The writing stays human, the publishing runs itself.

Who this is for

This is for the blogger or small content team publishing on Blogger without a developer. You write in a doc or a sheet, and you would rather not paste, format, and publish each post by hand. Migrating a backlog, scheduling ahead, or fixing the same thing across old posts. No-coders and coders both, since you can build it without code and drop into code when you want.

How I'd approach it

Put your posts in a sheet. One row per post, columns for the title, the body, and the labels. Point the bot at Blogger, and let it create each post, paste the body, set the labels, and publish or schedule it. Start with one post to check the formatting comes through, then run the list. Run it on your own blog with your own logged-in session.

Sheet to blog, one post first, then the backlog. I would lay out the first draft with Build with description.

Automate Blogger from a description

Describe the task in plain words in the Chrome extension and it builds the steps for you. Give it a few short lines, check what it made, and run it. Explore no-code.

Automate Blogger in code

Build with code. If you would rather script it yourself, this is the path. Explore code

import { chromium } from "playwright";

const browser = await chromium.connectOverCDP(
  `wss://cdp-lb.axiom.ai/?token=${process.env.AXIOM_API_KEY}`
);

try {
  const context = browser.contexts()[0];
  const page = context.pages()[0] ?? await context.newPage();

  // Your posts, from your sheet
  const posts = [
    { title: "On slow mornings", body: "<p>The first post body.</p>", labels: "essays" },
  ];

  for (const post of posts) {
    // New post on your own blog, using your logged-in session
    await page.goto("https://www.blogger.com/blog/post/edit/new");
    await page.getByLabel("Title").fill(post.title);
    await page.frameLocator(".editor iframe").locator("body").fill(post.body);
    await page.getByLabel("Labels").fill(post.labels);
    await page.getByRole("button", { name: "Publish" }).click();
    await page.waitForSelector("text=Published");
  }
} finally {
  await browser.close();
}

+

Build with a Claude skill

Build no-code or code bots with a skill.

Add the Claude skill and describe how you publish. It builds the bot for you, no-code or code, turning a sheet of drafts into posts on your blog.

Install the skillLearn more

What can you automate?

The publishing pipeline, for the blog you run. A couple of cases worth knowing first.

What I'd watch out for

Blogger is simple, but the editor has a couple of quirks. Here is what I would watch for.

The editor is in an iframe

Blogger's post body lives inside a rich-text frame, so a bot has to target the frame, not the page, to type into it. If text will not go in, that is usually why.

Check the formatting on one post

Pasting a body can carry stray formatting. Run one post first, look at how it published, and fix the source in your sheet before you push the whole backlog.

Use your own session

Sign in as yourself on the blog you own, and store the cookies so the bot keeps the session rather than logging in fresh each run.

When the editor changes

If a field stops being found after a Blogger update, repick it with the selector tool, and confirm the iframe is still where the body goes.