How I use SheetGPT to create content for me
A new GPT, called SheetGPT, is a powerful spreadsheet tool that helps users to automate tedious and time-consuming tasks such as content creation, sentimental analysis, data extraction, and many more.
Ever since OpenAI launched ChatGPT in November 2022, many companies have started rolling out their own versions of AI to try to compete or stay relevant. Many companies developed AI tools for specific use cases, such as a GPT plug-in specifically for Google Docs, etc.
One of them — SheetGPT, is an add-on specifically for Google Sheets.
And yup, we’ll talk about SheetGPT today. But before I go on, let’s look at what I have in store in today’s newsletter:
📑 What is SheetGPT?
😱 Introduction
✔️ Features of SheetGPT
😯 How to use SheetGPT?
❌ Limitations of SheetGPT
✅ Benefits of SheetGPT
Conclusion on the AI spreadsheet tool
What is SheetGPT?
SheetGPT is a hybrid model that combines the power of GPT with spreadsheets, allowing users to generate natural language descriptions of spreadsheet data.
According to SheetGPT’s website, it can:
Ideate and create content
Research and organize digital marketing campaigns
Summarize, categorize, classify and cleanse data
Test and collaborate on AI prototypes
How to use SheetGPT?
Not only do you need to know how to type in specific and relevant prompts according to your needs, but you also need to understand the “=GPT” function as well.
Syntax
=GPT(prompt, gpt_model, temperature, max_tokens, cache)
When you enter “=GPT(”, you’ll be asked to enter a prompt and other optional input — model, temperature, maxTokens, cache.
But what do all these parameters mean exactly? (these are from SheetGPT’s website)
🔑 Prompt: String representing user prompt (must include “”)
🤖 gpt-Model (optional): String representing OpenAI GPT model to use. Eg: "gpt-4", "gpt-3.5-turbo" (default), "text-davinci-003", "text-curie-001", "text-babbage-001", "text-ada-001".
⛅ Temperature (optional): Number between 0 and 1 representing how much variance to introduce when responding. 0 is very little variance and 1 is the most variance.
🪙 maxTokens (optional): Number representing the max no. of tokens to return as the response. Default is 1000.
⚡ Cache (optional): Whether or not to cache the response. Setting to false will incur a re-execution on every cell refresh. Default is true.
I’ve posted a reel on @thesocialnote.co Instagram on how to use SheetGPT to create content ideas — especially if you’re a marketer:
What I did in the reel was:
1️⃣Segment my spreadsheet nicely with things like the type of content, brand name, and keywords to rank for:
Also, in cells A5, B5 and C5, I included the headers “Generated topics”, “Generated outline” and “Generated article” respectively:
2️⃣Starting off with “Generated topics”
The input was is:
=GPT("Create 1 article title for our brand called "&B2&" that will rank highly in Google search engine results page for the following terms: "&B3)
Here’s what I got:
The input “&B3” means that I’m telling the spreadsheet to reference from cell B3 for that particular prompt. For this instance, cell B3 contains the keywords “coffee beans”, '“coffee delivery service”, and “cold brew”. So the spreadsheet will reference these keywords and generate a topic based on them.
3️⃣Next, “Generated outline” (what is needed to be included in the article)
=GPT("What are the 3 main points of discussion for an article titled: "&A6&" that will rank highly in Google organic search results for the following searches: " &B3 &". The articles should bring more awareness for the brand of the coffee called "&B2)
Here’s what I got:
4️⃣Lastly, I generated a 300-word article in one of the “Generated article” cell
=IF(NOT(ISBLANK(B6)), GPT("Write a 300 word article titled '" & A6 & "' from the following outline: " &B6,,,500), "")
Here’s what I got:
You can actually omit the “=IF(NOT(ISBLANK())” function. The reason why I use it is that sometimes the “Generated outline” cell may be empty, and without the function “=IF(NOT(ISBLANK())”, it will simply return an error.
Limitations of SheetGPT
Just like any tool out there, there are certain limitations that SheetGPT have:
Limited knowledge — the AI does not have answers to everything because it lacks training data and might not be up-to-date with the latest information
Usage (costly) — The first 100,000 words of input and output are free, but beyond that, users have to pay for their plans
Conclusion of the AI spreadsheet tool
Overall, I believe SheetGPT is an excellent AI tool to try out and do the abovementioned tasks.
Entering the prompts and parameters is fun, and seeing the results are too.
However, SheetGPT is not the only GPT add-on available for Google Sheets. There are GPT for Docs™ Sheets™ Slides™ and GPT for Sheets™ and Docs™.
Personally, I would try to use them to generate content and test them out.
Who knows? You might create your most viral content with the assistance of AI.
Who knows? You might be able to create content that you never thought of.
Who knows? This newsletter might be written using SheetGPT 😧 (just kidding haha!).
Anyways, try it for yourself and let me know!
Till next time,
Alvis