Sandbox

Sandbox is a multipurpose HTML5 template with various layouts which will be a great solution for your business.

Contact Info

Moonshine St. 14/05
Light City, London
info@email.com
00 (123) 456 78 90

Learn More

Follow Us

2 mobiles image

Gear Inventory: Asset Tracking Synced with Your Google Sheets

appstore appstore

About Gear Inventory

Gear Inventory is a mobile tool for building barcode inventory apps that sync seamlessly with Google Sheets. In just minutes, you can craft a personalized inventory app and link it to your primary inventory spreadsheet, allowing you to monitor your stock in real-time. It's quick and precise. You can establish an app with asset management features, and the connected Google Sheet serves as your database, permitting you to effortlessly input asset information from any location, be it your warehouse or while you're on the move.

How To Get Started

1/ You've got a list of stuff in Google Sheets 📋 (e.g., thousands of barcode numbers with item names and quantities).
2/ Download the GEAR Inventory app on your phone 📲 and log in with your Gmail account.
3/ Create a form for your inventory project, and it'll set up a GEAR Spreadsheet for you .
4/ Copy your Google Sheets data and paste into the GEAR Spreadsheet.
5/ Use the GEAR Inventory on your phone 📲 to scan barcodes and confirm your items. All data on app synced with Google Sheets in real time.

style

YOUR SHEETS REAL-TIME UPDATE

Record real-time inventory data in Google Sheets, with features like data graphing. Securely store asset data in the cloud.

smartphone-touch-screen

INVENTORY ON THE GO

Manage inventory anywhere with GEAR mobile apps. Seamlessly switch between desktop and mobile.

forms-document-svgrepo

CUSTOMIZABLE WITHOUT CODING

Create customizable inventory templates, control complex inventories, and manage everything from one dashboard.

How To Get Started

Lightspeed Mobile Barcode Scanning

Capture barcode labels quickly, even those as small as 20mm, with our AI/ML-enabled scanner.

How To Get Started banner

Fully Integrated with Google Sheets

Use Google Sheets as your Inventory Database. Sync your Google Sheets with the App.

How To Get Started about new

Inventory Control with Mobile

Use your mobile device as a barcode scanner. Login with Google account and scan the barcode on the go.

style

Manage Multiple Projects

Multiple projects can be managed. Ideal for multiple warehouses or different type of tasks.

How To Get Started image

Inventory with Collaborators

Invite your user to the project. Invited stakeholders can scan barcodes with their phone.

Install Gear Inventory:

Customer Feedback

“It's very easy to use for checking items in
and out. I can use my phone as a barcode scanner,
with no need to buy additional hardware. I can also
set up a real-time protocol with the app,
which is great!”

- Edison P.

Green Dot Public Schools

“I love the fact that it’s all user
friendly, and then it goes right
into the google sheets.”

- Mo P.

MCMT Vending

“It's quite solid in terms of setting
up the features that you want…. connection
with Google Sheets is also good.”

- Matthias D

Dubaere Group

Our Pricing

We offer great prices, premium and quality products for your business.

Enjoy a free 30-day trial and experience the full service. No credit card required!

Yearly

Monthly

Free Plan
Free
Free
Pro Plan
$20/user
$29/user
Pro Plus Plan
$40/user
$49/user
ENTERPRISE
-
-
Design Dynamic Forms/Fields -
No. Of Custom Form Field 2 5 20 -
Item Limit 10 2,000 10,000 -
Form Templates Upto 2 4 6 -
Scan Entry Per Month 20 2,000 10,000 -
Built-in Barcode Scanner -
Multiple Devices With One Account -
Support Basic Support (Next Day) Dedicated Support (Same Day) Dedicated Support (Same Day) -
SLA - -
Start Free
Subscribe
Subscribe
Subscribe
Subscribe
 Book a Call with Sales

Click to see User Guite

User Guide

FAQ

If you don't see an answer to your question, you can send us an email from our contact form.

Gear Inventory is a mobile barcode inventory app builder synced with Google Sheets. You can create a custom inventory app in minutes and connect it to your master inventory spreadsheet to track inventories in real-time.
If you are a small business owner or operator who needs to streamline inventory management with Google Sheets, this app can reduce your 1-hour tasks to just 5 minutes and automate inventory-related tasks. By using your mobile phone as a barcode scanner and our AI-powered barcode scanning technology, you can instantly capture barcodes and record data in the sheet seamlessly.

You need:
1. Personal Gmail or Google Workspace(G Suite) account
2. GEAR(3.0) Mobile App for Android/iOS
3. Laser Barcode Scanner for Desktop and login to GEAR NBS web app via Chrome web-browser.

The app captures ​both 1D and 2D barcodes:
UPC-A, UPC-E, EAN-13, EAN-8, ISBN, ISSN, CODE 39, CODE 128, ITF14, CODE 93, QR CODE, DATAMATRIX, PDF417, AZTEC barcode formats.

Yes. You can manage at least 10 forms on the PRO version, but you may only be able to manage 2 if you are on the free version. If this is the case for you and are in a PRO account, please contact our support team as we will make an adjustment accordingly.

GEAR for Google Workspace(G Suite) has a few advantages, such as; (1)Manage accessible users to the app. (2) Assets are centrally managed within an admin's google sheet. Your Google Workspace administrator must install the app on your domain. If you want to use the app with multiple users, it's best to choose Google Workspace accounts as each user logs in and records activities within a system of logging. GEAR NBS for personal Gmail: If you just want a single person to use the app, the easiest way is to create a personal gmail for your project (ie. yourproject@gmail.com).

GEAR for Google Workspace(G Suite) has a few advantages, such as; (1)Manage accessible users to the app. (2) Assets are centrally managed within an admin's google sheet. Your Google Workspace administrator must install the app on your domain. If you want to use the app with multiple users, it's best to choose Google Workspace accounts as each user logs in and records activities within a system of logging. GEAR for personal Gmail: If you just want a single person to use the app, the easiest way is to create a personal gmail for your project (ie. yourproject@gmail.com).

When you grant data access to GEAR, then GEAR has API access to specific data like your Google account and Google Drive/Docs. GEAR is able to view and utilize that data, but is not able to store any of your data. GEAR just leverages your Google Drive and Google Docs. All of your data is safely saved in Google Cloud Platform.

When granting GEAR access to your data, you're giving it API access. This enables the app to view and utilize specific data like your Google account and Google Drive/Docs. However, no information is stored in any of its databases because this is all done on Google Cloud Platform's servers so that everything can be accessed from anywhere with an internet connection.

The app operates on top of Google Sheets, and utilizes the security features offered by Google App Engine. Your asset data is saved in your Google Sheets and never on our servers.

If you are a Google Workspace(G Suite) user, the app needs to be installed through Google Workspace Marketplace. Your admin can install it and can assign you to access it. If you are a G Suite Super Admin and have installed the app but get this error message, visit admin console, Security > API Reference and enable API access.

In the History tab in our google sheet, it shows GMT timezone only as a default. So if users are from different time zones, it always displays UTC for them.

Please check the following.

1. If you are using the web app: Do you have multiple accounts logged into your browser? If so, log out, delete cookie/caches, then re-log in.

2. Does the form field title include a symbol? (For instance, ?, #, -,!) In this case, submission errors may occur. Delete the symbols via form editing.

3. If there are invalid values in Google Sheet, it may not be synchronized properly. For example, invalid data on a cell, such as double lines or blank space on non-item rows.

4. If the name of the first row of sheet is not in line with a form field title., or if the order of the form field and the column order are mismatch.

5. It could be due to internet connection. To find a solution to the problem or troubleshooting, there are two options.

[v] Check the revision history of this sheet and delete any invalid data or revert to an earlier version if necessary.

[v] Create an additional GEAR Form and see if the issue is reproducible.

If the issue still persists despite the above, please back up your sheet by making a copy and contact our GEAR support at support@getgear.io ask for 'reset' so you can start over.

If you don't have a sheet tab associated with the form, it won't be deleted whether or not it deletes properly. For example, if you have a form called "ABC Inventory Project", there must also be an existing sheet with the same name. In this case, you create a sheet tab by naming them "ABC Inventory Project" for now and try to delete the form again. If the issue still occurs despite the above, please contact our support at support@getger.io

If you use the Image field, your thumbnail URL will be expired due to Google's security reasons.

To handle this issue, make sure your thumbnail URL is a universal link for google drive.

Go to your Google Drive and change your image permission to Anyone on the internet with this link can view .

Under the ThumbnailURL column, change the url to this format: https://drive.google.com/thumbnail?authuser=0&sz=w220&id=[fileid]

For example, if your Image column has; https://drive.google.com/file/d/1fp9BVppa6OEteJCgzATFmoH2YGID39xP/preview

Paste the following URL under ThumbnailURL: https://drive.google.com/thumbnail?authuser=0&sz=w220&id=1fp9BVppa6OEteJCgzATFmoH2YGID39xP

Go back to the app and rescan the code and you will see that thumbnail image is displayed properly.