This chapter covers the core features and capabilities of Google Apps Script Starter Kit.
| File | Description |
|---|---|
apps-script/send-bulk-email.gs | Send personalized emails to a list from Sheets (mail merge) |
apps-script/email-tracker.gs | Track email opens with a tracking pixel |
apps-script/scheduled-reminders.gs | Send reminder emails based on date conditions |
apps-script/digest-email.gs | Weekly digest of spreadsheet changes |
apps-script/auto-reply-filter.gs | Auto-categorize and reply to incoming emails |
| File | Description |
|---|---|
apps-script/form-to-sheet.gs | Process form submissions with validation and notifications |
apps-script/data-validation.gs | Validate sheet data against rules and flag errors |
apps-script/auto-numbering.gs | Auto-generate sequential IDs on new row insertion |
apps-script/duplicate-detector.gs | Find and highlight duplicate rows |
apps-script/conditional-formatting-advanced.gs | Dynamic formatting beyond built-in rules |
| File | Description |
|---|---|
apps-script/sheet-to-sheet-sync.gs | Sync data between spreadsheets on a schedule |
apps-script/json-api-import.gs | Pull JSON data from any REST API into Sheets |
apps-script/cross-sheet-lookup.gs | VLOOKUP across multiple spreadsheets |
apps-script/backup-to-drive.gs | Automated spreadsheet backups to Drive folder |
| File | Description |
|---|---|
apps-script/daily-report.gs | Auto-generate and email daily summary reports |
apps-script/sheet-to-pdf.gs | Export sheets as formatted PDFs to Drive/email |
apps-script/chart-to-slack.gs | Generate chart images and post to Slack webhook |
apps-script/pivot-summary.gs | Auto-refresh pivot summaries on a schedule |
| File | Description |
|---|---|
apps-script/calendar-sync.gs | Create/update calendar events from sheet rows |
apps-script/meeting-prep.gs | Auto-generate meeting prep docs from calendar |
apps-script/availability-finder.gs | Find common free time across multiple calendars |
| File | Description |
|---|---|
apps-script/sidebar-ui.gs | Custom sidebar interface with HTML/CSS |
apps-script/custom-menu.gs | Add custom menu items to your spreadsheet |
apps-script/sheet-protection.gs | Dynamic sheet/range protection based on user roles |
| File | Description |
|---|---|
docs/SETUP.md | How to add scripts, set triggers, authorize scopes |
docs/IMPORT-GUIDE.md | Importing scripts into existing spreadsheets |
docs/CUSTOMIZATION.md | How to adapt each script to your needs |
docs/GETTING-STARTED.md | Your first automation in 5 minutes |
formulas/FORMULAS.md | Companion formulas that work with the scripts |
sheets/script-inventory.csv | Reference sheet tracking all scripts and their triggers |
1. Open any Google Spreadsheet
2. Go to Extensions → Apps Script
3. Delete the default myFunction() code
4. Paste the contents of any .gs file
5. Save (Ctrl+S)
6. Run the function (click â–¶ or set up a trigger)
7. Authorize when prompted (see docs/SETUP.md for scope details)
Follow this guide to get Google Apps Script Starter Kit up and running in your environment.
| Level | Scripts | Who It's For |
|---|---|---|
| Beginner | auto-numbering, custom-menu, form-to-sheet | First-time scripters |
| Intermediate | send-bulk-email, daily-report, calendar-sync | Comfortable with Sheets formulas |
| Advanced | json-api-import, sidebar-ui, sheet-to-sheet-sync | Some programming experience |
These scripts are Google Sheets only — they use the Google Apps Script runtime (based on JavaScript) which has no Excel equivalent. However:
formulas/FORMULAS.md includes Excel alternatives where possiblesheets/script-inventory.csv can be imported into Excel for referenceGet the full Google Apps Script Starter Kit and unlock everything.
Get the complete guide with every chapter unlocked, including code samples, diagrams, and best practices.
Access all interactive tools with complete data, all workload profiles, and the full scenario library.
Downloadable source code, configuration files, and working examples from every chapter.
Free updates for life. Every new chapter, tool, and improvement included.