GPT for Sheets - SEO Use Case - Content Briefing Template
Steal My Content Brief Template - GPT for Sheets - Ready To Use
Update APR. '24: The Google Sheets add-on that I am using in this sheet is not free anymore (they have a free trial available) so if you want to use this template make sure you know the implied costs, I have used it intensively and never went over 15 EUR/mo).
Content Briefings are the best way to create qualitative content that ranks high on Google. If you build a sharp and strong content brief, the copywriter will be able to focus on creating a fantastic piece of work. The chances of scoring a top organic ranking with this method is x10 higher than if you start writing without a plan.
I sprinkled some AI GPT on a regular briefing template and BAM! In 5 mins you can create a high-quality content briefing.
(Well, one of the ways). With my Content Brief Generator you can easily build a detailed content brief within minutes. You only need a few free tools a focus keywords and a competitor.
Create Your Own GPT Content Brief Assistant with Google Sheets
You will only need to install GPT for Sheets and a few SEO Tools (more info below). The briefing template is using curated GPT SEO Prompts that you can modify and improve.
- Install GPT for Sheets.
- Get your core keyword, supportive keyword and one competitor link.
- Get the core keywords from SE Ranking.
- Get long-tail keywords from AnswerThePublic.
- Run all the GPT Prompts in the template (19 SEO Prompts).
- Get your content briefing in any format (PDF, Word, etc).
How to write a content brief
- Identify your Primary keywords and its intent
- Get the Long tail terms
- Find Longtail keywords - Questions (How, What, When...)
- Find Longtail keywords - Prepositions (Near, For, With, Or, To...)
- Get the most relevant (Try Alphabeticals and Most related)
- Audience definition
- Draft SEO title suggestions
- Draft SEO description suggestions
- Draft H1 suggestions
- Draft Sub title suggestions
- Get a clear Outline
- Find relevant FAQs (including answers)
- Give an Article Length recommendation
Quite come steps uh?! Well, good news is that my Content Briefing Template does this in 5 mins or even faster.
Content Brief Example with Sheets + GPT
You can build your briefing easily following the instructions in the Video I included. There I show an example of a briefing that I will actually use to improve my own page Jairo Guerrero SEO Consultant. Follow the steps in the video and create easily your own content brief. The template is in Google Sheets but once you are done you can download your content brief pdf or content brief word files.
Content Briefing Tools You Need
Tools you need (link directly to each):
- SE Ranking
- AnswerThePublic
- Google Search Console (optional for internal links opportunities)
- GPT for Google Sheets
ATTENTION: You will need to setup a Google Sheets add-on first on your own Open AI (GPT) account:
https://workspace.google.com/marketplace/app/gpt_for_sheets_and_docs/677318054654
Once you have set it up you can start grabbing some data to give it to the AI. She will build your content brief in no time.
Content Brief Template Free Download
This AI Content Brief Template is FREE. But any amount will be much appreciated! Lifetime access. I will keep improving the template so stay tuned. Follow me on my SEO Gumroad homepage, on my all around SEO-Blog and on my LinkedIn page.
Give me a follow here so I can keep creating content:
More Free SEO Resources:
You will get the template and a video tutorial of how to use it. You can add up the data straight away. Make it yours!