If you are spending more than an hour per week on repetitive spreadsheet tasks, it is time to automate. This guide shows you how to add lightweight automation to your Fishgoo spreadsheet using Google Apps Script — a free tool built into every Google account. No coding background required. Just copy, paste, and watch your workload shrink.
We will cover five automation recipes that our community uses most: daily email summaries, low-stock alerts, automatic status updates, profit threshold notifications, and weekly backup generation. Each script has been tested with real reseller data and includes safety checks to prevent runaway notifications.
Master the basics before automating.
Pro Tips FirstWhy Automation Matters for Resellers
Automation is not about laziness. It is about accuracy and scale. When you manually update 200 order statuses, you will make mistakes. When a script does it, the error rate drops to zero. When you manually check stock levels across five suppliers every morning, you lose an hour. When a script emails you only when stock is low, you get that hour back.
The Fishgoo spreadsheet system is designed to grow with you. Beginners use simple formulas. Intermediate users add conditional formatting and filter views. Advanced users layer on automation scripts that transform their spreadsheet into a self-managing operations hub.
Five Automation Recipes
Recipe 1: Daily Email Summary
Get a morning email with yesterday's new orders, total revenue, and pending count. Open Extensions → Apps Script. Paste the provided function that reads your Orders sheet, aggregates data, and sends an email via MailApp.sendEmail. Set a daily trigger to run at 8 AM.
Recipe 2: Low-Stock Alert
Never miss a restock opportunity. This script checks your Inventory sheet against reorder thresholds and emails you a list of SKUs that need attention. Add a Reorder_Level column, then use a script that loops through rows and sends alerts only when Stock < Reorder_Level.
Recipe 3: Auto-Update Status on Tracking Entry
When you paste a tracking number into the Tracking column, this script automatically changes the Status to Shipped and timestamps the event. Uses onEdit trigger with a simple if-statement checking whether the edited column is the Tracking column.
Recipe 4: Profit Threshold Notification
Receive an instant email when a single order's profit margin drops below your defined threshold. This protects you from pricing errors or unexpected supplier cost increases. Set your threshold percentage in a Settings cell and reference it in the script.
Recipe 5: Weekly Backup Generator
Automatically create a dated backup copy of your entire spreadsheet every Sunday night. This script duplicates the file, appends the date to the filename, and moves it to a BACKUPS folder in your Drive. Set a weekly trigger and sleep soundly.
Automation Complexity Comparison
| Factor | Email Summary | Stock Alert | Auto Status |
|---|---|---|---|
| Setup Complexity | Low | Medium | High |
| Time Saved Weekly | 1 hour | 3 hours | 5+ hours |
| Technical Skill | None | Basic copy-paste | Script editing |
| Maintenance | None | Low | Medium |
| Risk Level | None | Low | Medium |
Safety Rules for Spreadsheet Automation
- Always test scripts on a copy of your spreadsheet before running them on live data.
- Set rate limits in scripts that fetch external URLs to avoid being blocked by supplier websites.
- Use Logger.log() generously during development so you can trace exactly what a script did.
- Never hardcode API keys in scripts. Use Script Properties for secure storage.
- Set conservative trigger frequencies. Daily is usually sufficient; onEveryEdit can cause chaos.
Download Script-Ready Templates
Our advanced templates include pre-built script slots and documentation.
Get TemplatesFrequently Asked Questions
Ready for More?
Explore real examples from resellers who have fully automated their workflow.