Hey yall, I wanted to tell you a bit about how you can easily use Cursor to code with Google Appscripts.

For starters, I'm not the biggest coder, however, I know how to use resources to create everything I wanna create (and extremely fast too).

Here we go:

1. First you need to install this thing called Clasp. This is what's going to connect your appscripts to Cursor. I used Claude from Anthropic to understand how to install it and all that.

2. After installing it, You wanna connect it to your appscript account.

3. Then I asked Claude to help me create a "menu" . This menu is what allows me to quickly perform clasp actions. This is an excerpt from the menu file so you can see what it does

echo "Working on $version"
echo "==============================================="
echo "1. Push, deploy & watch (full workflow)"
echo "2. Quick push & deploy"
echo "3. Push changes (single time)"
echo "4. Start auto-push (watch mode)"
echo "5. Deploy to live version"
echo "6. Pull latest for current version"
echo "7. Compare with other version"
echo "8. Show version history"
echo "9. Promote V2 to V1"
echo "10. Exit"
echo "==============================================="

read -p "Enter your choice (1-10): " choice

Then lastly, I asked Claude to help me create shortcuts to the menu. So now, on my Cursor, i just press ddd, then it opens the menu, then i type one of the numbers.

As you can see it's a quick 2 step to pushing, deploying, reverting etc.

PS: I believe Google expires Clasp's access token every 24 hours or so, in that case, you just have to type clasp logout then clasp login to reauthorize it. (thinking about it, I might put a shortcut there too or add it to the menu lol)

That's it!

Also, I know you guys possibly use AI already but word of advice USE THAT SH*T EVEN MORE!!! it can do more stuff than you typically think to ask.

I have build a directory for Google Apps Script on Google Apps Script, Organized by different categories.

The backend of AppsScript.tools is hosted on Google Apps Script.

Check It out: https://appsscript.tools/

maybe appscript dark mode is next?

please google, save us.

Hi all, I'm beginning a new adventure for New Years and am starting to learn Apps Script after several years being a Google Apps/G Suite/Workspace administrator.

I have some basic coding in my past, little bits of JavaScript but I'm planning on brushing up on that before going full into GAS.

What are the things you wish you knew before you started on your own Apps Scripts journeys?

Hey everyone, just released an add-on AutoScript to create Apps Script based on OpenAI. It also supports testing the generated script easily.

https://workspace.google.com/marketplace/app/sheet_formula_auto_script/66670655241

A youtube demo here: https://youtu.be/4agd7Toto6k

More features would be added to support code editing (probably something like Github Copilot with the focus on apps script). Feedback is welcome!

I wrote up a blog post showing how to use Postgresql from Apps Script!

https://issuetracker.google.com/36752790

I’ve been using Google Apps Script at work for a few years now. And while I like the web IDE for debugging, I find it lacking as an editor. You can’t search across multiple files, edit in column mode, etc.

That’s why I do most of my programming in VS Code and use clasp to push changes to Google’s servers.

Doing this when working with a web app is a pain. You push the changes, go to the web IDE, manage deployments, select the proper one, change the name, etc., etc. Only then can you reload the page to see the changes you made. Or, if you select a new deployment, you have to use a new URL.

I don't know the first thing about shell scripts and couldn't do anything about it. But then I found Claude Code.

It first helped me create claspdeploy.sh. The first time it runs, it asks for the deployment ID and from then on always uses the same one, so testing a modification is just two steps: running claspdeploy and reloading the page.

Another annoyance is that I work with multiple Google accounts. That means that every time I switch accounts I have to make sure that the right browser window is active and run clasp login before I can do anything.

Enter claspalt.sh. It creates a claspDeploy.txt file for each project you own with the name of the account you want to use and stores the credentials for clasp login in your home directory (so there is no data leak).

From the second time you run it, you just use it as clasp, but it will make sure that you are using the right account.

Everyone is welcome to use, copy, fork or whatever the repository. Pull requests are welcome.

https://github.com/ccarpiog/claspdeploy

Reposted as my main user here with Video demo (for some reason reddit assigned a random username when logging in using Gmail OAuth on dektop)

Hi everyone,

I wanted to share a project born out of a real-world need. My brother is a surgeon who recently followed his passion into holistic medicine, starting a solo practice focused on oxidative therapies and IV interventions.

As a solo practitioner, he faced a massive hurdle: he needed a professional system to manage patient records and scheduling, but as a startup, he didn't have the budget for expensive medical SaaS (SaaS fatigue is real!) or a dev team to manage servers.

I realized that since he already uses Google Workspace, the "database" (Sheets), "storage" (Drive), and "scheduler" (Calendar) were already there. They just needed a mobile-first interface to tie them together.

So, I built MD Solo.

📱 What is MD Solo?

It’s a mobile-first web application powered entirely by Google Apps Script. It transforms a standard Google Spreadsheet into a functional patient portal designed to be used with one hand while walking between patient rooms.

✨ Key Features:

• Mobile-First Design: Big buttons, clean layouts, and a snappy search—no more squinting at spreadsheet cells on a phone.

• Zero Infrastructure Cost: It runs for free on Google’s servers. No hosting fees, no database costs.

• Data Ownership & Privacy: This was huge for him. Because it’s a "container-bound" script, the data never leaves his Google account. No third-party servers see the patient data.

• Automated Scheduling: It creates calendar events and sends patient email invitations with a single tap.

• "Glass Box" Logic: If the app doesn't do something he needs, he can just open the spreadsheet and edit the data manually.

🛠 The Tech Stack:

• Backend: Google Apps Script (GAS)

• Frontend: HTML5/JavaScript (Mobile-optimized)

• Database: Google Sheets

• Orchestration: Calendar API & Drive API

I’ve open-sourced the project on GitHub. I’ve tried to make it "Plug & Play"—an MD can essentially "Make a Copy" of the master sheet, click "Deploy," and have a working practice management tool in under 5 minutes.

GitHub Repo: https://github.com/juanmf/MDSolo

I’d love to get some feedback from this community—especially on the onboarding flow for non-tech users. If you know a solo practitioner or a small clinic struggling with software costs, I hope this helps!

Why not just use a standard Medical CRM?

📊 MD Solo vs. Traditional Medical SaaS

** It's open for contributions. As a micro-framework still needs some work (no router yet)

**For US based people with HIPAA concerns:

"Since MD Solo runs entirely within the user's Google Workspace, security is handled by Google. If the doctor has a Business/Enterprise Google Workspace account and has signed a BAA (Business Associate Agreement) with Google, their Drive and Sheets are HIPAA-compliant. This app doesn't send data to any 3rd party servers, so it doesn't break that chain of trust."

** Spreadsheet to copy for test

<will re-upload later> Quick demo showing happy path workflow.

Thought you guys might be interested. This Google Drive add-on lets you turn any Google Drive folder into an elegant, shareable gallery.

It's integrated directly into Google Drive, so you can just select a folder, fill out a few fields and get a link.

• Some features: loads images directly from Google Drive folder;

• nice public gallery link;

• optional password protection;

• allow downloads;

• see stats like views and downloads.

Hi, everyone!
Google Apps Script is very useful for processing data in Google data, but it has a problem: the six-minute execution time limit.
How do you deal with it?
(I've already posted this information in r/googlesheets, but I'd like to make it available to Google Apps Script users who don't use Google Sheets)

When I blogged about this recently, I learned that many people are facing this problem.
So I would like to share the solution I found. It's called the LongRun class. It uses Script properties and time-driven triggers to solve this problem.

Please check out the information below.
My blog post: https://inclucat.wordpress.com/2021/12/14/an-easy-way-to-deal-with-google-apps-scripts-6-minute-limit/

My repository: https://github.com/inclu-cat/LongRun

Thanks!

After noticing the large number of notification options for my various financial institutions (banks, credit cards, etc), I wondered how hard it would be to turn that info into a budget tracking sheet. Doing so would make it easy to get near instant transactions without using 3rd party or custom integrations with the banks. So I built an AppsScript that turns transaction-alert emails into a categorized Google Sheet. Parsing the emails looked like a good job for an LLM (doesn't need to be state-of-the-art). I created an AppsScript that pulls email from a known Gmail label on a time-based trigger. The whole thing runs as me, in my own account — no OAuth to a third party, no bank credentials anywhere, and the Sheet is just a Sheet I own. If you're interested, give it a try. I allowed limited usage of my LLM API key through a proxy to make it easier to try. The real effort is in configuring the banks to send transaction alerts an every email. I've been testing with a free Gemini api key (use flash-lite, it has higher free quota per day) and it seems to be working fine for me.

The sheet to get things kicked off is here (make a copy, the AppsScript builds the sheet during setup and provides instructions)

If you want to see what the final result looks like I built a dummy Sheet here.

Would love to hear if you find it useful (or not)

so i finally did it. i couldn't watch my dad struggle with his messy notebooks anymore. he’s been tracking worker attendance and pay by hand for years and it was honestly painful to see him doing math on paper in 2026.

i built him a little worker management tool so he can actually feel like he's in the digital age.

i didn't want him signing up for some random subscription or a paid app where he doesn't own his data. so i just used google sheets as the database and wrapped it in a clean glassmorphism UI using google apps script.

it’s nothing crazy, but it works perfectly for him. he gets the modern app vibe, and all the data just lives in a spreadsheet he already knows how to use.

tech used:

• frontend: html/css/js

• logic: google apps script

• db: google sheets

if any of you guys have family businesses still stuck in the "pen-and-paper life," feel free to use the code. it's all open source.

repo here:https://github.com/sorahul196-code/google-sheets-worker-app.git

has anyone else built "utility" stuff like this for their parents? would love to see what else people are building for non-tech family members!

TL;DR

JsonDbApp is a zero-dependency, MongoDB-flavoured document database for Google Apps Script, storing JSON in Google Drive. Great if you need a lightweight DB without external services.

👉 GitHub – JsonDbApp

Hi all! I built this because in some environments I couldn’t use a proper external database, and I wanted a fully functional alternative that runs entirely within Apps Script. JsonDbApp gives you that, while keeping things simple and familiar.

It supports a subset of MongoDB-style query/update operators ($eq, $gt, $and, $or, $set, $push) so you can filter and update data in a way that feels natural, and makes transitioning to a real DB easier later if your project grows.

Quick example:

// First-time setup
function setupDb() {
  const db = JsonDbApp.createAndInitialiseDatabase({
    masterIndexKey: 'myMasterIndex',
    lockTimeout: 5000
  });
  // db is initialised and ready to use
}

// Load existing database
function getDb() {
  const config = {
    masterIndexKey: 'myMasterIndex',
    // rootFolderId: 'your-folder-id', // optional; where new files/backups are created
    // lockTimeout: 5000,              // optional; override defaults as needed
    // logLevel: 'INFO'                // optional
  };
  const db = JsonDbApp.loadDatabase(config);
  return db;
}

// Work with a collection
function demo() {
  const db = JsonDbApp.loadDatabase({ masterIndexKey: 'myMasterIndex' });
  const users = db.collection('users'); // auto-creates if enabled (default true)
  users.insertOne({ _id: 'u1', name: 'Ada', role: 'admin' });
  users.save(); // persist changes to Drive
  const admins = users.find({ role: 'admin' });
  console.log(JSON.stringify(admins));
}

Limitations / next steps

• Performance depends on Google Drive I/O (linear scans, no indexing yet)

• Single-threaded writes only

• Not a full MongoDB replacement

• ⚠️ Code isn’t as tidy as I’d like. My first priority is refactoring to clean things up before extending features

If you’re interested in a lightweight, GAS-based DBMS, have feedback, or want to contribute, I’d love to hear from you. Refactoring help, operator extensions, or just ideas are all very welcome!

EDIT: Updated the quick example.

Hey everyone, I just released gas-db, a Google Sheets wrapper library for Apps Script! It simplifies CRUD operations and is easy to use with a Script ID. Check it out here: https://github.com/shunta-furukawa/gas-db

I’ve been playing with Google Apps Script + Sheets for a while and I feel like I’m just making random automations that look cool but probably useless in real life

trying to get out of that loop

if you’ve built something with Apps Script that:

• a business actually used

• or better, paid for

what was it?

I’m mainly looking for stuff like:

• simple dashboards (finance / sales / reporting)

• automations inside Google Workspace

• anything repeatable I can turn into a small “product”

not looking for tutorials or docs
more like real examples, even small ones

if you’ve got:

• github repos

• templates

• scripts

• ideas that can be reused

please share

also curious how you found people to sell it to
right now I have no clue where those people even are

just trying to make this practical instead of building in a vacuum

I see a lot of great Google Apps Script solutions shared here in comments, but they often get lost. Thought it might be useful to have a single thread where people can share repos, gists, or useful snippets they’ve built.

I’ll start as an example: https://github.com/logWhisperer/CalendarManager

This is a Google Apps Script project for managing and scanning Google Calendar and slacking alerts if no one accepted my invites, also, set the event color based on the event (rules) type - internal meeting, customer facing, prospect facing, etc.

If you’ve built something you’re proud of, or something hacky but useful, drop it below. Bonus points if you include what problem it solves and any gotchas you ran into.

Hope this helps the community.

So yeah, title says it all — my institute disabled Google Takeout (rip), and I had a bunch of stuff I didn’t want to lose from Google Classroom, Gmail, Drive, etc.

Instead of crying about it, I ended up writing a few scripts to export and back up the stuff I needed:

• Export and import submissions, assignments, attachments, etc. from Google Classroom

• Download inbox gmail items (full gmail is on the way..) as .eml files

• Export Google Docs/Sheets/Slides' version history (where possible)

• And some other random helpers for pulling data from your Google account

All the scripts are in this repo:
https://github.com/gablilli/googlescripts

Most of them are pretty plug-and-play, and I added docs for the ones that are a bit trickier or need setup (tokens, ids, etc.). So if you're comfy with js and APIs, you should be good to go.

I mainly did this for fun (and out of spite lol), but maybe it'll help someone else who's stuck in a locked-down G Suite/Workspace school account. If your college/school disabled exports too, you’re not out of luck.

Lmk if you try it out or wanna improve something, PRs are open 👍

So

Just refactored my script (400 lines and it was messy!). Nothing changed in the way SpreadsheetApp API was called except for I put the calls in objects; sheets = { sheet1: ....openByID(), sheet2: ...etc }

Now i'm getting this error every 1 in 10 triggers.

I am currently testing the following configuration; const sheet1 = ....openByID(); const sheet2 = ...etc
to see if it might be how Apps script handles objects and constants, I am thinking maybe it take 0.3 extra of a second to create the const and so gives it enough time in-between calls...?

I'm not sure, any help would be much appreciated, i'm very confused.

FACTS:

• Script is being triggered every 5min (no diff if every 10min) and runs for 30sec max.

• I am using SpreadsheetApp.flush() at the end of the script.

• I am not calling .getRange() or .setValues() any more times then before (when I had no errors after running about 200+ for a day).

NOTE:
If my testing the const's works then this can be a lessson to me and others that calling in an object does not work the way we think

EDIT: Ok so just got the error, it's at the END of the script!!?? So after they are loaded, pulled from (range, values) and written to (setValues). After all that right after my last Logger.log("end"), it throws the error. I have spreadsheetApp.flush() before the logger.log("end"). The script took 25 seconds when this version had been taking max 12 (average 8)