Yes. The key is the user prompt. The less it needs to interpret what you want, the better job it can do. And it’s not a one-shot deal. Tweaking takes place. My single biggest tip: treat it like a human assistant or service vendor in terms of how you ask and explain things. It can be a difficult conceptual hurdle, but it can pay big dividends in the results
Not a spreadsheet, but an AI example from yesterday.
I use MyFlightBook for my logbook. I do the donation that gets my MFB data automatically uploaded to a cloud account daily as backup. Since even for a worst-case scenario, I can’t imagine needed to keep more than a few weeks worth, I’ve been going into my Google Drive periodically to delete old ones. I haven done that regularly, so there can be several months to clean up.
Google Apps uses an offshoot of JavaScript, “AppScript” (how original!), for coding. So, I thought, why not a script that runs weekly and deletes all the files in the MFB backup folder that are more than 30 days old.
It been ages since I’ve hand-coded, so I gave AI a try. We went through a few iterations, some based on changes I wanted; others on suggestions AI made (including automating the script, something I didn’t even know I could do). The script looks good and “seems” to work, but we’ll see how it goes.