How to Use GTBuy Spreadsheet: A Complete Step-by-Step Guide

Published May 2026 · 12 min read · 2800+ words

Understanding the Interface Layout

Open any GTBuy template and you will notice an intentional left-to-right flow that mirrors the buying process. The first columns capture discovery: Product Name, Category, and Supplier Link. The middle section handles evaluation: Price, Size Availability, Color Options, and QC Photo Link. The final columns manage fulfillment: Order Date, Shipping Method, Tracking Number, Delivery Estimate, and Final Status.

Hidden helper columns often sit to the right edge. These contain formulas that calculate days since order, flag overdue deliveries, or auto-sort items by priority score. Do not panic if you see unfamiliar formulas. They update automatically and require no manual intervention.

Adding Your First Product Row

Click the first empty row below the example data. Type the product name exactly as it appears on the supplier page. Copy the full supplier URL and paste it into the Supplier Link column. Resist the temptation to abbreviate or use short links. Full URLs preserve tracking parameters and help you locate the exact page weeks later when the product might have moved or been renamed.

Record the listed price in the local currency shown on the supplier site. Add a note in the Price Notes column if volume discounts apply or if you negotiated a special rate. These details matter when you compare the same product across multiple suppliers later.

Using Filters and Sort Views

Filters transform your spreadsheet from a static list into a dynamic intelligence dashboard. Click the filter icon on any column header to show or hide rows based on specific criteria. Want to see only items with status Researching? Filter that column. Need to compare all Jacket options under $150? Apply both a Category filter and a Price filter simultaneously.

Save frequently used filter combinations as Named Views. This feature lets you switch between perspectives instantly: View All Active Orders, View Pending QC Photos, View High-Priority Items, or View Delivered Items Awaiting Resale Listing.

Essential Feature Comparison

Setting Up Automated Alerts

Automation separates occasional users from power users. Start simple: create a conditional formatting rule that turns the Price column red when a value exceeds your budget threshold. This visual cue prevents expensive impulse purchases during late-night browsing sessions.

For intermediate automation, use Google Apps Script to send email notifications when status changes from Ordered to Shipped. Advanced users connect their spreadsheet to Zapier or Make.com, creating workflows that automatically update inventory counts in their resale platform whenever a GTBuy row status changes to Delivered.

Frequently Asked Questions