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 →Build an automated approval workflow using Google Forms, Sheets, and Apps Script. Trigger emails on form submit, let approvers respond, and update status columns automatically.
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 →Learn how to send WhatsApp messages directly from Google Sheets using the WhatsApp Business API (via Twilio or Meta) and Google Apps Script.
Read more →Build reusable, data-driven HTML email templates using Google Apps Script. Use HtmlService templates, pass dynamic data, and send beautifully formatted emails from Sheets.
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 →Automate weekly reporting with Google Apps Script. Pull data from Google Sheets, generate a formatted HTML email report, and send it to stakeholders every Monday morning.
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 →