Learn how to use Google Apps Script to automatically generate formatted Google Docs reports from data in Google Sheets. Build mail-merge style documents at scale.
Read more →Use UrlFetchApp in Google Apps Script to pull live data from any REST API directly into Google Sheets. Includes examples for weather, JSON APIs, and handling authentication.
Read more →Use Google Apps Script to automatically pull Calendar events into a Google Sheet. Perfect for time tracking, reporting, and meeting logs.
Read more →Practical Apps Script recipes using the onEdit trigger. Automatically timestamp edits, validate input, send alerts, highlight rows, and react to specific cell changes in Google Sheets.
Read more →Export Google Sheets as PDF files using Apps Script. Customise page size, orientation, and range, then save to Drive or email automatically.
Read more →Use Google Apps Script to automatically validate, clean, and standardise data in Google Sheets. Check for duplicates, fix formatting, flag errors, and enforce data rules.
Read more →Use Google Apps Script to programmatically create, update, and format charts in Google Sheets. Build bar, line, and pie charts from data and embed them in Docs or emails.
Read more →Speed up your Google Apps Script code with these proven performance tips. Minimise API calls, batch reads and writes, use caching, and avoid the most common bottlenecks.
Read more →Deploy a Google Apps Script Web App to handle HTML contact form submissions. Save responses to Google Sheets and send notification emails — no backend server required.
Read more →Create a functional time tracking system in Google Sheets using Apps Script. Clock in/out with a button, calculate hours worked, and generate weekly summaries automatically.
Read more →