Using ChatGPT to find topics to write on Medium

If you want your Medium articles to do well, you need to write about the things your audience wants.

Obvious, huh?

Well… yeah.

But not so obvious to find out what they want.

Unless you analyze the data to figure out what’s already working.

In this video I walk through an example of scraping data from Medium and using ChatGPT to get insights.

Here’s the prompt I used. Make sure your column titles in the prompt match the columns in the CSV file.

Attached file is a list of articles from Medium. These articles are all tagged [TAG]

I'm interested in 3 columns - Article Title, Claps, Comments

Can you please analyze the data. I want to know:

1 Any patterns in articles that get the most claps
2 Any patterns in articles that get the most comments
3 Any patterns in articles that get the least claps
4 Any patterns in articles that get the least comments
5 Based upon this, what topics should I write if I want to maximize the claps and comments

Please present in an easy to read report

Play around with it to get the output you want.

And ask ChatGPT follow up questions on the results. Dive deep.


My newsletter helps creators figure out how to build financial freedom online with digital products. You can get it here

Leave a Reply

Your email address will not be published. Required fields are marked *