Efficient Asset Tracking Synced with Google Sheets

Asset Tracking Synced with Your Google Sheets

About

Gear App 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 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 App on your phone 📲 to scan barcodes and confirm your items. All data on app synced with Google Sheets in real time.

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.

INVENTORY ON THE GO

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

CUSTOMIZABLE WITHOUT CODING

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

Lightspeed Mobile Barcode Scanning

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

Fully Integrated with Google Sheets

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

Inventory Control with Mobile

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

Manage Multiple Projects

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

Inventory with Collaborators

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

Customer Feedback

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 $80/user $89/user	ENTERPRISE - -
Design Dynamic Forms/Fields				-
No. Of Custom Form Field	2	5	20	-
Item Limit	10	2000	10,000	-
Form Templates Upto	2	4	6	-
Scan Entry Per Month	30	2000	10,000	-
Web & Mobile & Laser Scanner				-
Multiple Devices With One Account				-
Support	Basic Support (Next Day)	Dedicated Support (Same Day)		-
SLA	-	(99.9% Up Time)		-
	Start Free	Subscribe Subscribe	Subscribe Subscribe	Book a Call with Sales

FAQ

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

Gear App 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.

Sandbox

Contact Info

Learn More

Follow Us