Google Apps Script Automation Guide for Business 2027

What is Google Apps Script?

Google Apps Script is a free JavaScript-based platform that lets you automate Google Workspace apps (Sheets, Gmail, Drive, Calendar, Forms). It runs on Google servers — no hosting required.

For Vietnamese businesses, Apps Script can automate daily sales reports, low-stock alerts, customer follow-up emails, and data synchronization between multiple spreadsheets.

Getting Started

Open your Google Sheet, click Extensions, then Apps Script. This opens the script editor in a new tab.

Write your first function, click Run, authorize the script when prompted, and check the Logs (View, Logs) for output.

Key objects: SpreadsheetApp (Sheets), GmailApp (email), CalendarApp (calendar), UrlFetchApp (API calls).

Practical Example: Daily Sales Report Email

This script reads today's orders from the Orders sheet, calculates total revenue, and emails a summary to the manager every evening.

Set up a time-driven trigger to run this function at 6 PM daily. Go to Triggers (clock icon), click Add Trigger, select your function, and set the schedule.

The email includes: total orders, total revenue, top-selling products, and comparison with yesterday.

Practical Example: Low Stock Alert

This script checks inventory levels against minimum thresholds and sends a Telegram notification when any product is running low.

Uses UrlFetchApp to call the Telegram Bot API. You need a Telegram bot token (create via @BotFather) and your chat ID.

Runs every morning at 7 AM via time-driven trigger. Includes product name, current stock, minimum required, and suggested order quantity.

Triggers and Scheduling

Time-driven triggers: Run functions at specific intervals (every minute, hour, day, week).

Event triggers: onEdit (when cell changes), onFormSubmit (when form is submitted), onChange (structural changes).

Quotas: Free accounts get 6 minutes per execution, 90 minutes total per day, and 100 emails per day via MailApp.

SheetStore templates come with pre-configured Apps Script triggers for common automation scenarios.