← Back to all products
$49
Google Apps Script Starter Kit
20+ Apps Script automations: email workflows, form processing, data sync, report generation, and calendar management.
MarkdownJSONGoogle SheetsExcel
Product Preview
Try the interactive reader and demo tools below, or get the full product with all content unlocked.
Interactive Reader (Free Preview) ⚙ Try Demo Tools Download Free SampleFile Structure 30 files
apps-script-starter-kit/
├── LICENSE
├── README.md
├── apps-script/
│ ├── auto-numbering.gs
│ ├── auto-reply-filter.gs
│ ├── availability-finder.gs
│ ├── backup-to-drive.gs
│ ├── calendar-sync.gs
│ ├── chart-to-slack.gs
│ ├── conditional-formatting-advanced.gs
│ ├── cross-sheet-lookup.gs
│ ├── daily-report.gs
│ ├── data-validation.gs
│ ├── digest-email.gs
│ ├── duplicate-detector.gs
│ ├── email-tracker.gs
│ ├── form-to-sheet.gs
│ ├── json-api-import.gs
│ ├── meeting-prep.gs
│ ├── pivot-summary.gs
│ ├── scheduled-reminders.gs
│ ├── send-bulk-email.gs
│ ├── sheet-to-pdf.gs
│ └── sheet-to-sheet-sync.gs
├── free-sample.zip
├── guide/
│ ├── 01_what-s-included.md
│ ├── 02_script-complexity-levels.md
│ └── 03_support.md
├── index.html
└── interactive.html
Documentation Preview README excerpt
Google Apps Script Starter Kit
A collection of 20+ ready-to-use Google Apps Script automations for Google Sheets, Gmail, Drive, Calendar, and Forms. Each script is self-contained, thoroughly commented, and works immediately after pasting into your Apps Script editor.
What's Included
Email & Communication (5 scripts)
| 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 |
Form & Data Processing (5 scripts)
| 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 |
Data Sync & Integration (4 scripts)
| 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 |
Reports & Export (4 scripts)
| 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 |
Calendar & Scheduling (3 scripts)
| 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 |
Utilities (3 scripts)
| 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 |
Documentation & Setup
| 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 |
... continues with setup instructions, usage examples, and more.
Content Sample guide/01_what-s-included.md
What's Included
This chapter covers the core features and capabilities of Google Apps Script Starter Kit.
What's Included
Email & Communication (5 scripts)
| 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 |
Form & Data Processing (5 scripts)
| 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 |
Data Sync & Integration (4 scripts)
| 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 |
Reports & Export (4 scripts)
| 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 |
Calendar & Scheduling (3 scripts)
| 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 |
Utilities (3 scripts)
... and much more in the full download.