How I Schedule 100 X Posts in One Day

With a little automation, artificial intelligence (AI), and a bit of human editing, you can generate 100 X posts in less than an hour.

In fact, I will share the specific Zapier automation I used to create 100 of X posts for my ecommerce profile.

Process Overview

The aim is to generate a lot of X posts from content I've already created or actively curated. Here are the basic steps.

Source articles and paste the URLs into a Google Sheet.
Use Zapier to parse the URL.
Have ChatGPT generate four X posts using post frameworks.
Add the post to a Google Document.
Edit in Google.
Schedule with Buffer.

Now, let's consider each part of the steps in detail. Keep in mind that this is not a completely automated process. Some steps require you to interact with the posts.

Google Sheet Setup

I used a Google Sheet to trigger the post-generation process. The sheet had three columns, including the source article's URL, author, and title.

This is the Google Sheet that triggers the Zapier automation.

I only use the URL column in the zap I describe in this article, but I had plans for this sheet in other automations.

This is basic Zapier engineering. I will only mention that I have the zap fire when the title field is filled in. This way, if I fill the columns from left to right, the zap will not fire until a row is completed.

Zapier automations are visual, so you don't need any coding experience.

Use Zapier to Parse the Article

Zapier has a web parser. Simply put, it accepts a URL, fetches the content of the URL, and outputs that content in the format you request. I used plain text in this example.

Zapier's web parser is a feature I use alot. It is a great way to ingest website content.

ChatGPT and Four Formats

For the next four steps, you will need an OpenAI API account. This pay-as-go account is separate from your regular ChatGPT pro account. You can set up this kind of platform account here.

The zap sends four similar requests to ChatGPT 4.o. Each request provides the source material —this is the content Zapier parsed in the previous step— and information about the specific output I want.

The ChatGPT step is repeated four times in the automation.

And what I want are four "frameworks," if you will. ChatGPT will consider the source material, and identify a problem, pain point, solution, and lesson for the audience, which in this case is made up of ecommerce business owners and leaders. It will do the same for the PAS framework. Then, it generates a question. Finally, it creates a short summary of the source article.

Problem, Pain, Solution, Lesson (PPSL).
Problem, Agitate, Solution (PAS).
Question.
Summary and announcement.

Let's look at an example.

I provided the zap with the URL for an article I had written for Practical Ecommerce. The article's title was "New Google Shopping Is an SEO Reality Check."

The automation produced these X posts.

PPSL. Folks, Google's recent AI makeover of Shopping is shaking things up.

Ecommerce marketers are feeling the pressure as Google pushes for more precise product details.

To adapt, refine your product listings, and embrace structured data.

If you don't evolve, your competition will outshine you. What changes are you planning to make in response?

PAS. Is your ecommerce strategy ready for the changes that Google's new Shopping experience brings?

Many marketers are feeling the heat. The shift to AI-driven personalized searches raises questions about relevance and optimization.

To thrive, ensure your product feeds are top-notch, structured data is in place, and reviews are flowing.

What's your game plan? Let's discuss how you're preparing for this transformation.

Question. With Google Shopping's new AI features, how are you adapting your product listings to stand out? Share your thoughts.

Summary. Google Shopping's new AI-driven experience launched October 15, 2024, reshaping how products are shown.

Marketers must ensure detailed listings and optimize for visual search to stay competitive.

The Google Doc

For my purposes, I wanted to ensure I had a chance to read and edit the X posts before those posts started to appear on the feed for my ecommerce-focused X account.

This choice meant I sent the ChatGPT posts to a Google Document rather than directly connecting the automation to my scheduling tool, Buffer.

The generated X posts are appended to the Google Document.

I want to be clear that I could have automated the entire process —although I would have had to ensure the ChatGPT posts met X requirements.

At this step, I started editing inside the Google document.

Schedule with Buffer

Very quickly I was able to have 100 X posts ready to go for my ecommerce account. By comparison, getting 100 posts for my primary X account took a couple weeks.

My last step was to schedule the posts with Buffer. Once again, I could have done this with the automation, but I wanted to play the editor's role myself.

Bottom line, I was able to schedule 100 X posts in about an hour.