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 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-]+)+”.
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.
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.
That’s all for now!