Advanced Oopbuy Spreadsheet Tips for Power Users

Tip 1: Auto-Import Tracking from Gmail

Use Google Apps Script to scan your inbox for shipping confirmation emails and auto-populate tracking numbers into your sheet. Set it to run every hour and you will never manually copy a tracking link again.

Tip 2: Build a Seller Scorecard

Create a separate tab that pulls data from your main sheet using QUERY() functions. Calculate average delivery time, QC pass rate, and price per category for every seller you use. This makes vendor selection data-driven instead of guesswork.

Tip 3: Set Slack Alerts

Connect your spreadsheet to Slack via Zapier. Get instant notifications when a status changes to "Delivered" or when an order sits in "Pending" for more than 14 days. Never babysit your sheet again.

Tip 4: Visual Dashboard with Data Studio

Link your Google Sheet to Google Data Studio and build a visual dashboard showing monthly spend, delivery timelines, and category breakdowns. Perfect for resellers who need to present data to partners or for tax reporting.

Tip 5: Archive Old Orders Automatically

Use a script that moves rows with "Delivered" status and order dates older than 90 days to a separate "Archive" sheet. Keeps your active sheet lightning fast while preserving full history.