This free Google Sheet and script suggests suggests new content topics based on articles that performed well for you in the past.

Watch this video for a demo:

Pre-requisites

1) Open an account with OpenAI.com. You will receive $18 worth of free tokens as a first-time user.

2) Make a copy of this Google Sheet to your own Google account.

What does it cost?

Once you have used up your free OpenAI API credits, I estimate the API costs at approximately $0.08 per request.    

How can I use it?

Follow the instructions in the video included above.

Take a look at the code behind this function by clicking Extensions > Apps Script from the main menu and feel free to adapt it to different use cases. All of the code was generated by GPT4.

Note: If you use this script to evaluate a competitor’s website, it will not be able to scrape the page titles if the site is blocking all unknown bots.

Although I can’t offer individual support for this free script, please let me know if you run into any bugs or have thoughts on how the script could be adapted.

Check out this list of other GPT-3 scripts I have released and feel free to follow me on Twitter to hear about new releases.

Enjoy!

Updated 2nd June 2023 – Version  2.3

• Added an option to choose between OpenAI models as not everyone has access to GPT-4 yet.
• Added better error reporting if the API request fails.