I will build an automated inventory dashboard in google sheets
Data Analyst Automation AI
About this Gig
Struggling to keep track of your stock? Let me automate it in Google Sheets.
I build custom inventory systems that update themselves, so you always know what's in stock, what's running low and what to reorder, with no manual counting.
What you get:
- Master stock database with SKUs, categories and variations
- Automatic stock levels calculated from Goods In and Goods Out logs
- Low-stock alerts with color-coded reorder thresholds
- Visual dashboard showing inventory value and top-selling items
- Daily email alert with your restock list (Premium, via Apps Script)
Who it's for:
E-commerce sellers, retail shop owners, dropshippers and small warehouses.
Why work with me:
- Clean, easy-to-use sheets, even for non-technical users
- Built in your own Google account, so you fully own it
- Clear communication and on-time delivery
Before ordering, please message me with:
- Roughly how many products you have
- How you track stock today (paper, Excel or another sheet)
Stop guessing your stock levels. Message me today!
Technology:
Google Sheets
My Portfolio
FAQ
Do I need to pay for any software?
No. Everything runs in Google Sheets, which is free with any Google account.
Can you work with my existing spreadsheet or Excel file?
Yes. Share it with me and I'll clean it up and build the system around your current data.
Will I be able to use it without technical knowledge?
Yes. You'll only fill in simple rows, and the formulas and automation do the rest. Premium also includes a setup video.
Will the automation keep working after delivery?
Yes. The Apps Script runs inside your own Google account, so it keeps working without me.
Do you need access to my Google account?
No. I build the sheet and share it with you, or you give me edit access to just that one file.

