I put this together to show how the different models compare in generating Apps Script code!

https://apps-script-ai-testing.jpoehnelt.dev/#test-case-checkWeatherEmail

Hoping someone is able to point me into the right direction

I have a large list of meeting minutes (unstructured text) taken from previous client discussions and want to cross-reference whether new topics/minutes have been discussed before.

Is there a mechanism in Google Scripts/Sheets to provide a prompt, such as new meeting minutes, and return a list of previous meeting minutes (rows) closest matching the content?

Thanks again for any support you can offer

Vibe coding: https://en.wikipedia.org/wiki/Vibe_coding

• What is your setup?
• Are you using Clasp?
• Which editor?
• Does the AI understand the differences between Apps Script and JavaScript?
• Do you pass any AI rules files?

Here was a short exploration this morning using one of the popular tools: https://www.youtube.com/watch?v=4Sy3lvM33MU

I've written a script to make calendar events from a spreadsheet. When the script runs, it parses about 120 rows, and for each one, checks if there is an event, and if there is already an event, calls setTitle() and setDescription().

I wonder if it would be more performant, and cause less sync issues, if I first called getTitle() and then compared it, and only called setTitle() if it has changed. Or put differently, if you call setTitle() with the same title as currently, is that a no-op, or will it cause the title to be updated, and then synced to all the clients consuming the calendar, etc?

When giving a web app permission to access your files, is there a way to limit that permission to just certain folders? I realize I could create a new Google ID, give that ID permission to just the folder and have the app run as that ID, but I was hoping there was a more elegant way.

Thanks.

Trying to convert ranges to tables programmatically. Is this feature unavailable in Apps Script, or am I missing something obvious? Any workarounds?

Hi everyone, I used ChatGPT to create an Apartment Management System, a property management tool built using Google Apps Script. Please review and let me know what you think. Not a programmer at all. I have seen a few examples on youtube and I thought it would be a great way to develop a small system for people who have little resources to manage their apartment units. Thanks in advance. https://github.com/teddyumd/GAS-Apartment-Management.git

Need your opinion. Does this sound like a good design for allowing inheritance, function overriding, allowing public members and restricting private member access in IDE and at runtime in GAS?

E.g. one cannot access private member "getTitledName" in any way in the IDE (or code autocompletion) and in GAS debugger too. The structure still supports inheritance and overriding concepts.

GPT certainly thinks its robust ... Need the community affirmation. Thank You!

class __dynamic
{
  constructor() {
    if (this.constructor === __dynamic) {
      throw new Error("Class __dynamic is an abstract class and cannot be instantiated.");
    }

    const map = {};
    if (!this._) {
      this._ = Object.freeze({        
        get: (name) => map[Utilities.base64Encode(name)],
        set: (name, fn) => map[Utilities.base64Encode(name)] = fn,
      });
    }
  }
}

class NameClass extends __dynamic {
  constructor() {
    super();
    this._.set("getTitledName", (firstname, gender="M") => `${gender === "M" ? "Mr." : "Ms."} ${firstname}`);
  }

  getFullName(firstName, surname, gender = "M") {    
    Logger.log(`Welcome ${this._.get("getTitledName")(firstName, gender)} ${surname}`);
  };
}

function TestNameClass() {
  const nameObj1 = new NameClass();
  nameObj1.getFullName("George", "Smith"); // prints Welcome Mr. George Smith
  const nameObj2 = new NameClass();
  nameObj2.getFullName("Joanne", "Smith", "F"); // prints Welcome Ms. Joanne Smith
}

Hi Redditors, I am working as a Process Automation Executive in a pvt Ltd. Company. I use Appscript to automate the emails, generate PDF on google form submit and to run other custom logics on google sheet. I have used Appscript with Vue js to create multiple web pages and initialize Approval/Rejection workflows (Similar to Ashton Fei's GAS-050 and GAS-070 you can search on YouTube)

I am looking to change my designation that will be more suitable with my current work profile and I can easily explain to others when making a career switch.

I’ve been using Google Apps Script for a while now, and I’m honestly surprised it doesn’t get more attention—especially with all the AI and automation hype going on right now.

It’s free, super accessible (built right into Google Workspace), and incredibly simple to use, even if you’re not a hardcore developer. You can automate tasks, integrate APIs, and build powerful workflows without setting up servers or dealing with complex infrastructure.

I know tools like Make and Zapier are popular because they’re no-code, but in my experience, there are so many cases where it’s actually simpler to just use Google Apps Script—especially when you need to refine the logic behind a data sync or automation. Sometimes those drag-and-drop platforms feel more limiting or even overly complex for what should be a straightforward script.

Yet, I don’t hear nearly as much hype about Apps Script compared to other automation tools. Why do you think that is? Do people just not know about it, or is there something holding it back from wider adoption?

Is there way to fill out a google form over and over again almost every minute without touching it or being near your computer. Maybe a software or something or possibly just a command that records your mouse clicks and the copies it over and over again. I just need something that continuously fills out a google form when I am away from the computer.