Superbuy Spreadsheet Automation Guide: Save Hours Every Week

The ultimate goal of any tracking system is to require as little of your time as possible. Automation is the bridge between manual tracking and a self-running system. With the right setup, your superbuy spreadsheet can update itself, alert you to changes, and even send reports without you touching a single cell.

This guide covers eight automations you can build today, ranging from 2-minute formula tricks to 45-minute script setups. Every automation is explained step-by-step, with zero assumptions about your technical skill level.

Automation Comparison: Setup vs. Payoff

Automation #1: Status Change Email Alerts

Never miss a delivery again. This Google Apps Script watches your Status column and sends you an email whenever a row changes to "Delivered" or "Shipped".

To set it up: Extensions > Apps Script. Paste a simple onEdit trigger script that checks the edited column and row. If the status changed, sendEmail fires. The script takes about 30 minutes to set up and runs forever after that.

Automation #2: Auto-Archive Delivered Orders

Your main sheet gets cleaner over time instead of messier. A daily trigger script scans for rows with status "Delivered" and moves them to an "Archive" sheet. The main sheet stays lean, and your archive stays complete.

This is especially useful for resellers with hundreds of orders. A clean main sheet means faster loading, faster filtering, and less visual noise.

Automation #3: Tracking Number Auto-Linking

The fastest 2-minute automation on this list. Instead of pasting raw tracking numbers, use the HYPERLINK formula to make them clickable.

Formula: =HYPERLINK("https://www.17track.net/en/track?nums="&K2, K2) turns the tracking number in cell K2 into a clickable link to 17track. One click, instant tracking. No more copy-paste into carrier websites.

Automation #4: Monthly Spending Report

A monthly email that tells you exactly how much you spent, how many orders you placed, and your average order value. Built with QUERY, SUMIF, and a timed Apps Script trigger.

The report uses the QUERY function to pull this month only, then formats the results into a clean email. Set the trigger to run on the first of every month. Wake up to a spending summary in your inbox.

Automation #5: Duplicate Order Detection

Accidentally ordering the same item twice is a common and expensive mistake. Conditional formatting catches it instantly. Select the Order ID column, then Format > Conditional formatting > Custom formula: =COUNTIF($A$2:$A, A2)>1.

Any duplicate Order ID turns bright red the moment you paste it. The catch is instant, before the duplicate order even ships.