Advanced GTBuy Spreadsheet Tips for Power Users

The QUERY function is the most powerful tool in Google Sheets that most people never touch.

It lets you build live reports that filter, sort, and summarize your data without manual updates.

Want a list of every order from Supplier A with profit above $50? Use =QUERY(A:L, select * where B = 'Supplier A' and J > 50, 1).

Want your top ten most profitable SKUs this month? Use =QUERY(A:L, select C, sum(J) group by C order by sum(J) desc limit 10, 1).

Want orders that took longer than 14 days to sell? Use =QUERY(A:L, select * where M > 14, 1).

QUERY replaces pivot tables for quick analysis and updates automatically when you add rows.

Learn this one function and you will never manually sort again.

Running out of stock on a hot item is lost revenue.

Overstocking a dead item is tied-up capital.

A smart restock alert solves both.

Add an Inventory tab that tracks current stock, monthly sales velocity, and a Restock Threshold.

Use a formula like =IF(CurrentStock < (Velocity * 2), 'RESTOCK', 'OK') to flag items that need reordering.

For automation, use Google Apps Script to email you a weekly restock report.

The script scans your Inventory tab, collects every row marked RESTOCK, and sends you a formatted email every Monday morning.

This one automation saves hours of manual checking and prevents stockouts during peak selling periods.

Not all suppliers are equal.

Some deliver fast but charge more.

Some are cheap but ship damaged goods.

A supplier scorecard turns gut feeling into data.

Create a Suppliers tab with columns for Name, Avg Delivery Days, Damage Rate, Avg Margin, Communication Score, and Overall Rating.

Use AVERAGEIF to pull delivery and margin data from your Orders tab.

Use COUNTIF to calculate damage rates.

Give each supplier a 1-5 star rating based on weighted scores.

Review this scorecard monthly before placing new orders.

You will quickly see which relationships deserve more volume and which need replacement.

Share this scorecard with your suppliers — it is a powerful negotiation tool.

Apps Script is JavaScript that runs inside Google Sheets.

You do not need to be a programmer to use it.

Copy-paste these simple recipes.

Recipe one: send a daily summary.

The script reads your Dashboard tab and emails you total orders, total profit, and top supplier every morning.

Recipe two: auto-archive old rows.

The script moves rows older than 90 days to an Archive tab, keeping your active sheet fast.

Recipe three: mobile alerts.

The script checks your Inventory tab every hour and sends a Telegram message when stock drops below threshold.

Each recipe takes five minutes to set up and runs forever.

Our automation guide includes the exact code for all three recipes.