In this video, you'll learn how to build a complete inventory system from scratch using Google Sheets and Google Forms—no coding required! We'll create separate forms for products, inputs (purchases), and outputs (sales), and connect them directly to your sheets. You'll discover handy tricks for linking forms and sheets, setting up dropdowns, and using formulas like XLOOKUP, ARRAYFORMULA, and SUMIF to automate your inventory tracking. Perfect for beginners and anyone looking to manage stock efficiently with free Google tools.
You can find the template from this video in my patreon page, where you´ll also have priority responses to your questions
https://practicalsheets.com/patreon
You can also join my academy practicalsheets.com, where you´ll find, not only the templates for this and all the videos, but also Google Sheets Courses, technical service, and more
You can also subscribe to the channel where you´ll find a new Sheets video every week.
Here are some of the places where you can follow and support me:
Patreon: https://practicalsheets.com/patreon
Webpage: https://practicalsheets.com
Newsletter: https://practicalsheets.com/newsletter
Telegram: https://practicalsheets.com/telegram
Facebook: https://practicalsheets.com/facebook
Twitter: https://practicalsheets.com/twitter
Any suggestion, question or insights, feel free to comment below