Free, simple automations from Sparehand that take repetitive work off a nonprofit team’s plate. Each one has a plain-language guide written for people who are not technical.
| Automation | What it does | Guide | Open the tool | Folder |
|---|---|---|---|---|
auto-emailer |
Sends a personal email to many people at once, using a list in a Google Sheet and a Gmail draft as the template. | Installation guide | Open NGO Auto Emailer | google-scripts/auto-emailer |
Our tools send anonymous usage counts (organization name and counts only). See Terms and Privacy.
If you use the sparehand-plugin with your AI assistant, ask it to help you install any automation above. It reads the latest guide from this repo and walks you through it step by step.
Pushing to main auto-deploys Apps Script automations (job deploy in .github/workflows/ci.yml, runs after the check job passes). It never runs on pull requests, so the secret is never exposed to them.
<group>/<name>/, e.g. google-scripts/<name>/, or a top-level <name>/) with a deploy.json are deployed. A folder is redeployed only when its deploy.json, appsscript.json, *.gs or *.html changed. Tests, docs and .md files are never pushed to Apps Script.clasp push --force and then clasp redeploy <deploymentId>, which updates the existing web-app deployment (same URL) with a new version described as ci <commit sha>.appsscript.json and the code overwrite whatever is online: edits made in the Apps Script editor are lost on the next deploy.Add a new automation
google-scripts/<name>/ (see “Adding a new automation” below) with appsscript.json, *.gs, *.html.google-scripts/<name>/deploy.json: {"scriptId": "...", "deploymentId": "..."} (both non-empty strings; script ID is in Project Settings).Secret CLASPRC_JSON: run npx @google/clasp@3.4.1 login, then save the full contents of ~/.clasprc.json as the repo Actions secret CLASPRC_JSON. If the Google OAuth app is in test mode the token can expire (about 7 days): run clasp login again and update the secret. A missing or empty secret fails the deploy with a clear message.
Run manually: Actions tab > ci > Run workflow on main; optionally enter a folder path (e.g. google-scripts/auto-emailer), blank deploys every automation with a deploy.json.
<group>/<name>/ (kebab-case, e.g. google-scripts/thank-you-letters/). Apps Script automations go in google-scripts/.INSTALLATION_GUIDE.md written for non-technical users. Keep pictures in <folder>/docs/images/.^[a-z0-9-]+$),INSTALLATION_GUIDE.md,https:// link to open the tool (or — if there is none),google-scripts/<name>.
Keep the 5 columns and the heading Automations unchanged.INSTALLATION_GUIDE.md must have a What you need section (the plugin reads it) and an Open the tool link that is an https:// link.The sparehand-plugin install-automation skill reads this table from
https://raw.githubusercontent.com/tejitpabari99/sparehand-auto/main/README.md, so a new row shows up for plugin users without a plugin update.