Thanks! 😃

Thank you. I really appreciate it.

I appreciate the feedback; thank you!

No, it's the first row that contains the headers, which we don't need to send to ChatGPT. So in your case you'll do .splice(0,6).

Is the Error coming from the OpenAI server? If so then you probably are not using the token they give you, or you are not passing it correctly in the Authorization header. Can you check?

@@benronkin it went well, in the end the problem was a missing semicolon lol

You can use npx clasp push -w which will automatically push to the IDE any time you save your file changes.

I'm happy that you found it useful. Let me know what other tutorials you'd like to see.

You can share the Apps Script file with specific people, just like you can do with Google Docs, Sheets, etc.

You could use the example of my google apps script to save the openai responses in a google sheet, and then you can import the sheet into data studio for analysis.

@@benronkin I got your point but how I will send search console data to the API so I will get desired response from it. I want to send data from google data studio (looker)

@@indianguy6683 I see your point. Give me an example of a ChatGPT prompt that will include search console data.

@@benronkin ok I have done some research on it. Search console provides data in json format so the prompt will be like - I am sharing google search console data with you and need to analyse it for seo purposes and provide me best suggestions in easy to understand way. {{ paste GSC data in json format here }} I have tested this prompt in chatGPT it works. Someone can write more customised prompt.

@@indianguy6683 Ok. I'll investigate and create a video tutorial on this topic. I hope to publish it tomorrow on the following day.

It's a quite involved process. I'll add that tutorial idea to my list. Thanks.

You can copy the code from my blog onto your own Google Workspace environment: benronkin.com/blog/use-chatgpt-api-with-google-apps-script.html

@@benronkin Ive got the code in the editor, API key in the correct place, folder ID in the correct place...and it isnt returning anything. Do I have to have the colum heading match the "features"? I have differnt data than you show here.

@@user-tu4jb6wx2c When you log the API response what do you see?

In its current form, I don't believe so. I tried to write a few code snippets with it, and there were a lot of issues. For one, it suffers from "hallucinations", where it "invents" methods that don't exist on certain objects, or it ignores specific instructions. Another issue is that to develop large code bases, you would need to give very specific and very detailed instructions, like pseudo-code, which limits the benefits of the AI. I think that ChatGPT is good for doing preliminary research on a programming domain that you don't have a lot of experience in. It can offer a starting point, and then you need to use your dev experience to make the code functional and robust. Just my two cents.

Do you mean something like this: kzfaq.info/get/bejne/jsBhiNei2pPNpok.html

Thank you. Have you tried to run it in Debug mode, going line-by-line and seeing what you're getting?

@@benronkin Thanks Ben - yes have done this. It still not executing consistently though

@@davidnorris8456 Check the response from OpenAI. Maybe it's an API quota issue.

Thanks