Two days ago, I wrote about newsletter ideas based on your trending search terms. (A link to that will be provided below for your convenience).
In the email, I posed a challenge to you:
“…you can automate the ChatGPT part Caterina described as well. Simply extend the script with some code to feed the prompt and trending search terms to the ChatGPT API, and have the script send the email with the 10 newsletter ideas.”
Guess what?
Fellow script fanatic and PPC legend Frederick Vallaeys (Optmyzr) took on the challenge and created the automation for us!
“Blog Ideas from Trending Search Terms in Google Ads”
From the script comments:
/*
* The script finds search terms that have at least a minimum number of impressions
* in the past 7 days and have either increased by a specified multiplier compared to
* the previous 7 days or have gone from zero to meeting the minimum impression threshold.
* For the top 5 highest-volume trending search terms, it uses the OpenAI GPT API to
* generate blog post ideas.
* The script then compiles these ideas into an email and sends it to your specified
* email address.
*/Here’s the link to the script: https://gist.github.com/siliconvallaeys/0527249a7aee382db6360e50e4d7487a
Happy scripting!
– Nils
P.S. As promised, here’s a link to part 1: https://nilsrooijmans.com/daily/newsletter-ideas-based-on-your-trending-search-terms