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.
This free Google Sheets script lets you generate AI-generated responses to search queries on current information with cited sources.
This free script allows you to automatically generate image ALT tags in Google Sheets.
This free tool uses GPT-3 to identify and respond to press requests from journalists looking for sources for a story.
This script find quick-win content opportunities from ranking keywords that are a poor match to your content titles.
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-]+)+”.
Create GPT3-powered business emails from a short message. Designed for people with literacy challenges or poor written communication skills.
This script takes the hashtags most frequently used by your target audience and generates content ideas from those hashtags relevant to your audience.
This script takes a list of keywords and classifies them according to any rule you specify. e.g. “Legal or Non-legal”.
This script provides answers to any SEO question in the inimitable style of John Mueller, Search Advocate at Google.
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.
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.
Provide any plain English description e.g. “Indian wedding” and receive a colour palette inspired by your 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 a list of keywords by their conversion potential for your business.
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.
Some examples of using OpenAI’s Dalle-2 AI image generator for business applications.
That’s all for now!