Free GPT-3 Sheets for Marketers

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.

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-]+)+”.

Sheet and instructions here.

 

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.

Sheet and instructions here.

 

 

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”.

Sheet and instructions here.

 

 

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.

Sheet and instructions here.

 

 

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.

Sheet and instructions here.

 

 

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.  

Sheet and instructions here.

 

 

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.  

Sheet and instructions here.

 

 

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.   

Sheet and instructions here.

 

 

Classify the conversion potential of keywords


Classify a list of keywords by their conversion potential for your business.

Sheet and instructions here.

 

 

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.

Instructions here 

That’s all for now!

Danny Richman