Free resources

Free Google Apps Script Snippet Library

Production-ready patterns you can copy, paste, and deploy in your Google Workspace. Each guide includes commented code and common edge cases.

• Send email when a row is added

  Trigger on new Sheet rows and send a personalized Gmail notification.

  View snippet & guide →

• Sync Google Calendar to Sheets

  Pull calendar events into a spreadsheet for reporting and dashboards.

  View snippet & guide →

• Connect Shopify to Google Sheets

  Fetch orders and inventory from Shopify Admin API into Sheets.

  View snippet & guide →

• Auto-generate PDF from Sheets

  Merge sheet data into a Google Docs template and export as PDF.

  View snippet & guide →

• Form submit → PDF invoice

  Create PDF documents automatically when a Google Form is submitted.

  View snippet & guide →

• Push Sheets data to webhooks

  Send row updates to external APIs or Slack via UrlFetchApp.

  View snippet & guide →

• Import JSON into Sheets

  Parse JSON API responses and write structured rows to a spreadsheet.

  View snippet & guide →

• Fix broken Apps Script triggers

  Diagnose and repair triggers that stopped firing.

  View snippet & guide →

• Zapier alternative with Apps Script

  Replace per-task automation fees with owned Apps Script workflows.

  View snippet & guide →

• Apps Script beginner tutorial

  Start from zero: triggers, SpreadsheetApp, and your first automation.

  View snippet & guide →