02/03/2022, SEO
Free GPT-3 Sheets for Marketers
I recently released a collection of free Google Sheets & Scripts for marketers utilising OpenAI’s GPT-3 machine learning language API. This post is a roundup of the sheets and links to download them.
GPT-3 + Web Search
This free Google Sheets script lets you generate AI-generated responses to search queries on current information with cited sources.
GPT-3 ALT Tag Generator
This free script allows you to automatically generate image ALT tags in Google Sheets.
HARO Journo Response Generator
This free tool uses GPT-3 to identify and respond to press requests from journalists looking for sources for a story.
Find Low Hanging Fruit Keywords
This script find quick-win content opportunities from ranking keywords that are a poor match to your content titles.
Convert English to Regex with GPT-3
This script takes a plain English description of a filter e.g. “Contains a link.” and converts the description into a valid Regex statement. e.g. “(https?://)?\w+(\.[\w-]+)+”.
GPT-3 Business Email Generator
Create GPT3-powered business emails from a short message. Designed for people with literacy challenges or poor written communication skills.
Content ideas from audience hashtags
This script takes the hashtags most frequently used by your target audience and generates content ideas from those hashtags relevant to your audience.
Classify keyword context using GPT-3
This script takes a list of keywords and classifies them according to any rule you specify. e.g. “Legal or Non-legal”.
Get answers to your SEO questions with MuellerBot
This script provides answers to any SEO question in the inimitable style of John Mueller, Search Advocate at Google.
Convert English to Google Sheet formulas
This free Google Sheet script uses GPT-3 AI to generate complex Google Sheet formulas based on any English description.
You simply describe the formula you need into a cell in plain English. The script then generates a valid Google Sheet formula based on your description.
Get emotional goals and ad copy for any product or service.
Enter a product or service type into the sheet and receive the emotional goal driving that product/service purchase. Then generates copy for ads or landing pages utilising the product and goal specified.
Generate a colour palette from any English description
Provide any plain English description e.g. “Indian wedding” and receive a colour palette inspired by your description.
Create a chart from any plain English description.
Describe a chart, get a chart. This one is more for fun and (perhaps) of less practical use. However, it could be easily adapted to some interesting use cases.
Classify the conversion potential of keywords
Classify a list of keywords by their conversion potential for your business.
Free Tutorial – Create your own GPT-3 apps in Google Sheets
A series of four free tutorial videos to guide you through the process of creating your own GPT-3 based apps step-by-step. You don’t need any previous coding knowledge to follow these tutorials and adapt my scripts to use with your own GPT-3 prompts.
Business applications using DALLE-2
Some examples of using OpenAI’s Dalle-2 AI image generator for business applications.
That’s all for now!
