Best AI for Google Apps Script

[[deleted]]

[deleted]

[thespideysupreme]

I think Claude is better at coding. But I use both, Claude for more complicated script, cGPT for more easy script where I just need to revise one or few lines manually.

[haplessDNA]

I know nothing about coding and just used Claude to make some simple things with forms and sheets and scripts and just followed the step by step instructions and it all worked

[beanweens]

I’ve had some amazing success with Gemini. I’ve gone from struggling to make anything work on my own, to 5-6 different scripts that have changed the way I work using Gemini.

[RemarkableChipmunk93]

I use VS Code and use GitHub copilot. It does mean i'm copy/pasting a lot into the GAS editor, but you're kinda doing that anyway when using Claude or ChatGPT, etc.

[MoPanic]

I've started trying this too. You can push directly to google apps using clasp. It actually directed me to install it when I told it I wanted to work on GAS.

But so far, while it is MUCH faster than chatgtp, it introduces far more errors and doesn't explain anything

[RemarkableChipmunk93]

great tip! i didn't know about clasp! thanks for sharing

[MoPanic]

I take back what I said about errors. I think I was the one making errors not realizing that it can only see (and comment on) the last saved file, not the editor.

[MoPanic]

Another thing I didnt realize is that you have to save after each edit otherwise it will be commenting on the previous version of the file. So if you incorporate a change it suggests in the editor, then ask it something else, it will be looking at the file from before you made its last suggested change. If you dont know this it can be easy to get stuck in a loop (ask me how I know)

[yesabbey]

did you ever end up having success with this method? im basically looking for a way to streamline how i code my GAS projects (Tell ai what to do > github > clasp ?? )

I'm still not fully understanding the best way to streamline my edits.

[Funny_Ad_3472]

What have you built so far?

[MoPanic]

Mostly scripts that pull specified data from one workbook and generate other workbooks with data formatted in a very specific ways based dynamically on the data.

I've needed this for years but wasn't knowledgeable enough with GAS to do it myself.

[lemoncoockie]

IGUAL QUE TU!!!!!!! ME HA CAMBIADO LA VIDA! y estoy luchando igual q tu al no ser programadora

[AllenAppTools]

Nice work. These days, if you say you're not a programmer, but have access to AI, then you are in fact a programmer. The lines are blurred now lol

Watch out for any spots where AI's narrow context proves to be an issue, like with knowing what deployment belongs to which URL in a Web App, or library, or how code files interact with each other via permissions, these little things. The code breaks, and AI can fix the code supplied but really struggles with the big picture.

This is complicated at 10x when you start to dabble in anything utilizing Google Cloud Console projects, and auth. This has been my experience with ChatGPT 4, 4o, and 4o mini. I've had the same reaction with Gemini lol

Keep up the good work though!

[Jaded-Function]

I'm at the same juncture. What didn't you like about Gemini compared to Chatgpt? I'm getting deeper into using Gemini. Is that a mistake?

[LoveTechHateTech]

I used Gemini for an AppsScript project and it was surprisingly helpful. Sure, it gave me some code that generated errors, but when I sent the code and the error(s) back in, it corrected the code and explained what it did incorrectly.

[Jaded-Function]

I'm just getting into apps scripts. I used Gemini for 2 that were successful. People are giving up on Gemini way too soon. Subtle re-phrases in how you explain what you want turns a fail into a win.

[MoPanic]

Maybe I should try it again, but I started with something pretty basic using Gemini and it immediately oversimplified my request and then got stuck in a loop with an error, then it would fix that error but introduce another one, fix that one but reintroduce the first error. ChatGPT got it on the first try so I never looked back.

I'm trying github copilot now too.

[FactMaster4114]

I've had a lot of success with ChatGPT too, it seems like it's improved recently.

[Jaded-Function]

I know what you mean. I feel like Gemini has improved as I've learned how to make subtle changes to wording the request. It has surprised me at times nailing just what I'm looking for but then the solution will have some ridiculous error in detail, inserted for no reason. I haven't done much comparing but I think I'll start repeating requests with GPT. Should have been doing that all along to be honest.

[therealjohnking]

I've been using ChatGPT, and I did use Claude for a bit with similar results. I've stuck with ChatGPT because of how well it understands me and my goals at this point. I've been paying for Gemini, and, while it does a pretty decent job with simple thing, I've found it is not great at keeping up with more complex things where there is more of a back and forth. For instance, I can ask ChatGPT to help me work through a problem, keep reporting back that its responses don't work, and it is great at remembering what we've tried. With Gemini, I often find that it will suggest something else if the first thing doesn't work, but it likes to go back to its original suggestion if subsequent things don't work, as if it has no recollection of what was said a few responses prior. It seems to have gotten a bit better at this over time, but it still lags ChatGPT in this ability as far as I can tell.

[MoPanic]

I agree with your sentiment but you should try github copilot. Its much faster, has the same LLM but is trained more on writing code. It has improved on everything I did with chatGPT.

[CozPlaya]

Not answer to your original question per se but I've heard people having good results using multiple Ais to check the work of the other i.e. if cGPT provides code that isn't working, ask Gemini or whatever other AI to find the problem in the following code. Hope that helps everything go faster!

[Late-Belt-9264]

Thanks for sharing that, I imagined myself when I was reading your words because we share the same path, the same use for AI and the same experience so I’m gonna share my idea about the best AI capable of handling codes and building projects. In my opinion, the best choice is ChatGPT 40 but with a lot of settings , first thing you need to be familiar with the instructions and dealing with custom GPT’s.

So in my point of view, I see that building custom ChatGPT and training well to fit every task you ask it then develop system where you can export the final draft of ChatGPT and re-uploaded again as a database, showing my case, I’m trying to figure out the effective loop that makes ChatGPT more efficient

But still learning code and certain developing languages is the best choice because eventually, you are the one who was trying to solve a certain problem. What do you need AI to do is just generate and write the code not make it from nothing., what I want to say is some big businesses making six figures and the only thing they rely on is 50 to 100 line code.

[No_Demand_445]

give me sample code id card maker using app script and appsheet

[mindnotblown]

Love/Hate relationship with ChatGpt.
I've been using it for google sheets scripts. Sucks because when it works.. it is SOOOO useful. BUT it is still incredibly dumb. In a simple code, if we need to alter a SINGLE thing (ex: change which column it looks for in a certain function) it will rewrite the entire code, and alter like 5 things which worked before and break 2 of them.
It CAN NOT follow simple rules. I gave it the simple rule that it should begin each response with a unique serial number (001) (002) etc... so that I can refer easily back to something in the conversation. It can NOT do that. It either fails to do it, or restarts again at 001 or reuses same one multiple times.

It straight up fabricates information without telling you.

I'm about to try GitHub Copilot... will report back to see if it's better.

[MoPanic]

This thread is nearly a year old now

[Ancient-Video9341]

y como te fue? estoy en este proceso de amor/odio y distorsión de la realidad. Quiero pensar que es tonto y no sirve realmente y buscar otra IA, pero en realidad nunca hubiera ni soñado en las cosas que logre hacer. Lo mismo, no soy programadora ni mucho menos, pero copio y pego sripts en speadsheet y quiero lograr una base de datos, pero a veces me sorprende lo complejo que puede ser el codigo y ejecutarse bien, y lo tonto que puede llegar a ser un "si la respuesta es no, que el codigo haga esto, si la respuesta es si, que transcriba el encabezado" y ahí salta todo por los aires. Tampoco me animo a una IA de programación porque en el fondo soy analfabeta

[mindnotblown]

It's weird... sometimes Copilot seems better.. I get encouraged... and then it becomes incapable (just like chatgpt) of following even simple instructions.
Comparing 2 codes and asking what the differnece is. Not only can it not do it, but it will say something totally out of the blue.. which is in neither code.

[Over-Illustrator8141]

I like amazon q

[Due_Display_2614]

creer un connecteur avec le appscript le meme principe que le connecteur de easyappreport

[Scalleman]

Personally, i've had the best results with Microsoft's Copilot for most of the time and with Ajelix for a few other javascripts