← 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.
MarkdownGoogle 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 Sample📁 File Structure 28 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
📖 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.