Google Ads Search Term AI Review Tool
Bulk review Google Ads search terms with the help of AI
[New tool here]
Find negative keywords in bulk 
How does it work?
2
Paste in your search terms
Get the terms your want the AI to review into the sheet.
3
Drag down + see magic ✨
Drag down the formula to get the results.
Want to receive updates on the progress of this script?
No spam, i promise!
How to use this tool?
To use this sheet you will need to make an account and copy your API key into the Settings tab of this sheet
- Copy the sheet above by clicking the button above (note there is a script in this sheet)
- Make Open AI accountÂ
- Get your secret API key: tutorial
Â
Settings Tab
- Paste your API key into Cell B2 of the Settings tab in the sheet
- Fill out the information on your target client in the Settings tab: Cell B3:B5
Â
Using the SEARCH TERM TOOL
Main AI Formula:Â =SEARCHTERM()
Clean result formula: =arrayformula(IF(B2:B=””,””,VALUE(B2:B)))
- Paste all your search terms in Column A
- Drag down the formula in Column B (slowly, if you do too many cells at once you may get an error)
- In Column B, the AI will return a number from 1-10 on how relevant it views the search term
- Column C cleans up this value and makes it easier to see red flags
Frequently Asked Questions
It may be because you sent too many requests to OpenAI (you dragged down too many cells).Â
The amount of requests you can use at once are limited by the openAI API right now (this is not ideal for bulk processing search terms ofc, but this tool is a proof of concept and now we just need a bit more power behind it).
I’m working on improving this, so that it never give an erorr.
You are sending too many requests to OpenAI. They are throttling your requests or you have used up you free token limit.Â
Note: OpenAI has a free trial limit on the number of requests you can send of $18, you might hit it.
Try copying the template again. Make sure you have added your secret API key and read through all the instructions above. Otherwise message me on Linkedin if it still doesn’t work.Â
No, downloading the sheet as an excel file.
It also won’t work if you download it & re-upload it.
