Ready to Shop Smarter?
Use the cnshopper spreadsheet to track every order, compare prices, and never miss a delivery again. Then head to our main store for the best deals.
Manual updating is fine for ten orders. It becomes a burden at fifty, a chore at two hundred, and a full-time job at five hundred. The solution is automation. This guide shows you how to automate the most repetitive parts of your cnshopper spreadsheet workflow using built-in Google Sheets features and simple scripts. None of these require paid plugins, external software, or advanced programming knowledge.
Automation #1: Auto-Sort New Entries
Every time you add a new order, it appears at the bottom of your sheet. If you sort by Status, your new entry is out of place. A simple Google Apps Script can auto-sort the sheet whenever you edit a row.
Open Extensions → Apps Script. Paste a script that triggers onEdit, reads your sheet, and applies a sort range on your data columns. Set the sort column to your Status column (usually column K). Now every time you type "Shipped" into a cell, that row automatically floats to the top of the Shipped group.
function onEdit(e) { var sheet = e.source.getActiveSheet(); sheet.getRange(2,1,sheet.getLastRow()-1,sheet.getLastColumn()).sort({column: 11, ascending: true}); }Automation #2: Email Alerts for Delays
Delays cost money. The faster you spot a stuck order, the faster you can message your supplier or buyer. A daily trigger script checks every row where Status equals "Delayed" and emails you a summary.
Set the trigger to run once per day at 8 AM. The email subject line reads "CNShopper Delay Alert: 3 orders stuck" with a bullet list of the delayed SKUs. You wake up knowing exactly what needs attention, without opening the sheet.
Automation #3: Data Validation Drop-Downs
Typos in the Status column break your conditional formatting, your sorting, and your summary counts. Data validation fixes this permanently. Select your entire Status column, then Data → Data validation. Set the criteria to "List of items" and enter: Pending, Paid, Shipped, In Transit, Delivered, Delayed, Cancelled.
Now every Status cell has a drop-down arrow. You cannot mistype. Your sorting and conditional formatting never break because of a typo. This is the fastest automation to implement and the one that prevents the most invisible errors.
Automation #4: Import Shipping Data
Manually typing tracking numbers into carrier websites is slow. If your supplier provides a CSV of tracking data, use IMPORTDATA or IMPORTCSV to pull it directly into a new tab. Then use VLOOKUP to match tracking numbers to your order rows automatically.
Automation Effort vs. Reward
| Automation | Setup Time | Time Saved / Week | Skill Level |
|---|---|---|---|
| Data validation dropdowns | 5 min | 30 min | Beginner |
| Auto-sort script | 10 min | 45 min | Beginner |
| Conditional formatting rules | 10 min | 20 min | Beginner |
| IMPORTDATA for tracking | 15 min | 60 min | Intermediate |
| Email delay alerts | 20 min | 90 min | Intermediate |
| Supplier scorecard dashboard | 30 min | 120 min | Intermediate |
| Full Apps Script workflow | 2 hours | 4+ hours | Advanced |
Related Guides
Frequently Asked Questions
What is Apps Script and is it safe?
Can I really save hours per week?
Do I need to know how to code?
Will automation make my sheet fragile?
Start Using the CNShopper Spreadsheet
Whether you are a beginner or a seasoned reseller, the cnshopper spreadsheet is the simplest way to stay organized, save time, and protect your profits.
Download a free template, explore our guides, and start tracking your orders the smart way today.