Google Sheets Apps Script Starter Pack - 10 Scripts + Setup Guide

Add a custom "Sheet Helpers" menu to your Google Sheet with 10 plain Apps Script files and a 15-page step-by-step guide.

Untested in the google environment: the logic passes 24 automated Node.js tests against a mock of Google's services, but the scripts were not run inside Google Sheets or Apps Script. Try on a copy first.

What the scripts do

• Status emails: preview first, send once per row, per-run cap and quota check
• Dashboard: totals by category, counts by status
• Clean sheet: trims spaces, highlights duplicates, deletes nothing
• Overdue digest email, with optional daily trigger
• Last Updated stamp on edit
• Dated Drive backups, keeps the newest few

What is inside

• 10 .gs files with one Config.gs for names, columns and email wording
• Guide (PDF, DOCX, MD): install, permissions explained, quotas, troubleshooting, tested vs not tested
• Sample Tasks CSV with deliberate problems to practise on
• Node.js tests and mock (Node 16+)
• 4 AI prompts for adapting the code

Made for freelancers, studios and small teams who work in Google Sheets and can follow copy-paste steps.

Good to know

Needs a Google account. Gmail and Drive permissions are requested on first run. Google daily email limits apply. Send only to people who expect your emails. Not legal, data-protection or IT-security advice.