Perform Keyword Clustering and Content Planning using GPT 3.5 turbo [FREE Template Included]

Keyword Clustering is an important aspect of SEO but it can be a bit of a drag, especially when you're not using any of the paid SEO tools. When you're creating new content, it can be tricky to figure out if a topic should be broken into smaller sub-topics. Like, should "home workouts" and "no-equipment home workouts" be targeted with one page or two?

Good news – Spresso's got your back with a FREE Google Sheets template that's powered by GPT-3.5 turbo! With it, you can:

1. Create multiple keyword clusters from one seed topic.
2. Expand each cluster with a list of related keywords.
3. Pull out search intent, and craft title tags and meta descriptions for each keyword.
4. Whip up an article outline for the keywords you choose.

But before we dive into setting up the sheet, let’s talk about keyword clustering.

What is keyword clustering?

Keyword clustering is all about grouping similar keywords together. Think of a “keyword cluster” as a bunch of keywords that all revolve around the same topic and can be targeted on a single page.

For example, if your cluster is "home workouts," your related keywords might be:

• Home workouts
• No-equipment home workouts
• Home workouts for beginners
• Quick home workouts
• Home workout routines

These keywords all relate to the same topic and can be effectively targeted together.

What are the benefits of keyword clustering?

Here’s why keyword clustering can boost your website’s rankings:

1. Your page can rank for multiple keywords.
2. Your content sounds more natural – no more keyword stuffing.
3. A cluster of keywords can have a much higher search volume than a single keyword.
4. It's easier (and more rewarding) to rank for many low-volume, low-difficulty keywords than to target one high-volume keyword.

So, ready to get started? Let’s dive in!

Free keyword clustering and content planning google sheet template

To use this sheet, you'll need your own API Key from OpenAI. Don’t worry, I’ll guide you through the process. Just follow these step-by-step instructions, and you'll have it set up in no time.

Create a copy of the template

The first step would be to create a copy of the Google Sheet template. Click on the button below and get your copy.

Get API key from Open AI

Sign up and create your account on the Open AI platform.

Once you're done signing up, create your API Key by visiting this page.

Due to the new policies, you might have to verify your phone number and load some credits before you are able to start using the API key. Just verify your phone number by clicking the Start Verification button.

You can add your payment method and load up credits in the billing screen.

Set up the keyword clustering & content planner template

Go to the "Setup" sheet of the template and input the key you just obtained from Open AI and input it in the relevant cell as shown in the image.

Generate keyword clusters

Let's say our website is all about Search Engine Optimization. We can enter "SEO" next to the seed topic field. Once you've done that, go to the top navigation and you'll see a new item named "Keyword Research & Clustering". Click on that and then select Generate Keyword Clusters.

‍

Once the script has finished running successfully, you can go to the Keyword Clusters tab and have a look at the different clusters that were generated.

Prepare new sheet for selected clusters

Once you have your keyword clusters, you can select the ones that you want to work on by clicking on the checkboxes. Then go to the Keyword Research & Clustering menu item and select Prepare New Sheets for Selected Clusters.

This will create a new sheet for each of your selection so you have a separate space for every cluster.

In our example, we are selecting "seo tools" and "local seo" as the clusters we want to explore.

Generate keywords, extract search intent, title tags and meta descriptions for selected clusters

Go to the tab of the cluster that you want to work on first. We'll go to the "local seo" cluster and then follow steps 3 - 6 one at a time. Ensure that the script has finished running for one step before you move on to the next step.

• Step 3 will generate a list of long-tail keywords based on the cluster.
• Step 4 will extract the search intent for each of the keywords.
• Step 5 will generate title tags for a pages targeting each of the keywords.
• Step 6 will generate the meta description for pages targeting each of the keywords.

Depending on the search intent and context of the keywords, you might want to create separate pages for all the keywords or a single page targeting multiple keywords. This sheet will help you analyse that and give you some more related keywords that you can include on your page.

If you decide to target multiple keywords on a single page, you can pick the title tag and meta description of the primary keyword that you'll be using. Also, these title tags and meta descriptions are just a starting point. You know your target audience better than any AI algorithm, so you should always tweak these based on what you think will work best.

Generate article outline for the selected keyword

In this step, you can highlight the keyword that you want to generate an outline for by simply click on the cell and then select Generate article outline from the navigation.

Pros and Cons of using this template

‍

Let us know what you think about this template. You can reach out to us on nimit@spressostudio.com if you have any doubts or issues.