To get Chat GPT on the spreadsheet, we open the spreadsheet, and click Extension.
Then select App Script, when the interface appears, just copy the whole code (link here: https://github.com/lehuyducanh/ChatGPT-GoogleSheet). Also, add the API Key at line 13: const API_KEY= “ “ press save, and then you can use ChatGPT right on Google spreadsheet.
Type the command “=runOpenAI(…;…) the command will return the correct answer.
For example, if you need to make TVC for pizza, the command will return you 3 ideas to make TVC, which can be dragged down like a normal SUM statement to do many other parts.
Or you can run a question-like statement like =runOpenAI(“list 10 popular colors”). From there, ChatGPT will give the appropriate answer.