Hubbuycn Spreadsheet Automation Guide

Auto-Archive Sold Items

The most requested automation is moving sold rows to an Archive tab automatically. A simple Google Apps Script watches your Status column. Whenever a row changes to Sold, the script cuts that row and appends it to the Archive tab, keeping your active sheet lean.

Daily Backup Email Script

Google Sheets keeps version history, but a daily email backup gives you peace of mind and an offline copy. A simple trigger script emails you a PDF snapshot of your sheet every morning. The script uses the built-in MailApp service and requires no external APIs.

• Set a time-driven trigger to run daily at 6 AM
• The PDF attachment includes all tabs in one file
• Add your email address to the script recipients list
• Store PDFs in a dedicated Gmail label for easy retrieval

Low Margin Alert System

A script can scan your active rows every hour and email you if any item has a margin below your target. This prevents you from accidentally listing a product at a loss or missing a price drop that kills profitability. Set your threshold in a dedicated Threshold cell so you can adjust it without editing code.

Weekly Summary Report

Instead of manually calculating weekly profit, orders placed, and items sold, let a script do it. The script reads your Orders tab, filters by date range, and emails you a formatted summary every Monday morning. It takes five minutes to read and gives you instant insight into weekly performance.

When Not to Automate

Automation is powerful but not always worth the setup. If you process fewer than thirty orders per month, manual updates are probably faster than writing and debugging scripts. Automation pays off when the time saved per week exceeds the setup time within one month. For most resellers, that threshold is around fifty orders monthly.