Power-user techniques to turn your LoveGoBuy spreadsheet into an automated buying machine. These tips require basic Google Sheets knowledge.
From conditional formatting to automated emails.
Highlight cells in green when a seller price drops below your target. Set up rules in Google Sheets to auto-color rows based on percentage thresholds.
Use =QUERY() to auto-generate a summary of which sellers you buy from most, average price per seller, and total spend breakdowns.
Advanced users can pull live exchange rates or shipping rate cards directly into the spreadsheet via IMPORTJSON() or custom scripts.
Add a column that flags when your total weight is 0.05kg below the next bracket. Remove or swap items to stay under the threshold and save $5-15 per shipment.
Create a lookup table with seller ratings. Auto-populate a trust score column using VLOOKUP against your personal seller database.
Set up live RMB-to-USD conversion using GOOGLEFINANCE("CURRENCY:CNYUSD") so every price updates with the real exchange rate.
Use conditional rules to highlight duplicate product names or URLs. Prevent accidental double-orders when scrolling through long hauls.
Write a Google Apps Script that exports your finalized CSV and drafts an email to your agent with the attachment included.
Never edit your original template directly. Save a master copy with all your custom formulas intact, then duplicate it for each new haul. This protects your work and lets you iterate on improvements over time.
Visit the main site for templates and tools that support advanced automation.