AppSheet vs. Google Sheets

If you need to manage special assets with unique characteristics and keep data in spreadsheets, Appsheet is ideal for replacing these sheets with a system. Once you start using it, you find yourself trying to move everything into Appsheet. It is perfect for generating internal software that would otherwise never be developed due to programming costs.

Incentivized

Google Sheets is great for just recording tabular information that needs to be shared with and/or edited by multiple people. Sharing and collaborating is especially convenient because Sheets is designed to be browser-based; while Excel has a browser version, it's limited compared to the desktop app. Google Sheets's editing, suggesting, commenting, and viewing permissions settings are absolutely perfect for my department. Google Sheets does not handle large datasets well. It does not load in a timely manner and often freezes. Apps Scripts fail to process large amounts of data.

Incentivized

• Calculations - I have several apps that do some pretty complicated calculations, and decision making to build things like Shopping Lists for a Kanban assembly team, where the app will help a stocker determine whats low in a kanban assembly line stock box.
• Document generation and record keeping - I have an app that users digitally sign and receive PDF contracts, and the system automatically records all records from the transaction. Everything is held in files on YOUR OWN DRIVE (Google Drive) so when you're done with the project or AppSheet you DONT loose your data.
• Client/Customer Management - I follow the old school "Swimming with Sharks" model for client retention and customer engagement, and have built several small customer tracking tools for local businesses. This tool is limited ONLY by your imagine and desire to learn.

Incentivized

• It is a cloud-based platform.
• You can work in the same file simultaneously with your colleagues.
• It allows you to share files much faster.
• It allows you to access your Google Sheet files whenever you like and wherever you like if you have stable internet connection.
• It has great integration with other Google software.
• Google Sheets is very user-friendly and very intuitive to use.

Incentivized

• Once the tables / UX Views get way too many in number, it can become a little daunting to manage. This part of the UX may need something really smarter.
• Ability to Undo.
• Could provide more UI Look and Feel options. BTW, the new Graphs look great, but have some bugs, while the new INPUT() feature is a great addition too.

• Pivot tables are different but could be improved upon; sort, totals, filters
• When entering negative numbers as the first in a formula you need to remember to "+-100+25" instead of "-100+25"
• The power of the internet of course makes it easy to find solution, but the help function is not easily available
• Color coding changes on the cell, but there is not an easy way to click on a cell and use the selected color; like excel

Incentivized

We are still less than 10 users and probably may continue to be so. But, this being a franchisor set up, could be of use to other users like us.

It is easy to use, free of charge for basic functionality, and easy to share with people within or outside your team or company

Incentivized

It's just great. The usability is the best thing about Appsheet. You must choose which things will really be used later. You have to be careful of not generating something too big and then it feels like something that need to be learned. This is something that resolve problems, but you had to be able to think before doing. It will not solve problems itself. You need to find the problem, think a solution, and then use appsheet to make this solution a reality

Incentivized

Overall the formula functions could improve but there's workarounds for them. Utilzing different formulas or approaches for building out accounting schedules. While collebrating with multiple team members and different departments being able to go in and see where others are on the sheets is helpful. Google Sheets overall is a great product

Incentivized

Like most Google products, Google Sheets rarely has outages or slowness, and when it does, connection is always momentarily restored. I can't recall a time when I've been unable to access Google Sheets but able to access other sites just fine. That said, errors aren't uncommon when handling large data volume. You know what they say about using spreadsheets as databases, but sometimes it's just the most convenient option, especially for smaller or one-off projects, and not being able to store large amounts of data hampers our ability to move quickly with scrappy prototypes or full solutions. It would be great if we could better integrate our data manipulation (Apps Script) with big data in the sheet.

Incentivized

Again, Google Sheets is no exception to Google's general high speed and reliability, but load times can be slow for larger amounts of data. I've used Sheets with Zapier and have used the Python API, and speed has never been an issue.

Incentivized

AppSsheet has a support group and they show videos to help app builders. Though I have truck drivers' hours and can't join the webinars. Support groups with better assists me on a Saturday evening or a Sunday that I have time off. It's hard to watch videos driving down the highway.

I have never contacted Google Sheets support, but Google Sheets makes it very easy to report an issue or suggest a feature from Sheets itself (Help > Help Sheets improve), and I've had mostly good experiences with support for other Google products.

Incentivized

I did everything on my own

Incentivized

The ease that AppSheet provides to the developer is limitless. Before starting with AppSheet I used other software, but they didn't give me the tools at my fingertips.
When I learned about AppSheet and everything it could do, I understood that it was what I was looking for, the ease with which everything is related within the app with a few clicks is impressive.

The major reason I use Google Sheets over Microsoft Excel and Apple Numbers is for its ability to allow multiple users to access and work on the same spreadsheet at once. This is incredibly more efficient and effective than updating and sending copies upon copies of the same Excel or Numbers spreadsheet back and forth as email attachments.

Incentivized

I'm not involved with the purchase, but I assume everything goes smoothly and that the pricing structure is predictable and reasonable. We do not get surprise fees.

Incentivized

Google Sheets works very well with multiple users. It's convenient to see in real-time who is collaborating in a sheet, down to the specific cell that they're viewing/editing. Linking Sheets across departments is convenient with the IMPORTRANGE function.

Incentivized

• A good impact in general at the beginning since the free version allows great development so the investment in the implementation is of knowledge and time.
• As a consultant I have expanded my services through this platform including new low code application building services.

• We've used it to prepare quick budgets, presentations for funds that have helped raise money
• It has helped us quickly analyze raw data, collaboratively.
• it has helped us work more efficiently by making it easier to work from one sheet and not lose track of versions by passing around attached documents

Incentivized