# Guess which modules are missing from this process? OpenAI + Google Ads **URL:** \ **Category:** Knowledge Hub\ **Tags:** google-sheets\ **Created:** [June 19, 2023, 6:18am UTC](https://community.make.com/t/guess-which-modules-are-missing-from-this-process-openai-google-ads/12289 "2023-06-19T06:18:13Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Francisco\_Fontes](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/francisco_fontes/32/5314_2.png) [@Francisco\_Fontes](https://community.make.com/u/Francisco_Fontes)\ **Post date:** [June 19, 2023, 6:18am UTC](https://community.make.com/t/guess-which-modules-are-missing-from-this-process-openai-google-ads/12289/1 "2023-06-19T06:18:13Z")
> 🤖 Lee este artículo en español 🇪🇸 en LinkedIn: > [Comprender la intención de las palabras clave de los anuncios de Google con OpenAI](https://www.linkedin.com/posts/franciscodebritofontes_ppc-googleads-publicidad-activity-7076441080656736257-5rV9/) ## 🔍 Mystery Automation Game! **Guess which modules are missing from this process?** 🕵️‍♂️ > 🌟 **Hello to all automation and challenge enthusiasts!** > I will show you an automated process created in Make, and your goal will be to identify the modules and actions missing from the flow. ### Are you ready to participate? Please leave me your comments! 🎯 **Process** : «Understanding the intent of search terms in Google Ads campaigns» 😎 **Objective** : «Detect unwanted terms to add them as negative words» 🛠 **Tools used:** ⊙ **Make** : the automation platform. ⊙ **Google Ads** : Google’s advertising platform. ⊙ A **Google spreadsheet**. ⊙ **OpenAI** : using the GPT3 model 🔧 **Process description** : **1)** Every Monday at 7 AM, a Google spreadsheet is generated. **2)** Then, the list of clients and their Google Ads accounts are searched. **3)** For each client, the search terms of the previous week are searched. **4)** Each search term is classified according to its intent (commercial, transactional, or informational). **5)** This information is saved on a different sheet for each client in the generated form. 🔍 **And there you have an overview of the process!** > Now, I challenge you to tell me which modules or actions are missing from the image. > **Can you identify the parts that are not represented?** I look forward to your feedback and participation! Let the game begin. ![Artificial intelligence marketing agency](https://europe1.discourse-cdn.com/flex013/uploads/make/original/2X/0/092af1ffbf73e8120cc15c470043ddf33063d97c.jpeg) > **This is the result of executing the procedure** , 1 Google spreadsheet with several sheets; each sheet contains the list of search terms in a Google Ads account. ![1687156539591](https://europe1.discourse-cdn.com/flex013/uploads/make/original/2X/1/1149330c0d226472ff85e55fef3434697b6dec94.png) ---
**Author:** ![Michaela-Inactive](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/michaela-inactive/32/29_2.png) [@Michaela-Inactive](https://community.make.com/u/Michaela-Inactive)\ **Post date:** [June 19, 2023, 7:23am UTC](https://community.make.com/t/guess-which-modules-are-missing-from-this-process-openai-google-ads/12289/2 "2023-06-19T07:23:56Z")
Ohh wow, thanks a lot for putting this together @Francisco_Fontes, how exciting! 👏 Let’s see which curious mind will be the one to untangle this mystery! 🕵️‍♂️ 🔮 ![It Crowd Popcorn GIF](https://europe1.discourse-cdn.com/flex013/uploads/make/original/2X/7/7da4da4b02b0903897caa1a8f24b85f2f330798b.webp) ---
**Author:** ![system](https://europe1.discourse-cdn.com/flex013/uploads/make/original/1X/9786f7887a39f4a0fef4d09346ab5b54ce20222b.svg) [@system](https://community.make.com/u/system)\ **Post date:** [June 20, 2023, 7:00am UTC](https://community.make.com/t/guess-which-modules-are-missing-from-this-process-openai-google-ads/12289/3 "2023-06-20T07:00:05Z")
---
**Author:** ![optimal\_prime](https://avatars.discourse-cdn.com/v4/letter/o/d07c76/32.png) [@optimal\_prime](https://community.make.com/u/optimal_prime)\ **Post date:** [June 20, 2023, 7:05am UTC](https://community.make.com/t/guess-which-modules-are-missing-from-this-process-openai-google-ads/12289/4 "2023-06-20T07:05:20Z")
This is really interesting and much harder than it looks. I have the rough idea, but also I’m not sure exactly what the JSON and group modules are for. But I don’t use Sheets much. Anyways this is the process as I understand it: First you use the sheet name to look up the client’s account and then iterate through each of the keywords and save them to the client’s sheet in the B Column. Then you send each keyword to chatGPT to classify its intent. Then take the chatGPT keyword classification and then use the cellID (or some other identifier) of the keyword to determine where it should go (the row column is cellID-1). You must use the iterator to go process each keyword. ---
**Author:** ![system](https://europe1.discourse-cdn.com/flex013/uploads/make/original/1X/9786f7887a39f4a0fef4d09346ab5b54ce20222b.svg) [@system](https://community.make.com/u/system)\ **Post date:** [June 20, 2023, 12:52pm UTC](https://community.make.com/t/guess-which-modules-are-missing-from-this-process-openai-google-ads/12289/5 "2023-06-20T12:52:56Z")
---
**Author:** ![Runcorn](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/runcorn/32/9169_2.png) [@Runcorn](https://community.make.com/u/Runcorn)\ **Post date:** [June 20, 2023, 2:00pm UTC](https://community.make.com/t/guess-which-modules-are-missing-from-this-process-openai-google-ads/12289/6 "2023-06-20T14:00:53Z")
I am too tired to answer, but nice solution and approach nonetheless 😛 ---
**Author:** ![Francisco\_Fontes](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/francisco_fontes/32/5314_2.png) [@Francisco\_Fontes](https://community.make.com/u/Francisco_Fontes)\ **Post date:** [June 21, 2023, 10:42am UTC](https://community.make.com/t/guess-which-modules-are-missing-from-this-process-openai-google-ads/12289/7 "2023-06-21T10:42:40Z")
# I share the resolution of the game. ![Resultado-Juego_1-ingles](https://europe1.discourse-cdn.com/flex013/uploads/make/original/2X/4/4822804d7b84c0473b016aaf1aa16adfb9736acc.gif)