I would like to create a Google Ads automation. Specifically, I am thinking of generating a weekly report from Google Ads containing search terms that triggered my advertisements. This report would be sent to my email and then automatically transferred to Google Drive (or directly to Google Sheets). So far, I have successfully set up this process.
From there, I want ChatGPT to analyze the sheet containing search terms and identify irrelevant keywords. The output could be presented in a new sheet, a new tab, or by highlighting the irrelevant keywords. This way, I can easily create a base list of keywords to exclude. I have more than 50 ad groups in the campaign, so automating this process weekly will save me a significant amount of time and rapidly improve the account quality.
I can’t seem to figure out how to analyze the sheet, input it into ChatGPT, and export the irrelevant keywords
You need to use google sheet node take the row you need in batch (with loop) or just put results into openai node set a system prompt for categorize it and enjoy it 
Probably the problem is relative to huge mass of keyword categorizations? If yes,you most likely need to set a vector db and make embeddings of all keyword
@mredodos thank you for your reply.
I am not sure if I follow everything. Maybe this looked more easy than i anticipated. I am rather new in automations. Let me give it a try, thank you once again.
Im working on something very similar, a workflow for create automatically a seo blog posts for my blog from a list of keyword and faq
Nice! Smart idea.
Ill keep you updated as soon as I got it working.
I am doing something very similar and found this video to be really helpful 
Two key notes are that n8n now has native support for DeepSeek, and you may need to use a loop around OpenAI for rate limiting
Thanks for sharing, very interesting. Ill have a look 
