This free Google Sheet and script suggests suggests new content topics based on articles that performed well for you in the past.
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.
Once you have used up your free OpenAI API credits, I estimate the API costs at approximately $0.08 per request.
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.