HubbuyCN Spreadsheet Automation Guide: Email Alerts, Auto-Backups, and Triggers

Automation 1: Overdue Order Email Alerts

Open your spreadsheet. Click Extensions > Apps Script. Delete the default function and paste a script that loops through your Orders tab, checks the Order Date column, and calculates age using new Date(). If an order is older than 14 days and its Status is not "Arrived" or "Issue," the script sends you an email with the item name and tracking number.

Set the trigger by clicking the clock icon on the left. Choose "Time-driven" and select "Day timer" between 8:00 and 9:00 AM. Now every morning, while you drink coffee, your hubbuycn spreadsheet silently scans for stalled packages. If it finds any, you get an alert. If everything is on track, you hear nothing. Zero noise. Maximum signal.

1. Step 1: Open Extensions > Apps Script
2. Step 2: Write or paste the overdue-check function
3. Step 3: Set MailApp.sendEmail with your address
4. Step 4: Add daily trigger via clock icon
5. Step 5: Authorize script permissions on first run

Automation 2: Weekly Auto-Backup to Google Drive

Data loss is not a matter of if. It is a matter of when. A spilled coffee, an accidental deletion, or a malicious collaborator can erase months of tracking. A weekly backup script creates a timestamped copy of your entire spreadsheet in a dedicated Google Drive folder.

The script uses DriveApp.createFile with the spreadsheet blob. It names the file "Backup_YYYY-MM-DD." It stores it in a folder called "Spreadsheet Backups." Set the trigger to run every Sunday at midnight. You wake up Monday knowing an exact copy of last week's data exists safely outside your working file.

Automation 3: Monday Morning Summary Email

Imagine starting your week with an email that says: "You have 8 active orders, 3 arrived last week, and your monthly spend is $340 against a $500 budget." This script aggregates data from your Summary tab, formats it into an HTML email, and sends it every Monday at 7:00 AM.

The beauty of this automation is that it turns your hubbuycn spreadsheet from a passive recorder into an active advisor. Instead of digging for insights, insights come to you. The script reads your Summary metrics, calculates variance from budget, and flags any orders older than your comfort threshold.

Safety Tips for Running Scripts

Apps Script is powerful but requires care. Never paste code from untrusted sources into your script editor. Malicious scripts can read your data or send spam. Always review code before authorizing permissions. If a script asks for Gmail access, make sure you understand why.

Test every script manually before setting triggers. Click the Run button (triangle icon) and watch the Execution log for errors. If the test succeeds, set the trigger. If it fails, debug first. A broken trigger running daily will spam your inbox or create duplicate backups.