← Back to all products

Google Apps Script Starter Kit

$49

20+ Apps Script automations: email workflows, form processing, data sync, report generation, and calendar management.

30 files
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 Sample

File 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)

FileDescription
apps-script/send-bulk-email.gsSend personalized emails to a list from Sheets (mail merge)
apps-script/email-tracker.gsTrack email opens with a tracking pixel
apps-script/scheduled-reminders.gsSend reminder emails based on date conditions
apps-script/digest-email.gsWeekly digest of spreadsheet changes
apps-script/auto-reply-filter.gsAuto-categorize and reply to incoming emails

Form & Data Processing (5 scripts)

FileDescription
apps-script/form-to-sheet.gsProcess form submissions with validation and notifications
apps-script/data-validation.gsValidate sheet data against rules and flag errors
apps-script/auto-numbering.gsAuto-generate sequential IDs on new row insertion
apps-script/duplicate-detector.gsFind and highlight duplicate rows
apps-script/conditional-formatting-advanced.gsDynamic formatting beyond built-in rules

Data Sync & Integration (4 scripts)

FileDescription
apps-script/sheet-to-sheet-sync.gsSync data between spreadsheets on a schedule
apps-script/json-api-import.gsPull JSON data from any REST API into Sheets
apps-script/cross-sheet-lookup.gsVLOOKUP across multiple spreadsheets
apps-script/backup-to-drive.gsAutomated spreadsheet backups to Drive folder

Reports & Export (4 scripts)

FileDescription
apps-script/daily-report.gsAuto-generate and email daily summary reports
apps-script/sheet-to-pdf.gsExport sheets as formatted PDFs to Drive/email
apps-script/chart-to-slack.gsGenerate chart images and post to Slack webhook
apps-script/pivot-summary.gsAuto-refresh pivot summaries on a schedule

Calendar & Scheduling (3 scripts)

FileDescription
apps-script/calendar-sync.gsCreate/update calendar events from sheet rows
apps-script/meeting-prep.gsAuto-generate meeting prep docs from calendar
apps-script/availability-finder.gsFind common free time across multiple calendars

Utilities (3 scripts)

FileDescription
apps-script/sidebar-ui.gsCustom sidebar interface with HTML/CSS
apps-script/custom-menu.gsAdd custom menu items to your spreadsheet
apps-script/sheet-protection.gsDynamic sheet/range protection based on user roles

Documentation & Setup

FileDescription
docs/SETUP.mdHow to add scripts, set triggers, authorize scopes
docs/IMPORT-GUIDE.mdImporting scripts into existing spreadsheets
docs/CUSTOMIZATION.mdHow 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)

FileDescription
apps-script/send-bulk-email.gsSend personalized emails to a list from Sheets (mail merge)
apps-script/email-tracker.gsTrack email opens with a tracking pixel
apps-script/scheduled-reminders.gsSend reminder emails based on date conditions
apps-script/digest-email.gsWeekly digest of spreadsheet changes
apps-script/auto-reply-filter.gsAuto-categorize and reply to incoming emails

Form & Data Processing (5 scripts)

FileDescription
apps-script/form-to-sheet.gsProcess form submissions with validation and notifications
apps-script/data-validation.gsValidate sheet data against rules and flag errors
apps-script/auto-numbering.gsAuto-generate sequential IDs on new row insertion
apps-script/duplicate-detector.gsFind and highlight duplicate rows
apps-script/conditional-formatting-advanced.gsDynamic formatting beyond built-in rules

Data Sync & Integration (4 scripts)

FileDescription
apps-script/sheet-to-sheet-sync.gsSync data between spreadsheets on a schedule
apps-script/json-api-import.gsPull JSON data from any REST API into Sheets
apps-script/cross-sheet-lookup.gsVLOOKUP across multiple spreadsheets
apps-script/backup-to-drive.gsAutomated spreadsheet backups to Drive folder

Reports & Export (4 scripts)

FileDescription
apps-script/daily-report.gsAuto-generate and email daily summary reports
apps-script/sheet-to-pdf.gsExport sheets as formatted PDFs to Drive/email
apps-script/chart-to-slack.gsGenerate chart images and post to Slack webhook
apps-script/pivot-summary.gsAuto-refresh pivot summaries on a schedule

Calendar & Scheduling (3 scripts)

FileDescription
apps-script/calendar-sync.gsCreate/update calendar events from sheet rows
apps-script/meeting-prep.gsAuto-generate meeting prep docs from calendar
apps-script/availability-finder.gsFind common free time across multiple calendars

Utilities (3 scripts)

... and much more in the full download.